PostgreSQL Database Administration – From Fundamentals to Production
November 2026 Morning Batch
Live online PostgreSQL Database Administration batch for aspiring and working database professionals.
The training covers PostgreSQL installation, configuration, security, backup & recovery, maintenance, replication, and monitoring.
The program includes hands-on demonstrations and practical database administration exercises.
Ideal for DBAs, Database Support Engineers, and professionals transitioning from Oracle, MySQL, or SQL Server to PostgreSQL.
Online
Beginner, Intermediate, Advanced
English
PostgreSQL PostgreSQL Administration PostgreSQL DBA PSQL Database Administration Database Configuration PostgreSQL Security pg_hba.conf Backup and Recovery pg_dump pg_restore pg_basebackup WAL WAL Archiving MVCC VACUUM Auto Vacuum Database Monitoring Streaming Replication Database
About This Course
PostgreSQL Database Administration – From Fundamentals to Production is a practical training program designed for students, database professionals, and IT engineers who want to build strong PostgreSQL administration skills.
The course covers PostgreSQL architecture, installation, database clusters, configuration, user and schema management, security, backup and recovery, WAL archiving, MVCC, routine maintenance, replication, and database monitoring.
Students will gain hands-on experience with PostgreSQL administration tools and learn how to configure, maintain, secure, back up, recover, and monitor PostgreSQL database environments.
What You'll Learn
- PostgreSQL architecture and core components
- PostgreSQL installation and environment configuration
- Database cluster creation and management
- PostgreSQL command-line interface using PSQL
- PostgreSQL configuration and parameter management
- Creating and managing databases, schemas, users, roles, and tablespaces
- PostgreSQL system catalogs and data dictionary
- Log management and PgBadger reporting
- PostgreSQL authentication and authorization
pg_hba.confconfiguration- Backup and recovery using
pg_dump,pg_dumpall,pg_restore, andpg_basebackup - WAL archiving and continuous archiving
- Multi-Version Concurrency Control (MVCC)
- VACUUM, ANALYZE, Auto Vacuum, and routine maintenance
- Database and index statistics
- Data import and export using COPY
- PostgreSQL streaming replication
- Synchronous and asynchronous replication
- Standby and cascading replication
- Database and server monitoring
Hands-On Learning
The training includes:
- Live instructor-led sessions
- PostgreSQL installation and configuration
- Practical administrative exercises
- Backup and recovery demonstrations
- Security configuration
- Database maintenance exercises
- Replication setup
- Monitoring and troubleshooting activities
- Regular assignments and practice exercises
Meet Your Trainer
Your trainer is Nitin, a Principal PostgreSQL DBA and platform engineer with 14+ years in database administration, the last several focused on running PostgreSQL in production for large financial-services and enterprise clients.
- Certified PostgreSQL professional, also an Oracle Certified Professional (OCP 11g) and ITIL certified
- Has worked as an L3 (senior escalation) PostgreSQL DBA, solving the hardest production issues
- Builds high-availability setups with Patroni, pgpool and failover managers, and backups with pgBackRest and Barman
- Has migrated databases to PostgreSQL, including from Oracle, and runs PostgreSQL on AWS
- Sets up monitoring and automation with Grafana, Prometheus and Datadog
- Teaches from real production incidents, not just the documentation
👉 View Nitin's trainer profile · About ConfidentHire Academy
Who Should Join?
This course is suitable for:
- Students interested in Database Administration
- Database Administrators
- SQL Developers
- System Administrators
- DevOps Engineers
- Application Developers working with PostgreSQL
- IT professionals moving from other databases to PostgreSQL
Prerequisites
Basic knowledge of databases and SQL is recommended.
Prior PostgreSQL administration experience is not required.
Course Outcome
After completing the course, students should be able to install, configure, administer, secure, back up, restore, maintain, replicate, and monitor PostgreSQL database environments.
Curriculum · 17 modules, 36 lessons
Module 1 — Introduction 2 lessons · 1 session
- PostgreSQL history and major features, architectural overview, database limits and object naming · 90
- Architectural overview, database limits and object naming · 60
Live sessions
Mon, 16 Nov · 7:30 AM
Module 2 — PostgreSQL System Architecture 4 lessons · 3 sessions
- Architectural summary, process architecture and utility processes · 90
- Memory architecture, connection flow, buffering, background writer, commit and checkpoint · 90
- Disk read/write buffering, background writer, commit and checkpoint · 90
- Physical database architecture, directory layout, page layout and WAL · 90
Live sessions
Tue, 17 Nov · 7:30 AM
Wed, 18 Nov · 7:30 AM
Thu, 19 Nov · 7:30 AM
Module 3 — Installation 1 lesson · 1 session
- PostgreSQL installation options and environment setup · 90
Live sessions
Fri, 20 Nov · 7:30 AM
Module 4 — PostgreSQL Database Cluster 1 lesson · 1 session
- Creating and managing a PostgreSQL database cluster · 90
Live sessions
Mon, 23 Nov · 7:30 AM
Module 5 — Command Line Interface 2 lessons · 1 session
- PSQL: connecting to PostgreSQL, commands, meta-commands and conventions · 90
- PSQL commands, meta-commands and conventions · 90
Live sessions
Tue, 24 Nov · 7:30 AM
Module 6 — PostgreSQL Configuration 3 lessons · 2 sessions
- PostgreSQL parameters and connection settings · 90
- Memory, query planner, WAL, logging, background writer and session-level settings · 90
- Logging, background writer and session-level settings · 90
Live sessions
Wed, 25 Nov · 7:30 AM
Thu, 26 Nov · 7:30 AM
Module 7 — Managing Databases, Schemas, Users and Tablespaces 2 lessons · 2 sessions
- Object hierarchy, databases, schemas and schema search path · 90
- Roles, users, groups and tablespace administration · 90
Live sessions
Fri, 27 Nov · 7:30 AM
Mon, 30 Nov · 7:30 AM
Module 8 — PostgreSQL Data Dictionary 1 lesson · 1 session
- System catalogs, information views and system information functions · 90
Live sessions
Tue, 1 Dec · 7:30 AM
Module 9 — Log Management 1 lesson · 1 session
- PostgreSQL logging configuration and PgBadger reporting · 90
Live sessions
Wed, 2 Dec · 7:30 AM
Module 10 — PostgreSQL Security 2 lessons · 2 sessions
- Authentication, authorization and levels of security · 90
- pg_hba.conf, object ownership and application access · 90
Live sessions
Thu, 3 Dec · 7:30 AM
Fri, 4 Dec · 7:30 AM
Module 11 — Backup and Recovery 3 lessons · 3 sessions
- Backup types, pg_dump and pg_dumpall · 90
- pg_restore and offline/online backup concepts · 90
- Physical backup using pg_basebackup and recovery practice · 90
Live sessions
Mon, 7 Dec · 7:30 AM
Tue, 8 Dec · 7:30 AM
Wed, 9 Dec · 7:30 AM
Module 12 — WAL Archiving 2 lessons · 1 session
- Continuous archiving: archive_mode, archive_command options and use cases · 90
- archive_command options and continuous archiving use cases · 90
Live sessions
Thu, 10 Dec · 7:30 AM
Module 13 — MVCC 2 lessons · 2 sessions
- Multi-Version Concurrency Control concepts and examples · 90
- Transaction wraparound, MVCC maintenance and prevention · 90
Live sessions
Fri, 11 Dec · 7:30 AM
Mon, 14 Dec · 7:30 AM
Module 14 — Routine Maintenance 3 lessons · 3 sessions
- Database maintenance tools, EXPLAIN ANALYZE and optimizer statistics · 90
- Data fragmentation, visibility map and free space map · 90
- Autovacuum, VACUUM, ANALYZE and VACUUM FULL · 90
Live sessions
Tue, 15 Dec · 7:30 AM
Wed, 16 Dec · 7:30 AM
Thu, 17 Dec · 7:30 AM
Module 15 — Data Movement 1 lesson · 1 session
- COPY command for data import and export · 90
Live sessions
Fri, 18 Dec · 7:30 AM
Module 16 — Streaming Replication 4 lessons · 3 sessions
- Replication concepts, sync/async and log-shipping architecture · 90
- Streaming, hot standby and cascading replication · 90
- Primary preparation, base backup, standby setup, synchronous replication and monitoring · 90
- Standby setup, synchronous replication, cascading standby and monitoring · 120
Live sessions
Mon, 21 Dec · 7:30 AM
Tue, 22 Dec · 7:30 AM
Wed, 23 Dec · 7:30 AM
Module 17 — Database & Server Monitoring 2 lessons · 2 sessions
- Database statistics, statistics collector and statistic tables · 90
- Operating system process monitoring and disk usage · 90
Live sessions
Thu, 24 Dec · 7:30 AM
Fri, 25 Dec · 7:30 AM
Cancellation & refund policy
Refund Policy
- If a cancellation request is received 7 days or more before the batch start date, 25% of the course fee will be deducted as cancellation charges and the remaining amount will be refunded.
- If a cancellation request is received between 3 and 6 days before the batch start date, 50% of the course fee will be deducted as cancellation charges and the remaining amount will be refunded.
- If a cancellation request is received less than 3 days before the batch start date, no refund will be applicable.
- No refund will be provided once the batch has started.
- If the batch is cancelled by ConfidentHire, the full course fee paid by the student will be refunded.
- Course fees are non-transferable to another student or batch.
- Approved refunds will be processed within 7–10 working days.
Grab the 🪔 Diwali Offer
Your message goes straight to the batch coordinator, who will follow up.