The best way to make the modules stick is to build something. These five projects take you from schema design and SQL queries through indexing and query performance, a FastAPI app on PostgreSQL, backup and restore, and finally streaming replication.
Each one is a code-along video, so you can pause, type it out yourself and adapt it to your own ideas. Pick the project that matches the module you've just finished and come back for the rest.
Install PostgreSQL, then design a schema for a social media site: create tables, add constraints, insert data, and query across tables with joins.
Connect a FastAPI application to PostgreSQL with SQLAlchemy and manage the data through pgAdmin.
Back up a database with pg_dump, restore it with pg_restore, and learn the useful options and psql commands along the way.
Configure a primary and a replica, start streaming changes between them, and test that the replication works.