Skip site navigation (1) Skip section navigation (2)

SaiFirst PostgreSQL DBA 9 Certification Hands-on Training Program

Date: 2013-09-30 – 2013-10-03
Location: Oak Brook, IL, United States
Language: English

Course & Exam Objectives & Outline

I. Getting Started

  1. Installing PostgreSQL
  2. Compiling and Installing PostgreSQL on Linux/Unix
  3. Post-Installation Setup *The PostgreSQL Windows Installer

  4. Creating a Database and Testing the Server

  5. Initializing a Cluster
  6. Creating a Database
  7. Starting the Database Server
  8. The psql Client
  9. Startup Failures and Client Connection Problems

II. Basic PostgreSQL Administration

  1. Overview of PostgreSQL Architecture
  2. Configuration Files
  3. Physical Storage and File Layout
  4. Tablespaces
  5. System Catalogs
  6. Logging Parameters

  7. Roles and Privileges

  8. Roles and Their Attributes
  9. Privileges
  10. Role Membership

  11. Security

  12. Securing TCP Connections with SSL
  13. Create Secure SSH Tunnels
  14. Client Authentication
  15. Encryption Options

  16. Backup and Recovery

  17. Overview of Backup Methods
  18. Performing an SQL Dump and Restore
  19. Filesystem Backup

  20. Maintenance and Monitoring

  21. Routine Maintenance Tasks
  22. Monitoring Database Activity
  23. Monitoring Disk Usage

  24. Client Connections

  25. pgsqlODBC and OpenOffice
  26. Windows ODBC and Microsoft Access
  27. 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.

For more information and for details on signing up please visit

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group