PG201 Advanced PostgreSQL Administration

Date/Time
August 10, 2021 - August 12, 2021
09:00 - 17:00

Advanced PostgreSQL Administration

PG201 Advanced PostgreSQL Administration course builds on the PG101 Foundations of PostgreSQL Administration course and 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 Advanced PostgreSQL Administration course prepares DBAs to manage large, highly available databases and their related security requirements with confidence.

It focuses on latest PostgreSQL Community Edition and covers enterprise class tools for PostgreSQL administration and prepares the learners to handle real time, production environments.

Course will also prepare you for PostgreSQL Professional Certification which is the definitive standard for PostgreSQL professionals. This certification assesses and certifies a database professionals ability to work in demanding, large-scale, real-world production environments.

This class is available in v10, v11 and v12

Course Outline

• PostgreSQL Introduction
• Database Monitoring
• SQL Tuning
• Performance Tuning
• Performance Benchmarking
• Extensions
• Table Partitioning
• Connection Pooling
• High Availability
• Foreign Data Wrappers
• Database Security
• Upgrading Best Practices
• More: link

Target Audience

• This class is intended for IT Professionals who want to enhance their PostgreSQL administration skill to the higher level.

Recommended Prerequisites

• Participants should be proficient in basic Postgres DBA functions.
• It is recommended to attend the PG101 Foundations of PostgreSQL Administration training prior to this class. It is beneficial to complete the PostgreSQL Associate Certification prior to attending this training.

Recommended next exam or course

• PG301 PostgreSQL for Developers and Architects
• PostgreSQL Professional Certification