Data

PostgreSQL for Developers

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

  • Intermediate
  • 2h 13m
  • 4 modules
  • 12 lessons
  • 11.9k students
Start course

Taught by Daniel Okafor · TypeScript, PostgreSQL, API design, Data modelling

Cover image for PostgreSQL for Developers

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 modules · 2h 13m

  1. 01SQL EssentialsThe query constructs that cover the overwhelming majority of real application SQL.19m
    1. 1.1SELECT and joinsFree5m
    2. 1.2Aggregates and GROUP BY6m
    3. 1.3CTEs and window functions8m
  2. 02Schema DesignModelling data so the database enforces your rules instead of hoping the application does.20m
    1. 2.1Normalisation and when to break it4m
    2. 2.2Constraints, keys, and integrity4m
    3. 2.3Data types and JSONB13m
  3. 03Query PerformanceFinding the slow query, understanding why it is slow, and fixing the actual cause.23m
    1. 3.1How indexes work5m
    2. 3.2Reading EXPLAIN ANALYZE10m
    3. 3.3Tuning a slow query8m
  4. 04Operating PostgresTransactions, schema change, and the operational habits that keep production boring.1h 11m
    1. 4.1Transactions and isolation levels8m
    2. 4.2Schema migrations without downtime32m
    3. 4.3Backups and connection pooling31m
Start with the first lesson