All training
ConfidentHire Academy IT Training

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.conf configuration
  • Backup and recovery using pg_dump, pg_dumpall, pg_restore, and pg_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

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
  • PostgreSQL history, major features and PPAS features · 60
  • Architectural overview, database limits and object naming · 60
Module 2 — PostgreSQL System Architecture 4 lessons
  • Architectural summary, process architecture and utility processes · 90
  • Memory architecture and connection request-response flow · 90
  • Disk read/write buffering, background writer, commit and checkpoint · 90
  • Physical database architecture, directory layout, page layout and WAL · 90
Module 3 — Installation 1 lesson
  • PostgreSQL installation options and environment setup · 90
Module 4 — PostgreSQL Database Cluster 1 lesson
  • Creating and managing a PostgreSQL database cluster · 90
Module 5 — Command Line Interface 2 lessons
  • Introduction to PSQL and connecting to PostgreSQL · 60
  • PSQL commands, meta-commands and conventions · 90
Module 6 — PostgreSQL Configuration 3 lessons
  • PostgreSQL parameters and connection settings · 90
  • Memory, query planner and WAL settings · 90
  • Logging, background writer and session-level settings · 90
Module 7 — Managing Databases, Schemas, Users and Tablespaces 2 lessons
  • Object hierarchy, databases, schemas and schema search path · 90
  • Roles, users, groups and tablespace administration · 90
Module 8 — PostgreSQL Data Dictionary 1 lesson
  • System catalogs, information views and system information functions · 90
Module 9 — Log Management 1 lesson
  • PostgreSQL logging configuration and PgBadger reporting · 90
Module 10 — PostgreSQL Security 2 lessons
  • Authentication, authorization and levels of security · 90
  • pg_hba.conf, object ownership and application access · 90
Module 11 — Backup and Recovery 3 lessons
  • Backup types, pg_dump and pg_dumpall · 90
  • pg_restore and offline/online backup concepts · 90
  • Physical backup using pg_basebackup and recovery practice · 120
Module 12 — WAL Archiving 2 lessons
  • Continuous archiving, archive_mode and archive_command · 90
  • archive_command options and continuous archiving use cases · 90
Module 13 — MVCC 2 lessons
  • Multi-Version Concurrency Control concepts and examples · 90
  • Transaction wraparound, MVCC maintenance and prevention · 90
Module 14 — Routine Maintenance 3 lessons
  • Database maintenance tools, EXPLAIN ANALYZE and optimizer statistics · 90
  • Data fragmentation, visibility map and free space map · 90
  • Autovacuum, VACUUM, ANALYZE and VACUUM FULL · 120
Module 15 — Data Movement 1 lesson
  • COPY command for data import and export · 90
Module 16 — Streaming Replication 4 lessons
  • Replication concepts, sync/async and log-shipping architecture · 90
  • Streaming, hot standby and cascading replication · 90
  • Primary server preparation, authentication and base backup · 120
  • Standby setup, synchronous replication, cascading standby and monitoring · 120
Module 17 — Database & Server Monitoring 2 lessons
  • Database statistics, statistics collector and statistic tables · 90
  • Operating system process monitoring and disk usage · 90

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.

Ask a question / request a callback

Leave an email or phone number so the coordinator can reach you.

Your message goes straight to the batch coordinator, who will follow up.