PostgreSQL Tutorial

Learn how to use event triggers to capture DDL changes in PostgreSQL. This lesson explains the core concept, walks through practical examples, and covers troubleshooting and best practices.

Learn to validate data with check constraints in PostgreSQL. This lesson covers the core concept, step-by-step implementation, hands-on exercises, troubleshooting, and what to study next.

Learn how to use foreign data wrappers in PostgreSQL to query external data sources as if they were local tables. This lesson covers the core concepts, step-by-step implementation, and practical use cases.

Stream changes with logical decoding — PostgreSQL Tutorial. Learn to capture and apply real-time data changes using PostgreSQL's logical decoding feature.

Extend PostgreSQL with custom types in this practical tutorial — understand the core concept, apply it hands-on, and prepare for the next lesson.

Learn to upgrade PostgreSQL with pg_upgrade. Practical steps, troubleshooting, and what to study next.

Learn to tune autovacuum settings to prevent table bloat in PostgreSQL. This hands-on lesson covers core concepts, step-by-step configuration, troubleshooting, and best practices.

Set up connection pooling with PgBouncer to reduce PostgreSQL connection overhead. Learn the core concepts, step-by-step configuration, hands-on practice, and troubleshooting.

Learn how to identify and optimize slow PostgreSQL queries using the pg_stat_statements extension. This lesson covers enabling the extension, reading its key statistics, and interpreting the data to find performance bottlenecks.

Learn how to use Common Table Expressions (CTEs) to simplify complex PostgreSQL queries. This lesson covers the core concepts, step-by-step implementation, practical examples, and debugging tips to help you write cleaner, more maintainable SQL.

Write window functions for analytics — PostgreSQL Tutorial. Learn to use OVER(), PARTITION BY, and ROW_NUMBER() for running totals, rankings, and moving averages in this practical lesson.

Learn to implement full-text search indexes in PostgreSQL. This lesson covers the core concepts, step-by-step setup, practical examples, and common pitfalls to help you improve search performance.