Course Description

This course is offered as an On-demand/Self-paced course, which can be taken anytime and from anywhere to accommodate learning in your busy schedule.

Participants should be proficient in regular Postgres DBA functions. The Introduction to Postgres Administration course and its associated Certification exam provide an excellent foundation. The Advanced Postgres Administration course prepares DBA's to manage large, highly available databases and their related security requirements with confidence.

Course Outline

During this course, participants will cover the following topics in depth:

• PostgreSQL System Architecture

• Transactions and Concurrency Transaction Definition

• Performance Tuning

• Table Partitioning

• High Availability & Replication

• Connection Pooling

• Monitoring

• Procedural Languages

• Add on Utilities – Contrib

Duration

5 Days (30 Hours)