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

9.6 Administration Webinar

Date: 2017-03-27 – 2017-03-30
Location: online
Language: English

4 Days of Intense PostgreSQL 9.6 training

Classes offered with live instructor online. To access pre-recorded sessions, call or email us with an inquiry. Webinar times are convenient for students in the US, UK and Australia. ON DEMAND pre-recorded sessions are also available.

Day 1 Topics include:

  • Installation and configuration

  • Using psql

  • Databases and Schemas

  • Tablespaces

  • Users, Groups, and Permissions

  • Logging Server Activity

  • Write-Ahead Log Methods

Day 2 Topics Include:

  • Backing Up and Restoring

  • Monitoring the Server

  • SQL and Querying the database

  • Large Objects

  • Transactions and Locks

Day 3 Topics Include:

  • Concurrent Indexing

  • Full Text Indexing and Searching

  • Understanding Query Plans

  • Indexes & Advanced Optimization

  • Vacuum and the Free Space Map

  • Streaming Replication
  • Session Pooling
  • Views/Rules

Day 4 Topics Include (For Developers):

  • Extending the Server with SQL and PL/pgSQL Functions

  • Extending the Server with C

  • Extending the Server with Java

  • Extending the Server with Perl

  • Window Functions

  • Triggers and Rules

  • Accessing PostgreSQL Using libpq

After being lectured on a topic, students will gain hands-on experience by doing exercises on the presented material.

Prerequisites: Students should be familiar with working in a Linux environment and have basic SQL skills.

For more information visit

call 1-866-892-5315

Or email

Posted by Modern Course (

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 | Twitter
Copyright © 1996-2018 The PostgreSQL Global Development Group