PostgreSQL DBA Hands-on Training & Certification

Date: 2018-08-27 – 2018-08-30
Location: Markham, ON, United States
Language: English

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

III. Advanced Administration Topics

Prerequisite knowledge

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

To visit and register OR CALL: 630-684-0355 | Email:

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.