Lessons

Short, hands-on Postgres exercises. Sign in to run them in your own sandbox and track your progress.

Start here

Begin with Module 1 — SELECT basics (8 min). Sign in when you're ready to run SQL in a live sandbox.

Query fundamentals

beginnerModule 1

Changing data

beginnerModule 2

Combining tables

beginnerModule 3

Schema and modeling

intermediateModule 4

01
Data types
14 mindata-types · numeric · boolean · enum · identity
02
Dates and times
15 mintimestamptz · interval · time-zone · date-trunc · extract
03
Constraints
14 minconstraints · primary-key · foreign-key · check · unique
04
DDL and schemas
14 minddl · create-table · alter-table · drop-table · schemas · search-path
05
Normalization
15 minnormalization · normal-forms · keys · relationships · junction-table

Intermediate querying

intermediateModule 5

Postgres power types

intermediateModule 6

Performance and indexing

advancedModule 7

Programmability

advancedModule 8

Concurrency

advancedModule 9

Expert and operations

advancedModule 10