Fleet training command
Learn PostgreSQL properly.
In your browser. For free.
A real PostgreSQL 18 server compiled to WebAssembly runs inside this tab. Nothing is sent anywhere, there is no account, and every lesson gets its own throwaway database — so you can break things on purpose. The path does not stop at joins: it goes through window frames, recursive CTEs, JSONB, upserts, query plans and PL/pgSQL.
Available now
- 01
Signal Acquisition
Pull rows out of a table and bend them to your will.
0/7 - 02
Instruments & Units
Text, numbers, dates and the casts between them.
0/4 - 03
Fleet Statistics
Collapse many rows into one number — correctly.
0/5 - 04
Docking Procedures
Combine tables without losing rows you meant to keep.
0/5 - 05
Nested Transmissions
Queries inside queries, and the set algebra between them.
0/5 - 06
Route Plotting
Name your intermediate results — then let them call themselves.
0/5 - 07
Sensor Windows
Aggregate without collapsing — the chapter the free courses skip.
0/7 - 08
Hull Design
Schemas that make bad data impossible.
0/8 - 09
Pattern Recognition
The analytical shapes that recur in every real job.
0/6 - 10
Cargo Manifests
Semi-structured data, natively.
0/7 - 11
Writing to the Log
Changing data without losing any.
0/6 - 12
Engine Efficiency
Ask the planner what it is about to do, and understand the answer.
0/6 - 13
Airlock Protocol
Transactions, and what isolation actually buys you.
0/6 - 14
Ship Automation
Logic that lives in the database.
0/7 - 15
Postgres Proper
The features that are the reason to pick Postgres.
0/7 - 16
Living Schema
Give a query a name, and change a table nobody will let you take offline.
0/5