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.
SQL Basics — Querying Data
Learn to retrieve exactly the data you need from a PostgreSQL database using SELECT, WHERE, ORDER BY and friends. You will filter rows precisely, handle NULLs safely, match text patterns, and shape result sets so a query returns the right columns in the right order.
Modifying Data — INSERT, UPDATE, DELETE & Transactions
Learn to change data safely in PostgreSQL — adding rows with INSERT, correcting them with UPDATE, removing them with DELETE and TRUNCATE, and merging with UPSERT. You will wrap risky changes in transactions with BEGIN, COMMIT, ROLLBACK and savepoints so every modification is deliberate and reversible.
Joins & Relationships
Learn to combine data across tables in PostgreSQL with confidence — INNER, LEFT, RIGHT and FULL joins, self and cross joins, and the relationships behind them. You will model one-to-many and many-to-many data, write correct multi-table queries, and avoid the accidental Cartesian products that silently corrupt results.
Introduction to PostgreSQL & Setup
Get PostgreSQL installed on any operating system and learn to connect with the psql client, create your own databases and users, and navigate the object hierarchy with confidence. You walk away able to install, connect to and move around a real PostgreSQL database — the foundation every later skill builds on.
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.