PostgreSQL Administration 9.3

Date: 2014-02-24 – 2014-02-28
Location: Bangalore, India
Language: English

This course conveys the knowledge necessary to perform the duties of a PostgreSQL DBA. In this course you will learn the details of essential PostgreSQL Administration tasks including: the overall PostgreSQL architecture, configuration, maintenance, monitoring, backups, recovery, and moving data.

This course also addresses advanced topics, such as replication to safe guard data, clustering for high availability, partitioning for performance and maintainability, and security for privacy and protection. The course prepares DBAs to manage large, highly available databases and their related security requirements with confidence.

The course focuses on PostgreSQL Community Edition.

This class is intended for IT Professionals who want to administer and maintain PostgreSQL. It is also meant for those who want to enhance their Postgres administration skill to the next level. No prior knowledge of PostgreSQL is required to attend this class.

After you have successfully completed this class, you will be fully prepared for both PostgreSQL Certifications, of which the Associate Certification (a $200 value product) is being offered complimentary with this class.

Note: Certifications offered by EnterpriseDB are their own certifications, and are not reviewed or endorsed by the PostgreSQL Community.

Duration: 5 days

Course Outline:

  • Installation
  • Configuration
  • Creating and Managing Databases
  • Introduction to PSQL
  • pgAdmin III
  • Security basics
  • SQL
  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data
  • Transactions and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Monitoring
  • Add on Utilities – Contrib

Recommended Pre-requisites: Basic experience in database administration

Training Location: Bangalore, India

Group discounts also available!

For more details, please Click Here

Posted by EnterpriseDB Corporation (

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.