Introduction to PostgreSQL Administration March 8, 2011

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.

These classes convey the knowledge necessary for the student to perform their duties as a Postgres DBA, and are a foundation. 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 onhttp://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