PostgreSQL for Administrators Training Course

Primary tabs

Course CodeCourse Code

postgresadmin

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

A basic working knowledge of SQL

Overview Overview

This course covers the administration and performance tuning of PostgreSQL databases. 

Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

Course OutlineCourse Outline

What is PostgreSQL?

  • A Brief History of PostgreSQL
  • Conventions
  • Further Information
  • Bug Reporting Guidelines

Introduction to PostgreSQL

  • Installation and Creating Database
  • The SQL Language
  • Advanced Features

The SQL Language

  • SQL Syntax
  • Data Definition
  • Data Manipulation
  • Queries
  • Data Types
  • Functions and Operators
  • Foreign Data Wrappers
  • Type Conversion
  • Indexes
  • Triggers
  • Full Text Search
  • The Information Schema
  • PL/pgSQL - SQL Procedural Language
  • Concurrency Control
  • Performance Tips
  • How the Planner Uses Statistics

Server Administration

  • Source Code vs Distribution-Provided Packages
  • Installation from Source Code
  • Installation from Source Code on Windows
  • Deployment of Binaries Obtained by Compiling Source Code
  • Server Setup, Operation
  • Database Physical Storage
  • Filesystem Durability Requirements and Required Mount Options
  • Server Configuration
  • Special Considerations for Container-Based Deployments
  • Client Authentication
  • Database Roles
  • Managing Databases
  • Localization
  • Routine Database Maintenance Tasks
  • Backup and Restore
  • Recovery Configuration
  • Monitoring Database Activity
  • Monitoring Disk Usage
  • Reliability and the Write-Ahead Log
  • Regression Tests
  • Installation of Third-Party Server Extensions

High Availability, Load Balancing, and Replication

  • Brewer's CAP Theorem
  • Synchronous vs Asynchronous Replication
  • Log Shipping (Warm Standby)
  • Streaming Master-Slave Replication (Hot Standby)
  • Trigger-Based Master-Slave Replication with Slony
  • Trigger-Based Multi-Master Replication with Bucardo
  • Connection Pooling and Synchronous Replication with Pgpool
  • Failover Configurations using DRBD
  • Replacing a Failed Server
  • Recovering from Network Partition

TestimonialsTestimonials

Trainer Subject Knowledge

Julian Pirau - BMO Financials

How to maintain the database, and how is the orgenazition of the data.

Jiang Chang - NAV CANADA

I liked everything he taught.

Emily Zhou - Ryerson University

I wish we could had a lab time, maybe the amount of time of training is tighten, we did not have lab time in class.

Gary Pan - Ryerson University

Bookings, Prices and EnquiriesBookings, Prices and Enquiries

Private Classroom
 
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
From 2650EUR
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Private Remote
1 2650EUR
2 1640EUR
3 1303EUR
4 1135EUR
Public Classroom
From 4150EUR
Request
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom
1 4150EUR
2 2440EUR
3 1870EUR
4 1585EUR
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients