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

Intense PostgreSQL Training

Date: 2014-04-07 – 2014-04-10
Location: Los Angeles, CA, United States
Language: English

4 Days of Intense PostgreSQL 9.3 training You may take one or more days of this training by webinar or in Los Angeles :

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-365-4911

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