PostgreSQL 9.X DBA CertCamp Instructor-led Training & Certification

Date: 2013-05-27 – 2013-05-30
Location: Oak brook, IL, United States
Language: English

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.