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.

Intermediate2h 13m4 modules11.9k students

What you'll learn

code

Write serious SQL

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

layers

Design a schema that lasts

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

gauge

Make queries fast

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

shield

Operate it safely

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

Course Content

4 modules · 2h 13m

Your Progress

0% complete

Continue Learning