SaiFirst PostgreSQL DBA 9 Certification Hands-on Training Program

Date: 2013-04-08 – 2013-04-11
Location: Toronto, ON, Canada

I. Getting Started -Installing PostgreSQL -Compiling and Installing PostgreSQL on Linux/Unix -Post-Installation Setup -The PostgreSQL Windows Installer -Creating a Database and Testing the Server -Initializing a Cluster -Creating a Database -Starting the Database Server -The psql Client -Startup Failures and Client Connection Problems

II. Basic PostgreSQL Administration -Overview of PostgreSQL Architecture -Configuration Files -Physical Storage and File Layout -Tablespaces -System Catalogs -Logging Parameters -Roles and Privileges -Roles and Their Attributes -Privileges -Role Membership -Security -Securing TCP Connections with SSL -Create Secure SSH Tunnels -Client Authentication -Encryption Options -Backup and Recovery -Overview of Backup Methods -Performing an SQL Dump and Restore -Filesystem Backup -Maintenance and Monitoring -Routine Maintenance Tasks -Monitoring Database Activity -Monitoring Disk Usage -Client Connections -pgsqlODBC and OpenOffice -Windows ODBC and Microsoft Access -Perl DBI

III. Advanced Administration Topics

-Performance Tuning -Continuous Backup and PITR -Warm Standby Servers for High Availability -Asynchronous Replication with Slony-I -Procedural Languages -Contrib Modules

Prerequisite knowledge:

This course requires students to have understanding of Linux fundamentals as well as SQL.

Corporate on-site:

For a group of 5 or more it may be a cost effective and convenient for corporate to outsource the complete training project to CertFirst Professionals to come and bring the training at their own location. This course is available @ your site for as low as $9,995 for a group of 5 candidate(s). Price includes course-ware, classroom lab set up including hardware & software can also be provided at no additional cost for the duration of the training program; client only pays for shipping and handling. Contact us at 630-684-0355 for more information.

Education and Government Institute(s)

CertFirst offers special discount pricing for all Educational and Govt. Institutes. Call 1-877-724-3477 (USA) or 1-630-684-0355 (Global) for more details.

CertFirst Virtual Live Training:

The most cost effective and the convenient way to study and prepare at your own convenience. CVLT provides you with the most cost effective and convenient way to gain hands-on live instructor-led training.

To Register, Visit: or send an e-mail to

Posted by CertFirst (

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.