The PostgreSQL Database Administration course provides a comprehensive guide to managing PostgreSQL servers.

Participants will be equipped with the skills to handle switchover and failover, upgrading best practices, and migrating from Oracle to Postgres using Ora2PG, making this training the perfect stepping stone towards a rewarding career in PostgreSQL database administration.
 

Unit 1: Introduction to PostgreSQL Server and Advance Features 

Unit 2: Postgres Client Server Architecture 

Unit 3: Getting Started

• Installing the PostgreSQL Server
• Setting Environment Variables
• Creating a Cluster
• Running Server

Unit 4: Configuring of PostgreSQL Server 

Unit 5: Server Control 

Unit 6: Creating and managing databases

Unit 7: Obtaining Metadata 

Unit 8: Database Administration 

• Performing actions on many tables
• Writing a script
• Adding/removing schemas
• Moving objects between schemas
• Adding/removing tablespaces  
• Moving objects between tablespaces
• Using materialized views 

Unit 9: Table Partitioning

Unit 10: Extensions and Security

Unit 11: Monitoring and Diagnosis

Unit 12: Performance and Concurrency 

Unit 13: Backup and Recovery 

Unit 14: Moving Data 

Unit 15: Replication and Upgrades 

• Database Admin
• Software Developers
• Data Analysts

None

• Working knowledge of Windows and Linux OS