Master the world's most advanced open-source database.
PostgreSQL Professional — 15 courses from SQL basics to production administration: querying, table design, joins and aggregation, CTEs and window functions, indexing and performance, PL/pgSQL, triggers, JSON, security, backup and replication. Every course carries 10 hands-on exercises with solutions.
Indexes & Query Performance
Learn to diagnose and speed up slow PostgreSQL queries. You will understand how B-tree and other index types work, read EXPLAIN and EXPLAIN ANALYZE plans to find the real bottleneck, and design composite, partial and covering indexes while keeping tables healthy with VACUUM and ANALYZE.
Data Types & Table Design
Learn to design well-structured PostgreSQL tables: pick the right data type for every column, model relationships correctly, and enforce data quality with keys and constraints. You will finish able to translate a real-world requirement into a clean, normalised schema that keeps bad data out.
Aggregation & Grouping
Turn raw rows into the summaries a report needs — counts, totals, averages and per-category breakdowns — using PostgreSQL's aggregate functions, GROUP BY and HAVING. You will finish able to summarise data for reporting, filter groups correctly, count distinct values and produce subtotals with ROLLUP.