PostgreSQL Database Administrator

Learn to operate self-managed PostgreSQL: architecture, configuration, roles, query planning, vacuum, backups and point-in-time recovery, streaming replication, read replicas, high availability, and incident routines. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

180 interactive lessons across 6 units · 36+ hours · advanced level

What you will learn

Build practical skills in PostgreSQL, Database Administration, Operations, Backups, Replication, High Availability through browser-based coding exercises, guided feedback, unit quizzes, a debugging challenge, and a final project.

Course access

Unit 1, including its first 30 lessons and unit quiz, is free. The remaining 5 units require a CodeLearning365 Pro subscription.

View Pro access options

PostgreSQL Database Administrator curriculum

The curriculum progresses from foundations to applied practice and mastery. Representative topics from every unit are listed below.

Unit 1: Foundations

30 lessons covering topics such as PostgreSQL Process and Memory Architecture, Cluster Initialization and Service Layout, Configuration Sources and Safe Reloads, Client Authentication with pg_hba.conf, Role Membership and Least Privilege.

PostgreSQL Process and Memory Architecture
Cluster Initialization and Service Layout
Configuration Sources and Safe Reloads
Client Authentication with pg_hba.conf
Role Membership and Least Privilege

Unit 2: Core Concepts

30 lessons covering topics such as Power Up 031: Cluster Initialization and Service Layout, Power Up 032: Configuration Sources and Safe Reloads, Power Up 033: Client Authentication with pg_hba.conf, Power Up 034: Role Membership and Least Privilege, Power Up 035: Database, Schema, and Ownership Boundaries.

Power Up 031: Cluster Initialization and Service Layout
Power Up 032: Configuration Sources and Safe Reloads
Power Up 033: Client Authentication with pg_hba.conf
Power Up 034: Role Membership and Least Privilege
Power Up 035: Database, Schema, and Ownership Boundaries

Unit 3: Building Skills

30 lessons covering topics such as Power Up 061: Configuration Sources and Safe Reloads, Power Up 062: Client Authentication with pg_hba.conf, Power Up 063: Role Membership and Least Privilege, Power Up 064: Database, Schema, and Ownership Boundaries, Power Up 065: MVCC, Transactions, and Long Snapshots.

Power Up 061: Configuration Sources and Safe Reloads
Power Up 062: Client Authentication with pg_hba.conf
Power Up 063: Role Membership and Least Privilege
Power Up 064: Database, Schema, and Ownership Boundaries
Power Up 065: MVCC, Transactions, and Long Snapshots

Unit 4: Applied Practice

30 lessons covering topics such as Power Up 091: Client Authentication with pg_hba.conf, Power Up 092: Role Membership and Least Privilege, Power Up 093: Database, Schema, and Ownership Boundaries, Power Up 094: MVCC, Transactions, and Long Snapshots, Power Up 095: Index Types and Workload Fit.

Power Up 091: Client Authentication with pg_hba.conf
Power Up 092: Role Membership and Least Privilege
Power Up 093: Database, Schema, and Ownership Boundaries
Power Up 094: MVCC, Transactions, and Long Snapshots
Power Up 095: Index Types and Workload Fit

Unit 5: Projects

30 lessons covering topics such as Power Up 121: Role Membership and Least Privilege, Power Up 122: Database, Schema, and Ownership Boundaries, Power Up 123: MVCC, Transactions, and Long Snapshots, Power Up 124: Index Types and Workload Fit, Power Up 125: Reading EXPLAIN Plans.

Power Up 121: Role Membership and Least Privilege
Power Up 122: Database, Schema, and Ownership Boundaries
Power Up 123: MVCC, Transactions, and Long Snapshots
Power Up 124: Index Types and Workload Fit
Power Up 125: Reading EXPLAIN Plans

Unit 6: Mastery

30 lessons covering topics such as Power Up 151: Database, Schema, and Ownership Boundaries, Power Up 152: MVCC, Transactions, and Long Snapshots, Power Up 153: Index Types and Workload Fit, Power Up 154: Reading EXPLAIN Plans, Power Up 155: Autovacuum and Dead-Tuple Cleanup.

Power Up 151: Database, Schema, and Ownership Boundaries
Power Up 152: MVCC, Transactions, and Long Snapshots
Power Up 153: Index Types and Workload Fit
Power Up 154: Reading EXPLAIN Plans
Power Up 155: Autovacuum and Dead-Tuple Cleanup

Continue learning with a related course

MySQL DBA coding course — Learn to operate self-managed MySQL with InnoDB: architecture, configuration, users and roles, query plans, buffer pool and redo maintenance, backups and point-in-time recovery, GTID replication, read replicas, high availability, and incident routines. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.
Oracle Database Administrator coding course — Learn to operate self-managed Oracle Database: multitenant architecture, instance memory, Oracle Net, users and roles, ASM and tablespaces, RMAN recovery, Data Guard, read-only standby operations, RAC, patching, performance diagnosis, and daily maintenance. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.
JavaScript Fundamentals coding course — Build a confident JavaScript foundation with variables, functions, collections, and asynchronous code. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

Compare all coding tracks