Intermediate5 projects

PostgreSQL

Go past basic CRUD into indexing, transactions, and migrations that survive production.

37+

completed

~14.5h

total time

projects

Part 1·Beginner·2.5h·37+ learners

PostgreSQL Fundamentals

Install PostgreSQL, understand its process architecture and write-ahead log, and get comfortable with schemas, types, and newer PostgreSQL 18 features.

Start

Part 2·Intermediate·3h·33+ learners

Indexing and Query Optimization

Learn to read EXPLAIN ANALYZE output and build the right index for the query you actually have.

Start

Part 3·Intermediate·2.5h·28+ learners

Transactions and Isolation Levels

Reproduce the classic concurrency bugs — dirty reads, non-repeatable reads — and see exactly which isolation level fixes each.

Start

Part 4·Advanced·3.5h·24+ learners

Replication and High Availability

Set up real streaming and logical replication between PostgreSQL instances for read scaling and failover.

Start

Part 5·Intermediate·3h·19+ learners

Database Migrations at Scale

Learn why a routine ALTER TABLE can take down a production database, and how to migrate safely instead.

Start