- Design a nightly e-commerce pipeline (45 min) — sources, volume math, batch vs micro-batch, warehouse layout, backfill story.
- CDC at scale (30 min) — watermark gaps, log-based capture, ordering, exactly-once vs at-least-once + dedup.
- The DAG that pages you (30 min) — retries, idempotency, SLA/alerting, partial-failure semantics.
- Warehouse cost clinic (25 min) — partitioning, clustering, slot/query pricing, reading a query plan.
- Streaming mini-design (25 min) — Kafka -> Bronze/Silver/Gold, late data, watermarks in the streaming sense.
Each video ends with a 5-minute whiteboard drill: draw the architecture from memory, then state two trade-offs and one failure mode.