Course Overview
Comprehensive PostgreSQL Administration teaches the essential skills required by PostgreSQL DBAs to be successful. This course presents the PostgreSQL database architecture and core administrative tasks including configuration, maintenance, monitoring, backups, recovery, and moving data. Advanced topics are also covered including: replication to safeguard data, clustering for high availability, partitioning for performance and maintainability, and security for privacy and protection. Upon course completion, you will be prepared to manage large, highly available databases and their security requirements with confidence.
Who should attend
This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices.
Prerequisites
Basic experience in database administration. No prior knowledge of PostgreSQL is required.