Complete PostgreSQL 9.6 Webinar

Date: 2017-03-23 – 2017-03-26

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.