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.
- 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
- Basic SQL & Linux OS
Course Number: – CPSDBA
Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in joining the DBA world!
| COURSE FEATURES |
|---|
|
Lectures - 19 |
|
Videos Duration - 40 hours |
|
Skill level - All levels |
|
Language - English |
Note: Classroom & Virtual live Training includes Examprep Tools
Register Now:
Custom Training
1. Choose your training preference date 2. Virtual Live Group Training 3. Class Room Group Training 4. Class Room On-Site Group Training 5. Virtual Live1-1 Mentoring 6. Class Room 1-1 Mentoring