Course Outline
- Introduction
- Architectural Overview
- Lab Machine Setup
- Performance Monitoring and Tuning
- Monitoring Slow Queries
- SQL Tuning
- Table Partitioning
- Operating System Best Practices
- Parameter Tuning
- Extensions
- Benchmarking
- Monitoring Best Practices
- Demos and Labs
- Database Backups and Restores
- Logical or SQL Dump Backups
- Restoring SQL Dumps
- Physical Backups - Offline
- Restoring Offline Backups
- Physical Backups - Online
- Write Ahead Log(WAL) Archiving
- Recovery configuration
- Point in Time Recovery using WAL Archives
- High Availability
- Transaction Log Archiving
- Streaming Replication
- Connection Pooling and HA setup using pgpool-II
- Installation
- Configuration
- pgpool Setup
- HA Setup
- Demos and Labs
- Database Security
- Users and Groups
- Access Control
- Row Level Security
- Host Based Access Control
- Data Encryption using pgcrypto
- Demos and Labs
- Database Upgrades
- PostgreSQL Versioning
- Plan for Upgrade
- Upgrade using pg_dump
- Upgrade using pg_upgrade
- In Place or Not-in Place Upgrade
- Post Upgrade Tasks
Requirements
It is recommended to attend this training only if you have a prior knowledge of PostgreSQL or have attended PostgreSQL Essentials Training
Testimonials (7)
Subject matter expert and very friendly, approachable
Steve
Course - PostgreSQL Advanced DBA
Group discussions.
Clement
Course - PostgreSQL Advanced DBA
Group discussions.
Clement
Course - PostgreSQL Advanced DBA
Group discussions.
Clement
Course - PostgreSQL Advanced DBA
Group discussions.
Clement
Course - PostgreSQL Advanced DBA
very friendly and approachable, knowledge of subject matter
Steve
Course - PostgreSQL Advanced DBA
very friendly and approachable, knowledge of subject matter