Certified PostgreSQL DBA(CPSDBA)

Certified PostgreSQL DBA – PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

A PostgreSQL DBA (Database Administrator) is a professional who specializes in the management, maintenance, and optimization of PostgreSQL database systems. PostgreSQL is an open-source relational database management system known for its robustness, scalability, and extensibility.

Program Objectives

• Introduction
• System Architecture
• Installation and Database Clusters
• Creating and Managing Databases
• Security
• Monitoring
• User Tools -CUI and GUI
• Configuration
• Tablespaces
• Backup & Recovery
• Routine Maintenance Tasks
• Performance Tuning
• Upgrading Best Practices
• Streaming Replication
• Point-in Time recovery
• Setting up BART
• Loading and Moving Data
• Table Partitioning
• Advance customized topics as required