Write serious SQL
Joins, aggregates, CTEs, and window functions, without reaching for the ORM every time.

SQL you will actually write, schemas that hold up, indexes that get used, and the operational basics behind them.
Joins, aggregates, CTEs, and window functions, without reaching for the ORM every time.
Normalise sensibly, use constraints as guarantees, and pick the right data types.
Read a query plan and add the index that plan is asking for.
Transactions, migrations, backups, and pooling — the parts that matter at 3am.
4 modules2h 13m