Get an attempt of Professional Certification free!
Beyond the regular maintenance and administration of your Postgres databases exist organizational needs for advanced solutions including replication to safe guard data, clustering for High Availability, partitioning for performance and maintainability, and security for privacy and protection. This course covers these inter-related topics in detail.
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.
During the 3 days of instruction, 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
- Procedural Languages
- Add on Utilities – Contrib