Setup Menus in Admin Panel

Certified PostgreSQL DBA(CPSDBA)

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.

Course Information:

Course Number: -CPSDBA
Delivery Method: CertCamps,Virtual Live Instructor Led Training,Customer Onsite Training,Classroom Training,
Duration: 4 Days

Pre-Requisite:

Basic SQL & Linux OS

Target Audience:

Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in joining the DBA world!

In 2005, CertFirst (A Division of SaiFirst Corporation) became the very first company in North America to have a complete structured independent PostgreSQL DBA certification training program for SQL professionals for the following track:

Course Description:

DAY 1

1.Introduction
2.System Architecture
3.Installation and Database Clusters
4.Creating and Managing Databases

DAY 2

1.Security
2.Monitoring
3.User Tools -CUI and GUI
4.Configuration
5.Tablespaces
6.Backup & Recovery

DAY 3

1.Routine Maintenance Tasks
2.Performance Tuning
3.Upgrading Best Practices
4.Streaming Replication

DAY 4

1.Point-in Time recovery
2.Setting up BART
3.Loading and Moving Data
4.Table Partitioning
5. Advance customized topics as required

Training Schedule

Delivery Methods:

All Rights Reserved 2020 postgresqlcert