# Course catalog

> The eight-course PGPRO PostgreSQL training catalog.

---

LLMS index: [llms.txt](/en/llms.txt)

---

<!-- Generated by scripts/generate_skeleton.py. -->

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

## [DBA1: Basic PostgreSQL Administration](/en/dba1/)

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

- Topics: 17
- Baseline: English

## [DBA2: Configuration and Monitoring of PostgreSQL](/en/dba2/)

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

- Topics: 18
- Baseline: English

## [DBA3: Backup and Replication](/en/dba3/)

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

- Topics: 9
- Baseline: English

## [DBS: PostgreSQL Security Basics](/en/dbs/)

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

- Topics: 8
- Baseline: Русский

## [DEV1: Basic Server-Side Application Development](/en/dev1/)

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

- Topics: 21
- Baseline: English

## [DEV2: Advanced Server-Side Application Development](/en/dev2/)

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

- Topics: 21
- Baseline: Русский

## [PGPRO: Postgres Pro Enterprise Features](/en/pgpro/)

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

- Topics: 23
- Baseline: Русский

## [QPT: Query Performance Tuning](/en/qpt/)

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

- Topics: 17
- Baseline: English