11/ 11·5 lessons·2 h 55 min

Use cases

End-to-end capstones with integration tests that tie the whole course into working apps: building the Brew schema, a price-and-promo engine (PG18 temporal), an app anti-patterns clinic, pooling from the app (pgbouncer caveats), and the CDC seam — a byte-compatible handoff into kafka-cookbook.

Start module→Continue · Capstone: build the Brew schema→Reread module→
/ lessons

Lessons

5 lessons · 2 h 55 min
  1. 01Capstone: build the Brew schema↳ continue from here#capstone#constraints#explain40m
  2. 02Price-and-promo engine↳ continue from here#temporal#without-overlaps#exclude35m
  3. 03App anti-patterns clinic↳ continue from here#n-plus-1#keyset#non-sargable35m
  4. 04Pooling from the app↳ continue from here#pooling#pgbouncer#advisory-lock30m
  5. 05The CDC seam: handoff to kafka-cookbook↳ continue from here#cdc#logical-replication#publication35m