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.
- 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
-- 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.
Includes one complimentary attempt at the PostgreSQL Professional Certification Exam.
- 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 firstname.lastname@example.org or call for discount information and to learn more!