PostgreSQL Essentials for Python Developers & Web Hosting

Name: PostgreSQL Essentials for Python Developers & Web Hosting
Rating: 4.0 (27 reviews)

The All in One PostgreSQL Class

Created byLucas Mayrhofer

Last updated 10/2025

English

What you'll learn

PostgreSQL
Python-Psycopg2
How to build and host an interactive website on digital ocean with a PostgreSQL database

Course content

8 sections • 52 lectures • 1h 49m total length

What you will learn in this class?2:05
Introduction video who explains the content tought in this class

Introduction0:37
Store and read Data in Python with text files5:15
This lecture is about writing and reading from text files in python. Text files are very simple way to store and use data with python. But this is recommended only for simple use cases and simple datastructures as we will see later in the course.
Store and read Data in Python with excel files: pandas4:30
This Lecture is about writing and reading excel files with python using the pandas library. This is a useful way of storing and using data in python. Your system needs to have an excel spreadsheet reader like gnumeric for example and pandas library installed. Installation process is explained as well.
Store and read Data in Python using json files4:50
What is a Database and what are the use cases?1:45
Definition of a Database , classification of the different types of databases and presentation of the most common use cases for databases.
What are the different Linux databases?0:38
This is a small list and description of the most common databases available on the market today.
Why use databases ?2:10
This Lecture is about the advantages of Databases compared to other methods showed previously like text files and excel files. The main drawback compared to these other methods is maybe the complexity. But this class is here to make sure you know how to use databases efficiently for your purpose.

Install PostgreSQL on Debian Linux , and start database2:04
How to install PostgreSQL on Debian Linux and start the database. You will also learn how to stop the database and check the status of database ( if it is active or inactive)
Create and Delete Users1:53
How to create and delete postgres Users.
Create and Delete Databases2:35
How to create and delete PostgreSQL Databases with concrete example.
Dump and Restore Databases5:16
How to dump and restore databases in order to transfer databases between different computer systems.

SQL commands: Introduction0:38
CREATE/DROP TABLE1:29
How to create and delete a PostgreSQL table
PRIMARY KEY2:37
What are Primary Keys and why do you need primary keys? A concrete example is given.
INSERT INTO0:55
How to Insert new values inside a PostgreSQL table.
SELECT1:52
How to Select content from a table.
UPDATE1:41
How to update values in a table.
DELETE1:19
CREATE/DROP INDEX0:58
How to create and drop an Index
SELECT DISTINCT2:26
How to select distinct values from a table.
ORDER BY4:40
How to Order your query search results.
GROUP BY0:09
How to group query search results.
BETWEEN1:25
Lecture about BETWEEN keyword.
JOIN2:20
Lecture about JOIN keyword.
LIMIT1:13
Lecture about LIMIT keyword.
EXISTS2:44
Lecture about EXISTS keyword.
FOREIGN KEY0:56
What are Foreign Keys? And how do you use one?
GRANT0:21
How to Grant privileges on a database to a user.
COUNT1:02
How to count the number of rows satisfying a certain property.
MAX, MIN ,AVG1:40
Lecture about the MAX, MIN and AVG keywords.
SUM1:10
How to SUM values of a column.
SQL SUBQUERY2:02
What is an SQL SUBQUERY and an example of how to use one.
OFFSET0:31
IN and NOT IN operators1:00
LIKE0:54
ALTER TABLE1:23

Introduction0:32
Install and Setup your LAPP stack ( Linux Apache PostgreSQL Php) on the cloud10:48
This lecture teaches you how to install a Linux Apache Postgresql Php stack to host a website on the cloud. After this lecture you will be able to put your first static website online on the cloud. For database Interaction and configuration you need to check out lecture 35.
Interacting with the Database7:52
In this lecture we learn how to configure the different configuration files ( php.ini, pg_hba.conf ...) to put your website online and make sure the interaction between database and client is working smoothly. We give a small example website with database that let's the user write a link and link name inside our database. We explain the php and html code carefully. First example of a dynamic website on the cloud!

Requirements

Linux command line

Description

Are you ready to master one of the world’s most powerful open‑source databases? This hands‑on course will teach you how to install, configure, and use PostgreSQL for both web development and Python‑based applications. Whether you’re building interactive websites or integrating PostgreSQL into data‑driven software, this course gives you the practical skills to succeed.

You’ll start by learning PostgreSQL fundamentals: installation, essential SQL commands (creating, updating, and managing tables), and an overview of PostgreSQL’s rich data types. From there, you’ll dive into real‑world applications—including how to host a fully functional, interactive website on the cloud using PostgreSQL, PHP, and HTML. We’ll walk step‑by‑step through configuring a Linux web server for PostgreSQL, allowing users to submit inputs to a live database that dynamically updates your site.

Finally, you’ll explore Python and PostgreSQL integration using Psycopg2, enabling you to build more advanced data‑driven projects and automate database operations.

This course is beginner‑friendly yet practical, ideal for developers, aspiring data engineers, and anyone interested in web hosting or database‑driven applications.

Prerequisites: Basic Linux command‑line knowledge and familiarity with Python (and optional PHP basics for the web hosting project).

By the end, you’ll be confident using PostgreSQL for real applications—from small web projects to complex data workflows

Who this course is for:

Beginner database engineers or web devellopers.
Anyone who wants to build his own interactive website

PostgreSQL Essentials for Python Developers & Web Hosting

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Data Storage and Usage in Python7 lectures • 20min

PostgreSQL Databases4 lectures • 12min

PostgreSQL Data Types7 lectures • 8min

SQL commands25 lectures • 37min

Databases for Web Hosting3 lectures • 19min

Python and Postgresql with psycopg24 lectures • 11min

Bonus Lecture1 lecture • 1min

Requirements

Description

Who this course is for: