Comprehensive PostgreSQL Administration Training

Comprehensive -Training-SG

Comprehensive PostgreSQL Administration Training

This is a comprehensive course that includes the basics of PostgreSQL Administration and some key advanced concepts. Taking up this training will help the learner 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 PostgreSQL course is designed for people with experience in database administration but who are new to PostgreSQL.

If you are interested in learning, improving, developing your Postgres Skills, have a running Postgres project or if you look for alternatives to take up database systems, this would be your best bet for getting your team up to speed.

The course coverage, details and pre-requisites are as below:

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 Details:

  • Training fees: Enquire here
  • Location: Singapore
  • Date & Time: 3rd to 7th Sep 2018, 9.30 am – 5.30 pm
  • Batch strength: 12-13 students

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.

Only limited seats, register fast!

To know more on training fees and other course details, fill the ‘Book a Seat’ form or drop us an email on