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.
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.
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.
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.
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.