Independent, vendor-neutral open source certifications
Credential verification Sign in

Home / Training / DB-OPS-PSQL

Free Not started DB-OPS-PSQL

PostgreSQL Administrator Exam Training

Build a PostgreSQL 16 lab from scratch, then practice roles, replication, backups, performance tuning, and security tasks aligned with the DB-OPS-PSQL exam objectives.

PostgreSQL 16 22 modules ~7 hr 12 min Multipass practice VM
PostgreSQL Administrator exam badge

What you will practice

This self-paced course prepares you for the DB-OPS-PSQL performance-based certification. Work through hands-on modules on your own Ubuntu VM, then enroll when you are ready for exam day.

Course outline

Foundation

  1. Size and launch your practice VM Launch Ubuntu 24.04, verify host capacity, and create your lab directory tree. · ~22 min
  2. Cluster layout after install Install PostgreSQL 16, start the cluster, and record version, port, and data directory. · ~20 min
  3. Connecting with psql Open local peer and TCP sessions and run non-interactive psql commands. · ~18 min
  4. Essential psql meta-commands Navigate catalogs with backslash commands, help, timing, and saved output. · ~22 min
  5. SHOW and catalog queries Read live settings with SHOW and inspect pg_settings and pg_roles. · ~18 min
  6. PostgreSQL paths on Ubuntu Locate configuration, data, and log files for the 16/main cluster. · ~18 min
  7. Managing PostgreSQL with systemd Start, reload, and restart the cluster and read service logs. · ~20 min
  8. psql commands for administrators Describe objects, inspect privileges, and capture command output for your notes. · ~18 min
  9. Editing configuration safely Find settings in postgresql.conf, edit as root, and verify with SHOW. · ~20 min

Core skills

  1. Creating login roles Create application and read-only login roles with passwords and connection limits. · ~20 min
  2. Database ownership Provision a practice database owned by your application role and confirm with psql. · ~18 min
  3. Verifying lifecycle objects Confirm roles, ownership, and login behavior before schema work. · ~18 min
  4. Schema deployment Apply DDL and seed data to a practice database using reusable SQL files. · ~22 min
  5. Grants and default privileges Grant table access to application and read-only roles and set default privileges. · ~20 min
  6. Indexes, views, and reporting Create indexes, reporting views, and aggregate queries on your practice schema. · ~22 min
  7. postgresql.conf parameters Enable connection and DDL logging and verify with SHOW after reload. · ~20 min
  8. Understanding pg_hba.conf Add a host rule for password authentication and reload PostgreSQL safely. · ~18 min
  9. listen_addresses and TCP connectivity Prove TCP password authentication and compare conninfo from peer and TCP sessions. · ~20 min
  10. Logical backups with pg_dump Export a practice database in custom and plain SQL formats. · ~18 min
  11. Restore workflow Restore a custom dump to a new database and verify row counts. · ~20 min
  12. VACUUM and planner statistics Run VACUUM ANALYZE on a busy table and inspect statistics and logs. · ~18 min
  13. WAL archiving Configure archive_mode and archive_command and confirm WAL segments copy. · ~22 min

Before you begin

New to local VMs? Read the Multipass setup guide before your first module. The foundation modules walk you through creating pgsql-practice for this course.