One Course
Every lesson, project and mock exam in PostgreSQL for engineers.
Billed monthly. Cancel any time.
Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Learn PostgreSQL by writing SQL against a database running in your browser. Start with tables and queries, then practice indexes, query plans, JSONB and access policies. Projects and case studies connect those skills to backend engineering work.
Unit 1, Query foundations: 5 lessons and 24 checked exercises, with no account or card.
Start the free unitThe rest of the course opens with a One Course or All Access plan. See plans and prices
Choose access here. Your course is already selected.
Harbor Parts' controller needs an order-quality audit before a monthly close.
6 steps · 45 minProject · IntermediateDispatch workload indexesField Repair's service owner has supplied six access patterns for its dispatch queue.
6 steps · 45 minProject · IntermediateSupport search serviceSignal Dispatch's support lead needs a searchable article interface and a separate event-tag lookup.
6 steps · 45 minProject · IntermediateDispatch reporting interfaceHarbor Parts' dispatch manager wants a reusable report of open work with customer names, missing-amount flags and daily queue totals.
6 steps · 45 minCase study · AdvancedSlow customer reportField Repair's controller received a customer report whose total changed after a performance rewrite.
6 steps · 45 minProject · AdvancedTransfer ledgerSignal Dispatch's finance engineer needs an atomic account transfer with a durable local ledger record.
6 steps · 45 minProject · AdvancedCompatible status migrationHarbor Parts is replacing its order status representation while old readers still depend on status.
6 steps · 45 minProject · AdvancedRetained partition archiveField Repair needs January removed from its live event parent while retaining the January table for an audit.
6 steps · 45 minProject · ExpertTenant access auditSignal Dispatch's service owner needs evidence that tenant-specific order reports can't read another tenant's rows.
6 steps · 45 minMock exam · ExpertTimed test: backend PostgreSQLComplete an original backend job-test set in 50 minutes.
12 questions · 50 minMock exam · ExpertTimed test: PostgreSQL operationsComplete an original production-engineering set in 55 minutes.
12 questions · 55 minPractice PostgreSQL through PGlite with original operating data. Start with queries, types, constraints and safe writes. Build indexes for a workload, query JSONB, search documents and publish live or materialized reports. Read real EXPLAIN ANALYZE plans, inspect statistics and tune filters without changing their meaning. Later units cover snapshots, locks, retries, compatible migrations, partition retention, database functions, triggers and tenant access. Nine projects and cases carry your SQL through a complete deliverable. Interviews at three levels and two timed job tests review the work. Two-session traces use a labeled deterministic model because the embedded engine has one connection. Backup, replication and pooling decisions state their operational limits.
Beginner
Read operational tables without changing their grain.
Choose PostgreSQL types and enforce a relational contract.
Change only intended rows and preserve atomic work.
Intermediate
Build indexes that match filters and ordering.
Query JSONB and publish searchable support articles.
Publish reusable reports without hiding stale results.
Advanced
Read real plans and tune a report without changing its answer.
Reason about snapshots and prevent conflicting updates.
Expand schemas and maintain date partitions with checked boundaries.
Expert
Encapsulate calculations, audit changes and constrain access.
Choose recovery, replication and pooling strategies with explicit limits.
Defend PostgreSQL decisions and complete two timed job tests.
A query can return the expected rows while the schema still permits broken records. Work through types and constraints first, then check how inserts, updates and transactions behave when a required value is missing or two requests compete for the same row.
Use the exercise guide for an original runnable example. Keep the SQL cheat sheet beside you for syntax, or review interview questions when you need to explain a decision aloud.
EXPLAIN ANALYZE executes a query and reports its plan. Browser timing is useful for understanding that plan, but it is not a benchmark for a production server. The index workload project asks you to connect an index choice to the query it serves.
For general SQL patterns, continue with SQL. Pair the database work with Java or Python engineering when your next task is application code.
No. SQL exercises run in PGlite, a WebAssembly build of PostgreSQL, inside your browser. You use original fictional data.
PGlite has one connection. Isolation and locking exercises use a labeled session simulator. It models the taught transaction schedules; it does not run a production database cluster.
Backup, replication and pooling lessons teach operational decisions with checked scenarios. They do not create server replicas, run an external backup utility or open a production connection pool.
Our assessments use original questions and do not award an EDB or PostgreSQL credential. Read the certification guide before choosing an external exam.
The first unit is free. Access to later units follows the plan shown on the pricing page.