Integrate everything from Modules 0-7 into substantial projects that demonstrate deep database expertise. These projects serve as portfolio pieces and interview talking points.
This course unlocks once you've finished its prerequisite. Open prerequisite →
Build the Query Performance Analyzer first. It solves a real problem you have today -- slow queries in production that you diagnose with ad hoc EXPLAIN ANALYZE runs and gut instin…
Work through each item before the checkpoint.
Build the tool a DBA reaches for: it reads pgstatstatements, ranks the slowest queries, parses their EXPLAIN (ANALYZE, BUFFERS) plans into a tree, and tells you — with evidence — …
Event sourcing done honestly: an append-only PostgreSQL event store as the single source of truth, aggregates that replay their history to decide anything, a CQRS read model rebui…
Build your own strongmigrations — and go further. A safety analyzer that reads migration source and flags the operations that lock tables, a duration estimator that knows which op…
5 lessons. Read in order; spiral back when you need to. By the end you'll have used the core ideas twice — once on the abstract, once on something you'll meet at work next week.