SaiFirst PostgreSQL DBA 9.X Certification Hands-on Training Program

Date: 2013-11-18 – 2013-11-21
Location: Las Vegas or Virtual Live, NV, 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


  • 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

Audience: Database Administrator, Programmers, Developers and Open Source Technology Specialists. This instructor-led hands-on certification training program requires students to have understanding of Linux fundamentals as well as basic SQL.

Pre-requisite knowledge:

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

To visit please register:

Note: Certifications offered by CertFirst are their own certifications, and are not reviewed or endorsed by the PostgreSQL Community.

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.