Certified PostgreSQL DBA (CPSDBA)

$2,495.00

Course Number: -PG900
Delivery Method: CertCamps,Virtual Live Instructor Led Training,Customer Onsite Training,Classroom Training,

Description

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

1.Introduction

2.System Architecture

3.Installation and Database Clusters

4.Creating and Managing Databases

DAY TWO :-

1.Security

2.Monitoring

3.User Tools -CUI and GUI

4.Configuration

5.Tablespaces

6.Backup & Recovery

DAY THREE :-

1.Routine Maintenance Tasks

2.Performance Tuning

3.Upgrading Best Practices

4.Streaming Replication

DAY FOUR :-

1.Point-in Time recovery

2.Setting up BART

3.Loading and Moving Data

4.Table Partitioning

5. Advance customized topics as required

Pre-Requisite:

This course requires students to have an understanding of Linux fundamentals as well as SQL.
Become a Certified PostgreSQL Administrator:

Candidates are highly recommended to attend extensive hands-on training (4 days). After successful completion of training program, candidates are encouraged to pass the PostgreSQL Administrator exam in order to get certified.

Target Audience:

•Database Administrator, Programmers, Developers and Open Source Technology Specialists. This instructor-led hands-on certification training program requires students to have an understanding of Linux fundamentals as well as basic SQL.

Certification Exam Number & Details:

Exam Number: PG900

Exam Fee: $195

Exam Requirements: All candidates interested in becoming Certified PostgreSQL DBA are encouraged to attend hands-on instructor-led training at CertFirst or through one of its affiliated partners.

Exam Details:

Number Of Questions:60 Questions

Time Allocated:90 Minutes

Minimum Pass Requirement: 70%

Certification Renewal is required every three years.

Renewal Options:

Option “A”: Candidates can either take the latest certification exam and must pass it in order to renew their certification status

OR

Option “B”: Attend our one-day upgrade course and upon completion of the program candidates will be able to successfully renew their certification for next three years.