PostgreSQL DBA 9 Certification Hands-on Training @ Vegas Boot Camp

Date: 2013-04-22 – 2013-04-25
Location: Las Vegas, NV, United States

Course & Exam Objectives & Outline

I. Getting Started

  1. Installing PostgreSQL

Compiling and Installing PostgreSQL on Linux/Unix

Post-Installation Setup

The PostgreSQL Windows Installer

  1. 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

  1. Overview of PostgreSQL Architecture

Configuration Files

Physical Storage and File Layout


System Catalogs

Logging Parameters

  1. Roles and Privileges

Roles and Their Attributes


Role Membership

  1. Security

Securing TCP Connections with SSL

Create Secure SSH Tunnels

Client Authentication

Encryption Options

  1. Backup and Recovery

Overview of Backup Methods

Performing an SQL Dump and Restore

Filesystem Backup

  1. Maintenance and Monitoring

Routine Maintenance Tasks

Monitoring Database Activity

Monitoring Disk Usage

  1. Client Connections

pgsqlODBC and OpenOffice

Windows ODBC and Microsoft Access

Perl DBI

III. Advanced Administration Topics

  1. Performance Tuning

  2. Continuous Backup and PITR

  3. Warm Standby Servers for High Availability

  4. Asynchronous Replication with Slony-I

  5. Procedural Languages

  6. 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.