PostgreSQL Immersion

This course combines parts from three shorter classes, covering administration, performance, advanced development, and replication as a self-contained unit with very few prior requirements which is ideal as a speedy induction to PostgreSQL. Suitable for a wide range of attendees, including database administrators having prior experience with other database software.

Prerequisites Topics Acquired skills

Students must have a working knowledge of SQL. Using the command line interface to a Linux system and some basic UNIX shell programming experience is needed to complete all of the replication workshop exercises.

Who should attend?

Database administrators, systems administrators, or developers with working knowledge of database usage.

• Introduction to PostgreSQL

• Server Configuration

• Database Administration

• User Administration

• Understanding Database Object Types

• Permissions & Security

• Running SQL

• Monitoring

• VACUUM, Freezing & Avoiding Wraparound

• Maintenance

• Server Architecture & Caching

• Tuning Parameters

• Locking & Concurrency

• Database design alternatives

• Advanced Development Summary

• Reading EXPLAINs

• Workload Analysis, Benchmarking and Profiling

• Join Planning

• Indexes

• SQL Performance Tips & Tricks

• Logical Backup

• Replication Overview

• Replication Terminology

• Replication Transport

• Replication Startup & Setup

• Disconnection and Reconnection

• Switchover, Failover and Failback

• Physical Streaming Replication

• repmgr

• Logical Streaming Replication & pglogical

• Bi-Directional Replication

• Logical Decoding

• Online Upgrade

• Connection Pooling

• Sharding and Scale Out

• Physical Backup

• Point In Time Recovery

• Barman

Comprehensive skills and a solid understanding of PostgreSQL, from database administration, development, performance, replication and recovery concepts.

Tags: Introduction to PostgreSQL 9 Database Administration, Advanced Development & Performance Summary, PostgreSQL 9 Replication & Recovery Concepts

Length: 5.00 days

Upcoming related events

Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.