Description
This course Advanced PostgreSQL gives you a unique opportunity to get trained and certified on advanced database administration for PostgreSQL. Learn how to best fulfill the more advanced DBA responsibilities including security, database tuning and benchmarking, monitoring, setting up high availability and replication, and more.
This course is designed for DBAs, Architects, and Database Professionals who are responsible for ongoing and advanced administration and maintenance of PostgreSQL, including implementing strategic database solutions for the enterprise.
Target
This course is intended for DBAs and IT Professionals who want to enhance their Postgres administration skill to the next level.Contents
- Postgres Advanced Server System Architecture and Installation
- Database Objects and Hierarchy
- Configuration Settings and Parameters
- User Tools for Administration – Command Line and Graphical
- Tablespaces – Creating and Managing
- Users, Groups, and Assigning Privileges
- Security Settings
- Data Loading
- Transactions and Concurrency
- Routine and Proactive Maintenance Tasks
- Backup, Recovery, and Point In Time Recovery
- Performance Tuning
- Moving Data
- Data Dictionary
Prerequisites
We recommend taking Foundations of PostgreSQL prior to this course.Study Materials
Hands-on labs
Study materials