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.
Window Functions
Learn to run analytics without collapsing rows using PostgreSQL window functions. You will master OVER, PARTITION BY and ORDER BY, ranking with ROW_NUMBER/RANK/DENSE_RANK, row-to-row comparisons with LAG and LEAD, and running totals and moving averages with explicit frames.
Views, Materialized Views & Functions
Learn to encapsulate and reuse query logic in PostgreSQL using views, materialized views and functions. You will create and update views, cache expensive queries with materialized views and REFRESH, write parameterised SQL functions, and choose the right tool for each job so your database logic stays clean and reusable.
Triggers & Event-Driven Logic
Learn to automate data integrity and auditing in PostgreSQL with triggers. You will write trigger functions in PL/pgSQL, choose BEFORE/AFTER and ROW/STATEMENT timing correctly, use NEW and OLD to validate and transform data, and build a reusable audit-log trigger — while avoiding recursion, ordering and performance pitfalls.
Subqueries & Common Table Expressions
Learn to compose complex SQL queries clearly in PostgreSQL by nesting scalar, row and table subqueries, using IN/EXISTS/ANY/ALL, mastering correlated subqueries, and refactoring tangled logic into readable Common Table Expressions. You will finish able to break a hard reporting question into named, testable steps and even walk hierarchies with recursive CTEs.
Stored Procedures & PL/pgSQL
Write server-side database logic in PostgreSQL using PL/pgSQL. You will build functions that return scalars, rows and sets, write procedures with transaction control, handle errors with exception blocks and RAISE, and judge when logic belongs in the database rather than the application.
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.
Security, Roles & Backup
Administer a PostgreSQL database securely from end to end — manage roles and privileges, enforce row-level security, lock down connections through pg_hba.conf, and take dependable logical and physical backups. You will finish able to grant least privilege, protect data in transit, and restore a cluster to a chosen point in time.
Replication, Scaling & High Availability
Learn to run PostgreSQL in production — configure streaming replication and read replicas, choose between synchronous and asynchronous commit, plan failover, pool connections with PgBouncer, partition large tables, and monitor the metrics that keep a cluster healthy. You finish able to design and operate a resilient, scalable PostgreSQL deployment.
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.
JSON, Arrays & Full-Text Search
Work confidently with semi-structured data in PostgreSQL — store and query JSONB, index it with GIN, model repeated values with arrays, and build a real full-text search. You will finish able to choose between relational and document modelling and ship queries that are both correct and fast.
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.