The Course That Picks Up Where the Book Leaves Off
Built from years of teaching PostgreSQL to working developers. Six courses, three tiers — from solid SQL foundations to production-grade data system design.
Three tiers — Core, Advanced, Architect — each building on the previous one.
Join the CourseFrom solid foundations to system design. Choose the level that matches your goals — Core, Advanced, or Architect. Each tier builds on the previous one, adding deeper capabilities and modules.
paid yearly
Learn PostgreSQL the right way
Build a solid foundation in PostgreSQL by learning how to think in SQL, not just write it. This tier focuses on clarity, correctness, and essential patterns that make your queries easier to read, maintain, and extend.
You'll learn how to structure queries properly, use advanced SQL features with confidence, and avoid common pitfalls. This is the level where SQL stops being a tool and becomes a language you can rely on.
| All 6 courses: Window Functions, Aggregation, Schema Design, Advanced JOINs, Query Optimization, Read Query Plans | |
| 6 modules per course 36 modules total | |
| Hands-on labs and quizzes for every module | |
| The Art of PostgreSQL book included | |
| Money-back guarantee — no questions asked |
No-questions-asked refund
paid yearly
Understand performance and execution
Go beyond writing correct SQL and learn how PostgreSQL actually executes your queries. This tier focuses on performance: reading query plans, understanding the optimizer, and identifying bottlenecks.
You'll develop a systematic approach to making queries faster and more predictable. Instead of guessing, you'll understand why a query is slow and how to fix it using proven techniques.
| Everything in Core, plus: | |
| +1 advanced module per course 42 modules total | |
| Performance-focused depth: query plans, optimizer behavior, advanced indexing, join strategies | |
| Hands-on labs and quizzes for every module | |
| The Art of PostgreSQL book included | |
| Money-back guarantee — no questions asked |
No-questions-asked refund
paid yearly
Design systems that scale
At this level, PostgreSQL becomes part of your system design, not just a database. You'll learn how to model data, structure queries, and make architectural decisions that impact performance and scalability.
This tier focuses on trade-offs: when to denormalize, how to design for real workloads, and how to balance complexity, performance, and maintainability. It's about making decisions you can justify in production.
| Everything in Advanced, plus: | |
| +1 architect module per course 48 modules total | |
| System design depth: partitioning, large-scale schemas, performance budgeting, systemic diagnostics | |
| Hands-on labs and quizzes for every module | |
| The Art of PostgreSQL book included | |
| Money-back guarantee — no questions asked |
No-questions-asked refund
The book gave you the SQL toolkit. The course shows you how to use it in production: when to denormalize, how to read query plans systematically, how to design schemas that actually scale.
Same author. Same teaching style. More depth, more practice, ongoing updates.
Three tiers — Core, Advanced, Architect — each building on the book's foundations.
Your book purchase counts toward the course as a separate value — no double-pay, no awkward upgrade dance.
Master Window Functions, Reliable Aggregation, Data Modeling for Performance, Advanced JOIN Techniques, Query Optimization Fundamentals, and Read Query Plans — each course is 8 modules across Core, Advanced, and Architect tiers.
Browse the full 48-module curriculum →OVER, PARTITION BY, frame clauses, sessionization. The SQL feature most developers underuse.
02GROUP BY semantics, GROUPING SETS, FILTER, ordered-set aggregates, and correctness traps.
03Normal forms, primary keys, index design, schema evolution, and JSONB for semi-structured data.
04Join semantics, fan-out amplification, LATERAL, WITH RECURSIVE, and complex query composition.
05How PostgreSQL executes queries, bottleneck detection, query rewriting, and indexing strategy.
06EXPLAIN anatomy, plan node types, row estimate mismatches, and a complete diagnostic workflow.
No theory for theory's sake. Every technique is immediately applicable to your work.
Content designed from years of consulting and real-world system optimization.
Skip the trial and error. Get the systematic approach that works.
Quizzes, downloadable resources, and hands-on exercises to reinforce learning.
The course includes The Art of PostgreSQL in full. You get the complete reference, always available as you go through the material.
✓ 590 pages of deep PostgreSQL knowledge ✓ Real-world examples and exercises ✓ Included with your subscription
They're complementary. The book is the reference; the course is the structured path that takes you from reading to applying. If you found the book useful, the course is the natural next step.
Developers and database administrators who want to master PostgreSQL. Whether you're building new applications or optimizing existing systems, this course gives you the practical skills that matter.
Most courses teach SQL syntax. This course teaches you to think in SQL, understand how PostgreSQL executes your queries, and write code that's both simpler and faster. It's the system I wish I'd had when I started.
The full curriculum, hands-on labs, quizzes, and slide decks for all 6 courses are available today. Video lessons are rolling out through Q3 2026. The Art of PostgreSQL book is included at every tier.
The course is a yearly subscription. As long as your subscription is active, you get full access to all current content plus everything added during your subscription year — new modules, updated content in existing modules, and entirely new courses (typically once or twice a year).
If your subscription lapses, you lose access to the course platform. You can resubscribe at any time at the then-current price.
Six courses — Master Window Functions, Reliable Aggregation, Data Modeling for Performance, Advanced JOIN Techniques, Query Optimization Fundamentals, and Read Query Plans — each with 8 modules across Core, Advanced, and Architect tiers. Browse the full 48-module curriculum →
Six courses. Three tiers. Real production skills.
Not convinced yet? Get a FREE chapter including the full Table of Contents!