Courses
Expert

PostgreSQL Administration Advanced v15

nazmulitbd nazmulitbd
Overview
Curriculum
  • 1 Section
  • 25 Lessons
  • 40h Duration
Collapse All
PostgreSQL DBA Training v15
25 Lessons
  1. 1. Introduction & Architectural Overview (2h)
  2. 2. System Architecture (3h)
  3. 3. MVCC – Multi-Version Concurrency Control (2h)
  4. 4. PostgreSQL Installation (2h)
  5. 5. User Tools – Command Line Interfaces (2h)
  6. 6. Database Clusters (2h)
  7. 7. Configuration (2h)
  8. 8. Data Dictionary (1h)
  9. 9. Creating & Managing Databases (2h)
  10. 10. Database Security (2h)
  11. 11. Monitoring & Admin Tools Overview (2h)
  12. 12. Backup, Recovery & PITR (3h)
  13. 13. pgBackRest (4h)
  14. 14. Routine Maintenance Tasks (1h)
  15. 15. Moving Data Using COPY (1h)
  16. 16. Replication & High Availability Tools (3h)
  17. 17. High Availability Deep Dive (2h)
  18. 18. Disaster Recovery (3h)
  19. 19. Database Monitoring (1h)
  20. 20. SQL Tuning (2h)
  21. 21. Performance Tuning (2h)
  22. 22. Benchmarking (1h)
  23. 23. PostgreSQL Extensions (1h)
  24. 24. Connection Pooling (1h)
  25. 25. Upgrading Best Practices (1h)

PostgreSQL Administration Advanced v15 Training Program (40 Hours)

Trainer: Nazmul Hoque Bhuiyan
(PostgreSQL DBA – 8+ Years Experience)

Mobile: +8801711264147 (WhatsApp)

📘 Course Description

This training program is designed to provide hands-on, production-grade expertise in PostgreSQL, focusing on real-world database administration, high availability, and performance optimization.

Participants will gain practical knowledge in:

  • Installing and configuring PostgreSQL environments
  • Managing enterprise-scale databases
  • Implementing High Availability (HA) and Disaster Recovery (DR)
  • Performing performance tuning and troubleshooting
  • Operating PostgreSQL confidently in production environments

🎯 Training Objectives

By the end of this course, participants will be able to:

  • Design and manage PostgreSQL production environments
  • Implement backup, recovery, and DR strategies
  • Configure and manage replication and HA setups
  • Tune database performance and optimize queries
  • Troubleshoot real-world database issues effectively

⏱️ Course Duration

Total: 40 Hours

📚 PostgreSQL Administration Advanced v15 Training Course Outline

  1. Introduction & Architectural Overview (2h)
  • PostgreSQL Community overview
  • Use cases & ecosystem
  • High-level architecture
  1. System Architecture (3h)
  • Process model (postmaster, backend processes)
  • Memory structure (shared buffers, work_mem, etc.)
  • Storage (heap, index, TOAST)
  • WAL internals

 

  1. MVCC – Multi-Version Concurrency Control (2h)
  • MVCC concepts
  • Transaction IDs (XID) & snapshots
  • Visibility rules
  • VACUUM interaction
  1. PostgreSQL Installation (2h)
  • Installation methods (RPM, APT, source)
  • Cluster initialization (initdb)
  • Environment setup (PGDATA, PATH)
  • Community vs Enterprise overview
  1. User Tools – Command Line Interfaces (2h)
  • psql usage
  • Utilities (pg_ctl, pg_dump, pg_restore)
  • Basic scripting
  1. Database Clusters (2h)
  • Cluster concept
  • Cluster vs database vs schema
  • Directory structure
  1. Configuration (2h)
  • postgresql.conf
  • pg_hba.conf
  • Logging and auditing setup
  1. Data Dictionary (1h)
  • System catalogs
  • Metadata queries
  1. Creating & Managing Databases (2h)
  • Databases & schemas
  • Tables, indexes, constraints
  • Data types
  1. Database Security (2h)
  • Roles & privileges
  • Authentication methods  
  1. Monitoring & Admin Tools Overview (2h)
  • System views
  • Logs & alerts
  • Tools overview (pgAdmin)

 

  1. Backup, Recovery & PITR (3h)
  • Logical backups (pg_dump, pg_restore)
  • Physical backups (base backup)
  • WAL archiving
  • Point-in-Time Recovery (PITR)
  1. pgBackRest (4h)
  • Architecture overview
  • Installation and configuration
  • Full, differential, incremental backups
  • Backup from standby
  • Restore process and validation
  1. Routine Maintenance Tasks (1h)
  • VACUUM / AUTOVACUUM
  • ANALYZE
  • REINDEX
  1. Moving Data Using COPY (1h)
  • COPY import/export
  • Bulk data handling
  1. Replication & High Availability Tools (3h)
  • Streaming replication
  • Logical replication
  • HA tools overview (Patroni, repmgr, Pgpool-II)
  1. High Availability Deep Dive (2h)
  • Physical vs streaming replication
  • Synchronous vs asynchronous replication
  • Install and configure HA using repmgr
  • Failover and switchover
  1. Disaster Recovery (3h)
  • DR concepts and planning
  • Barman overview
  • pgBackRest in DR architecture
  • PITR and failover scenarios
  • DR setup using pgBackRest
  • DR rebuild using backup (full restore and standby rebuild)
  1. Database Monitoring (1h)
  • Metrics & query statistics
  • Alerting basics

 

  1. SQL Tuning (2h)
  • EXPLAIN & ANALYZE
  • Query optimization
  • Index tuning
  1. Performance Tuning (2h)
  • Memory tuning
  • I/O tuning
  • Connection tuning
  1. Benchmarking (1h)
  • pgbench usage
  • Load testing fundamentals
  1. PostgreSQL Extensions (1h)
  • Extension usage
  • Popular extensions (pg_stat_statements etc.)
  1. Connection Pooling (1h)
  • PgBouncer
  • Pgpool-II
  • Pooling strategies
  1. Cloning & Encryption (1h)
  • Database cloning techniques
  • SSL/TLS configuration
  • Transparent Data Encryption (TDE) overview
  1. Upgrading Best Practices (1h)
  • Minor vs major upgrades
  • pg_upgrade
  • Logical upgrade methods

📌 Prerequisites

  • Basic experience in database administration
  • Intermediate understanding of RDBMS concepts
  • Basic knowledge of SQL
  • Familiarity with Linux OS (preferred)

👥 Who Should Attend

  • PostgreSQL DBAs
  • Database Engineers
  • DevOps Engineers
  • Technical Leads
  • IT Professionals managing databases at scale

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below: