PostgreSQL Training (Condensed)

In this course you will gain working knowledge and skills needed to perform PostgreSQL Administration tasks including: PostgreSQL architecture, configuration, maintenance, backups, recovery, writing functions, replication, and monitoring.
This class is for PostgreSQL DBAs and Developers. This course is intense and covers many topics over 2 days.

After being lectured on a topic, students will gain hands-on experience by performing lab exercises on the presented material. A laptop is provided for each student.

All of our courses can be tailored and delivered at your worksite. For groups of four or more, we offer affordable on-site training. Call us today for more information. 1-866-892-5315

Length in Days: 2

This course is offered on PostgreSQL 9.3. PostgreSQL is an exceptional relational DBMS that supports most SQL constructs, including subselects, transactions, triggers and user-defined types and functions. It is by far the most useful open-source database available, and The Modern Course offers the most comprehensive PostgreSQL training available anywhere.


The class runs from 8am - 4pm Monday and Tuesday.


The cost of the training is $1799.00
After you register you may pay online, by phone, or print an invoice. Registering online will reserve your seat for the specified date.


This course is for anyone who is tasked with administering a PostgreSQL database. Students attending this course should be familiar with SQL and feel comfortable working in a Linux/UNIX -type environment.

Course Outline


PostgreSQL presentation

* Building and installing PostgreSQL
* Concepts
* Creating databases and schemas
* Connection to PostgreSQL and SQL introduction
* Tables management
* Data types
* Postgres SQL language
* Configuration

Programming with PostgreSQL

* Writing effective PostgreSQL code
* Modifying SQL
* Server side
* Client side
* Window Functions

PostgreSQL Administration

* Authentication systems, privileges and security
* Users management
* Backup and restore
* Administration tools
* Using views and rules
* Understanding indexes

PostgreSQL Administration (Contd.)

* Backups
* Monitoring
* Large objects (Blobs)
* Transactions
* Concurrency issues
* Views
* Triggers
* Rules
* Point-in-Time Recovery
* Hot Standby
* Write-Ahead Log and Checkpoints

Log files

Query plans and basic optimization

Importing and exporting data


Add-ons (XSLT, PostGIS, etc...)

Pre-Recorded Sessions

Class Schedule

Webinar Schedule


" Our classes have no minimum amount of students and are guaranteed to run"

Chris Ulloa

Technical Director

Onsite Training Request

Number of Students:
1-5     6-10     11+