Comprehensive PostgreSQL Administration



Postgres Training

Designed for DBAs, Architects, Application Developers, and IT Professionals, our training courses are created and delivered by experienced & Certified Postgres experts who will show you how to quickly manage your database responsibilities with ease.

We offer training in 2 convenient formats:

  • Classroom – scheduled, open-enrolment public training batch at a specified city or location
  • On-Site – delivered on-premise at your company location for your team


Relevant and up-to date material and labs enable you to quickly put your new skills into practice in your own environment. All training includes modularized lessons, lecture, presentation copy, and real hands-on lab exercises.


The COMPREHENSIVE POSTGRESQL ADMINISTRATION course includes basics of PostgreSQL Administration and certain key advanced concepts.This training will help you prepare for day-to-day Administrative and Management tasks to be performed as a PostgreSQL DBA; and slowly scale up to manage large and highly available databases, with ease and confidence. This 5-day course is designed for people with experience in database administration but are new to PostgreSQL.

Course Coverage:

  • Introduction and Architectural Overview
  • PostgreSQL System Architecture
  • Installation
  • PPAS Installation
  • Database Clusters
  • Configuration
  • Creating and Managing Databases
  • User Tools: Command Line Interfaces
  • GUI Tools
  • Security
  • SQL Primer
  • Backup and Recovery & Point-in Time Recovery
  • Routine Maintenance
  • Data Dictionary
  • Moving Data
  • Transaction and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability and Replication
  • Extension Module

Training Pre-requisites:

  • Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.
  • IT Professionals who want to administer and maintain PostgreSQL. No prior knowledge of PostgreSQL is required to attend this class.

Delivery Approach:

  • All attendees must attend this class in person. There is no remote access to the training.

Interested? Fill the Inquire Now form.

Inquire Now
Just fill in your specifics and we will get in touch with you, with the course fees and other details.