Advanced PostgreSQL Administration – with 9.4 Release Highlights

This class is intended for DBA IT Professionals who want to enhance their Postgres administration skills to the advanced level, and be prepared to manage large, highly available databases and their related transaction requirements with confidence.

Advanced PostgreSQL Database Administration is a 3-day online instructor-led training course that focuses on teaching individuals the essential techniques on how to manage and monitor Postgres databases, including high availability and replication strategies and setup, database and process monitoring and statistics, and understanding PL/pgSQL.

This course builds on your basic PostgreSQL skills and elevates them to support advanced DBA responsibilities, such as replication to safe guard data, clustering for high availability, partitioning for performance and maintainability, and performance tuning.  The Advanced PostgreSQL Administration course prepares you for reliable management of your enterprise databases and upon course completion, you will be well prepared with these essential skills.

Course Outline:

  • PostgreSQL System Architecture
  • Transactions and Concurrency
  • Performance Tuning
  • Hardware, OS and Server Parameter Configuration
  • Connection Settings and Memory Parameters 
  • Table Partitioning
  • High Availability & Replication
  • Connection Pooling
  • Monitoring & Statistics
  • Procedural Languages and PL/pgSQL
  • Add on Utilities – Extension Modules
  • Lab Exercises
  • 9.4 Release Highlights

Recommended Pre-requisites:

-- Participants should be proficient in basic Postgres DBA functions. The Introduction to Postgres Administration course and its associated Certification exam provide an excellent foundation, and it is recommended to have previously attended this class.  It is beneficial to complete the PostgreSQL Associate Certification prior to attending this training.

Certification:

Includes one complimentary attempt at the PostgreSQL Professional Certification Exam.

Includes:

  • Opportunity for interactive training Q&A with a PostgreSQL expert, in real-time via the live on-line format
  • Hands-on lab exercises
  • Electronic copy of course materials
  • A FREE attempt at the Postgres Professional Level Certification

Location:  Live Online

This Live Online training combines the convenience of on-line training with the benefits of interacting with a live instructor.  You can train from anywhere at your convenience – from your home or office, and get trained by the same Postgres expert as an on-site training with the opportunity to interact directly for specific questions or additional detail on a topic.

Special Discounts are available for this class

Please contact training@enterprisedb.com or call for discount information and to learn more!

Shopping cart

View your shopping cart.

On-Demand Training

Training Login Help

If you have registered for a training class which is scheduled for today and need urgent help with the login information, please use the contacts below and we will provide assistance as soon as possible.

Call Support at +1-732-331-1320 or

Email: training@enterprisedb.com 

Note: These contacts are for critical assistance only related to last minute login issues for any training class.