The PostgreSQL administration field guideField notes · Runbooks · Free certification

Progress · Production Operator

Your course progress

See what you have completed, what is still to do, and the clearest next step towards your free PostgreSQL certification.

Loading next step…

Course completion

Modules
— of 15
Stages
— of 5

Loading your saved course progress…

Your progress and unpublished certificates are visible only when you are signed in. You choose if and when a verification page becomes public.

What’s done and what’s next

Course modules

Complete the three learning sections, pass the real SQL lab and module assessment, then receive that module’s certificate.

CompleteIn progressNot started
Stage 1

PostgreSQL foundations

Loading saved progress…
Loading
  1. 1.1

    Architecture and system model

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  2. 1.2

    Safe SQL and data integrity

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  3. 1.3

    Roles, privileges, and access security

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
Stage 2

Query performance and concurrency

Loading saved progress…
Loading
  1. 2.1

    Index design and access paths

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  2. 2.2

    Query plans and performance diagnosis

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  3. 2.3

    Transactions, locks, and deadlocks

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
Stage 3

Routine production operations

Loading saved progress…
Loading
  1. 3.1

    Connections, configuration, and memory

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  2. 3.2

    MVCC, vacuum, autovacuum, and bloat

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  3. 3.3

    Monitoring, capacity, and operational health

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
Stage 4

Backup and recovery

Loading saved progress…
Loading
  1. 4.1

    WAL, checkpoints, and storage behaviour

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  2. 4.2

    Backup strategy and validation

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  3. 4.3

    Restore and point-in-time recovery

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
Stage 5

Production readiness

Loading saved progress…
Loading
  1. 5.1

    Replication, lag, and failover readiness

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  2. 5.2

    Incident diagnosis and response

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…
  3. 5.3

    Safe changes, upgrades, and handover

    Loading
    Learning
    — of 3 complete
    SQL lab + assessment
    Loading
    Certificate
    Loading
    Loading next step…

Final certification

Production Operator credential

After all 15 module certificates, pass the applied capstone and final exam independently to earn the full two-year credential.

01

All 15 modules

Loading
02

Applied capstone

Loading
03

Final exam

Loading
04

Full credential

Loading

Returning practice

Your operator toolkit

Come back to these runbooks, references, and repeatable labs whenever you need to refresh a skill or respond to a real problem.