Advanced PostgreSQL Administration

Overview

This course builds on the Foundations of Postgres Administration course and addresses advanced topics, such as replication to safe guard data, clustering for high availability, partitioning for performance and maintainability, and performance tuning. Advanced PostgreSQL Administration prepares DBAs to manage large, highly available databases and their related security requirements with confidence.

This course is intended for DBAs and IT Professionals who want to enhance their Postgres administration skills.

Prerequisites

Proficiency in fundamental Postgres DBA functions

Completion of the Foundations of Postgres Administration training

Pass the PostgreSQL Associate Certification (recommended)

Course duration

4 Days

Course outline

Introduction
SQL Tuning
Performance Tuning
Performance Benchmarking
WAL Archiving
Streaming Replication
Connection Pooling
Table Partitioning
Extensions
Foreign Data Wrappers
Monitoring
Database design alternatives
Data Migration
Server Logs & Troubleshooting
Workload Analysis, Benchmarking and Profiling Table Partitioning Extensions - Identify what is required.
High availability / Sharding and Scale Out, replication advanced option Open SSL - encryption Permissions & Security (roles/privileges) - segregating responsibilities Advanced Monitoring PostgreSQL 10 - new features
Upgrading Best Practices