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.
Course Contents:
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
Exam Details:
- Exam Pattern: Multiple Choice
- Exam Duration: 90 Minutes, 60 Questions
- Minimum Passing Score: 70%
- Certification Validity: 3 Years
- Number of Attempts: $195 for 1 attempt, $295 for 2 attempts (must pre-purchase the two-attempt package; no refund is issued whether you pass or fail the first attempt)
Prerequisites:
- Basic SQL & Linux OS
