Structured Learning,
Designed for Busy Professionals
Each workshop is a focused 3-hour live online session built around a single high-impact PostgreSQL theme. The format is designed for professionals who want deep, practical knowledge without committing to multi-day training. Clear objectives, guided walkthroughs, and real examples ensure every session delivers immediately applicable skills.
Live Interaction with Expert Guidance
Participants learn in real time and can ask questions throughout the session, ensuring concepts are fully understood — not just demonstrated. Interactive explanations, practical demonstrations, and instructor feedback transform complex database topics into actionable techniques you can apply the same day.
Complete Learning Package
with Fixed Schedule
Every full workshop registration includes the complete edition of The Art of PostgreSQL, allowing participants to extend learning beyond the session. Workshops run on a fixed calendar, making planning simple for individuals and teams who want structured, predictable skill development.
Turn complex analytics into elegant SQL by mastering ranking, moving averages, and advanced reporting patterns.
Build powerful summary queries and reporting datasets without fragile or slow SQL.
Design schemas that scale by aligning data structures with real-world workloads.
Master complex joins, lateral joins, and set operations to simplify sophisticated data retrieval.
Discover practical techniques to rewrite inefficient SQL into fast, production-grade queries.
Learn to read query plans like a performance engineer and instantly spot why queries are slow.
Timeless Database Engineering Principles
The Art of PostgreSQL remains highly relevant because it focuses on timeless database design principles, performance thinking, and practical SQL techniques that transcend specific version features.
Practical Skills That Still Apply
While written for PostgreSQL 11, the core architecture, query optimization strategies, indexing approaches, and data modeling practices it teaches continue to apply directly to modern PostgreSQL releases.
Future-Proof Learning Investment
A curated review of new PostgreSQL features is forthcoming to inform a future edition, but this update is not yet scheduled—making the current book an immediately valuable resource for developers who want durable expertise rather than version-specific checklists.
Choose the format that fits your learning goals—from a single focused session to the full workshop series or a private team package.
Join the workshop series à la carte by registering for any one session from the six available in the current cohort calendar. Each session is a focused 3-hour live webinar dedicated to a specific PostgreSQL topic, combining practical instruction, demonstrations, and live Q&A.
This option is ideal if you want to deepen a particular skill or explore the training format before committing to the full series.
Get the complete learning experience by enrolling in the full 6-session workshop series. This option gives you access to every session in the cohort calendar at a 15% discount, effectively giving you one session free compared to purchasing tickets individually.
It’s the best-value option for participants who want a coherent learning path across key PostgreSQL topics, ensuring deeper understanding, continuity between sessions, and the maximum return on your training investment.
PURCHASEBook a private set of three workshops exclusively for your team. Choose the sessions that best match your needs from the program, and benefit from a dedicated environment where examples, discussions, and Q&A can be oriented toward your team’s real-world challenges.
The format remains a structured workshop—not consulting—ensuring a focused learning experience while still allowing participants to connect the material to their own systems, queries, and operational questions.
PENDINGThe content is drawn from years of real-world PostgreSQL consulting, operations, and performance tuning. Instead of theoretical SQL, you’ll learn the methods professionals use in production systems.
Registration includes the full edition of The Art of PostgreSQL — a comprehensive reference you can continue to use long after the workshop ends.
Each session delivers focused expertise that would normally require days of trial and error to acquire. Participants leave with practical SQL patterns, performance techniques, and a deeper understanding of how PostgreSQL really works.
Learn how to express complex analytical queries—ranking, moving averages, cohort analysis—using PostgreSQL window functions. This workshop turns what often feels like “advanced SQL magic” into clear, repeatable techniques you can apply immediately.
Go beyond basic joins and learn patterns that simplify complex data retrieval. From lateral joins to efficient multi-table strategies, you’ll gain tools that dramatically improve both query clarity and performance.
Transform raw data into meaningful insights with robust aggregation techniques. This session focuses on practical reporting queries, reliable GROUP BY patterns, and ways to avoid common performance traps.
Good performance starts with good schema design. Learn how to model data structures that align with query workloads, reducing complexity and ensuring PostgreSQL can scale efficiently with your application.
Understand what PostgreSQL actually does when executing your queries. This workshop teaches you how to read EXPLAIN and EXPLAIN ANALYZE output so you can diagnose slow queries with confidence.
Discover practical methods to rewrite inefficient SQL into fast, production-ready queries. You’ll learn a systematic approach to identifying bottlenecks and improving performance without guesswork.
Each workshop is delivered as a concentrated 3-hour online session designed for maximum signal and minimal time commitment. Expect practical demonstrations, clear explanations, and techniques you can apply immediately.
Every session includes time for live questions, allowing participants to clarify concepts and connect the material to their own real-world database challenges.
Workshops are led by the author of The Art of PostgreSQL, a well-known PostgreSQL practitioner and international conference speaker who has taught these techniques to developers and teams worldwide.
Not convinced yet? Get a FREE chapter including the full Table of Contents!