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

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

Date: 2014-06-16 – 2014-06-19
Location: Oak Brook, IL OR Virtual Live, Illinois, United States
Language: English

I. Getting Started

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

  5. Creating a Database and Testing the Server

  6. Initializing a Cluster
  7. Creating a Database
  8. Starting the Database Server
  9. The psql Client
  10. 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 10 .Continuous Backup and PITR
  2. Warm Standby Servers for High Availability
  3. Asynchronous Replication with Slony-I
  4. Procedural Languages
  5. Contrib Modules

Prerequisite knowledge

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

To visit please register: Or Call: 630-684-0355 Or

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.

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