Course Description

PostgreSQL DBA Associate Certification Workshop is a foundation course for all Database Administrators who manage Enterprise Database Servers. It is designed for people with experience in database administration who are new to PostgreSQL database server.

The course comprise  PostgreSQL architecture, configuration, maintenance, monitoring, backup, recovery, and data movement.

Course Outline

 The topics covered includes :

• PostgreSQL System Architecture

• Installation of PostgreSQL Database Server on GNU/LINUX system

• Configuration of PostgreSQL Database Server on GNU/LINUX system

• Creating and Managing Databases

• Introduction to PSQL

• pgAdmin III

• Security basics

• SQL

• Backup and Recovery

• Point-in Time Recovery

• Routine Maintenance

• Postgres Data Dictionary

• Moving Data

Duration

• 5 Days (30 Hours)