Cover image for PostgreSQL for Developers

PostgreSQL for Developers

SQL you will actually write, schemas that hold up, indexes that get used, and the operational basics behind them.

Taught byDaniel OkaforTypeScript · PostgreSQL · API design · Data modelling
Intermediate2h 13m4 modules11.9k students

What you’ll learn

Write serious SQL

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

Design a schema that lasts

Normalise sensibly, use constraints as guarantees, and pick the right data types.

Make queries fast

Read a query plan and add the index that plan is asking for.

Operate it safely

Transactions, migrations, backups, and pooling — the parts that matter at 3am.

Course Content

4 modules2h 13m