Data and query

PostgreSQL tutorial

Learn practical relational modelling and robust SQL with PostgreSQL.

Start first lesson Open PostgreSQL workspace

postgresql16 lessons

SELECT category, COUNT(*)
FROM lessons
GROUP BY category;

Designed forBackend and data learners

Learning formatShort explanations, examples, practice connections

Source privacyCompiler text remains inside your browser

COURSE CURRICULUM

16 lessons in a clear order

Finish one section at a time or jump directly to a concept you need.

Foundations

PostgreSQL clusters, databases, schemas, and clients

Learn how postgresql clusters, databases, schemas, and clients works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

SELECT, aliases, casts, and readable clauses

Learn how select, aliases, casts, and readable clauses works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Core concepts

Parameters, expressions, generated columns, and sessions

Learn how parameters, expressions, generated columns, and sessions works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Rich types, arrays, JSONB, ranges, and NULL

Learn how rich types, arrays, jsonb, ranges, and null works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Operators, functions, collations, and indexing choices

Learn how operators, functions, collations, and indexing choices works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Control flow

CASE, filters, transactions, and row security

Learn how case, filters, transactions, and row security works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Set operations, recursive CTEs, and lateral work

Learn how set operations, recursive ctes, and lateral work works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Data and composition

Aggregate, scalar, date, JSON, and array functions

Learn how aggregate, scalar, date, json, and array functions works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Joins, grouping sets, subqueries, and CTEs

Learn how joins, grouping sets, subqueries, and ctes works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Text search, regular expressions, and collation

Learn how text search, regular expressions, and collation works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Reliability and structure

Constraints, transactions, MVCC, and locking

Learn how constraints, transactions, mvcc, and locking works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Views, functions, extensions, indexes, and schemas

Learn how views, functions, extensions, indexes, and schemas works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Applied engineering

Keys, normalization, relationships, and partitions

Learn how keys, normalization, relationships, and partitions works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

COPY, backups, replication, and migrations

Learn how copy, backups, replication, and migrations works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Window functions, EXPLAIN ANALYZE, and query tests

Learn how window functions, explain analyze, and query tests works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Capstone

Capstone: a robust PostgreSQL data service

Learn how capstone: a robust postgresql data service works in PostgreSQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.