Vertex

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

Start learning

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.

Tracklist

4 modules · 2h 13m

  1. 1SQL EssentialsThe query constructs that cover the overwhelming majority of real application SQL.18m 56s
    1. Lesson 1.1SELECT and joinsFree preview5m 4s
    2. Lesson 1.2Aggregates and GROUP BY6m
    3. Lesson 1.3CTEs and window functions7m 52s
  2. 2Schema DesignModelling data so the database enforces your rules instead of hoping the application does.20m
    1. Lesson 2.1Normalisation and when to break it3m 33s
    2. Lesson 2.2Constraints, keys, and integrity3m 53s
    3. Lesson 2.3Data types and JSONB12m 34s
  3. 3Query PerformanceFinding the slow query, understanding why it is slow, and fixing the actual cause.23m 2s
    1. Lesson 3.1How indexes work4m 33s
    2. Lesson 3.2Reading EXPLAIN ANALYZE10m 17s
    3. Lesson 3.3Tuning a slow query8m 12s
  4. 4Operating PostgresTransactions, schema change, and the operational habits that keep production boring.1h 11m
    1. Lesson 4.1Transactions and isolation levels8m 18s
    2. Lesson 4.2Schema migrations without downtime31m 33s
    3. Lesson 4.3Backups and connection pooling31m 12s