Database master
From your first SELECT to reading query plans.
At the end: Design schemas, write fast queries and keep data correct under load.
Stage 1: SQL
The language every database speaks.
- SQL from zero: Queries, joins, aggregates and window functions.
Stage 2: Postgres in depth
What happens inside.
- Postgres in depth: Indexes, transactions, locks and plans.
- Postgres with Drizzle: Postgres from application code, with migrations.
Stage 3: Beyond SQL
When a key-value store is the right tool.
- Redis: Data structures, caching and streams.
Stage 4: Interview ready
The bugs interviewers ask about.
- SQL traps: Queries that return wrong answers quietly.
- Concurrency and races: Lost updates and how to prevent them.