Course catalog

The eight-course PGPRO PostgreSQL training catalog.

less than a minute

Course codes and topic order follow the official public handouts. Each course is an independent OINK Book.

DBA1: Basic PostgreSQL Administration

Installation, server architecture, basic configuration and day-to-day PostgreSQL administration.

MVCC, WAL, locks, extensions, localization, monitoring and upgrades.

Logical and physical backup, WAL archiving, physical and logical replication, and cluster architectures.

Roles, membership, row-level security, authentication, SSL and external identity integration.

SQL and PL/pgSQL functions, procedures, triggers, dynamic commands and server-side logic.

Extensions, custom types, operator classes, asynchronous processing, full-text search and FDW.

Postgres Pro Enterprise features for performance, security, backup and high availability.

Query planning and execution, access methods, joins, statistics and practical query tuning.