Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

PostgreSQL Administration (5 days)

As the most advanced PostgreSQL course in the industry, this course covers a broad range of diverse topics of importance to administrators. Students attending this course will learn how to administer and performance tune a database, and learn how to leverage other useful modules, such as connection pooling, full text searching, and replication.

Our PostgreSQL Administration course is the perfect course for those with limited SQL experience that wish to learn how to administer a PostgreSQL cluster. The course includes exercises designed to provoke thinking and discussion in the classroom - allowing students to learn from the mistakes and experiences of their peers in the classroom.

Read what previous students have said about this course:
PostgreSQL Admin Review

PostgreSQL Administration Course Calendar (5 days)


Call for upcoming dates or on-site delivery.
¹ Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. ² Include course and course materials only. ³ Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone. For government and education pricing, please contact us.

Recommended Pre-requisites

Students attending this course should have a strong grasp of Linux fundamentals, and an understanding of Structured Query Language (SELECT, INSERT, UPDATE, and CREATE TABLE statements in particular).

Course Outline/Agenda

For a more detailed list of topics covered in this course, refer to the PDF Table of Contents for our course guide below.

This course covers the following topics:

Installing & Configuring PostgreSQL
- Host access control with pg_hba.conf
- Configuring PostgreSQL for secure access with OpenSSL
Using the psql client
Creating & Managing Views (including updateable views.)
Creating & Managing Indexes
- Creating Indexes
- Indexes on expressions
- Partial indexes
Transactions and Concurrency
Managing database privileges
- Understanding PostgreSQL roles
- User Roles
- Assigning users to roles
- Understanding role access
Access control with GRANT
PostgreSQL data organization
- PostgreSQL storage
- Managing table space usage
- PostgreSQL log directories
- Other directories
- Managing PostgreSQL clusters
Creating & Managing PostgreSQL tablespaces and databases
PostgreSQL Schemas
PostgreSQL logging
Backup and recovery (pg_dump, pg_dumpall, file system backups, pg_basebackup)
Continuous Archiving and Point-in-time-recovery
- PostgreSQL Write-ahead logs
- Performing PITR backups
- Performing PITR recovery
Server monitoring & performance tuning
Understanding & Managing Auto-Vacuum
PostgreSQL Hot Standby & Streaming Replication
- Setting up streaming replication
- Understanding and Managing performance of streaming replication
- Synchronous and Asynchronous replication
- Monitoring replication
Connection Pooling for Web Applications with pgBouncer

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

The Open Technology Group offers the most complete and comprehensive set of PostgreSQL courses in the industry. Our instructors extensive experience implementing PostgreSQL solutions translates to practical examples in the classroom. Our PostgreSQL courses are current to the latest release (9.4) of PostgreSQL. We regularly build customized courses to meet our customers specific application needs - contact us today for more information on our affordable on-site, customized, PostgreSQL courses.

Instructional Materials

The following materials are used to deliver this course:

PostgreSQL, 2nd Edition
OTG Course Guide

View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

PostgreSQL Admin Training Logo

View upcoming course calendar

info@otg-nc.com
877-258-8987