Introduction to PostgreSQL Administration

In this course you will learn the essential details of PostgreSQL Administration tasks including: the overall PostgreSQL architecture, PostgreSQL configuration, security, maintenance, monitoring, tuning, backups, recovery, and moving data.

 This class conveys the knowledge necessary for the student to perform their duties as a PostgreSQLDBA, and is a foundation for the Advanced and Performance courses that follow in the DBA track.

This course covers all the topics tested in the EnterpriseDB PostgreSQL Associate certification exam (Certification Voucher of USD 100 is free with this training; the certification exam will be conducted on Day 3).  More information on this certification can be found on http://www.enterprisedb.com/products-services-training/certification/pos...

Prerequisites

This course is designed for people with experience in database administration and who are new to the PostgreSQL platform.

Duration

3 days.

Dates

09, 10 & 11 March 2011

Course Topics

Day 1 (9.30 AM to 5.30 PM)

• Introduction
• PostgreSQL System Architecture
• Installation
• Configuration
• Creating and Managing Databases

Day 2 (9.30 AM to 5.30 PM)

• Introduction to PSQL
• pgAdmin III
• Security basics
• SQL
• Data Handling

Day 3 (9.30 AM to 5.30 PM)

• Backup and Recovery
• Routine Maintenance
• Postgres Data Dictionary
• Moving Data
• EnterpriseDB PostgreSQL Associate Certification Exam

Your Investment

• INR 22,000/- + Service Tax
• You can pay by Credit Card, Cheque or Demand Draft drawn in favour of “OSSCube Solutions (P) Ltd.)

Location

OSSCube
D 49, Sector 63,
Noida - 201301