<- Back to all courses

[DBA 2]

 PostgreSQL

Advanced

🗓️ 12-16 January 2026

đź’» 5 live online sessions, 3h30m each

🎤 Includes: Q&A, theory and live demo

🏷️ Price: €850 before taxes

PREREQUISITES

  • To participate in this course, you must either have completed our
    (DBA1) PostgreSQL Essentials     course or possess practical experience with PostgreSQL daily operations (creating databases, managing roles, performing routine maintenance tasks, and exporting/importing data).
  • You should also be comfortable with SQL transactions and able to manage PostgreSQL services and configurations on Linux systems.
  • Familiarity with performance monitoring and basic shell scripting is also recommended.

For details see the course T&Cs

This advanced multi-day course is designed for database administrators who want to strengthen their knowledge of PostgreSQL internals and best practices.

  • PostgreSQL architecture and processes
  • Optimal configuration techniques
  • MVCC and the transactional engine
  • Physical backups and Point-in-Time Recovery (PITR)
  • Partitioning and connection pooling
Register
What you'll learn

What You’ll Learn

The course is designed to equip you with the essential skills to install, operate, maintain, and monitor PostgreSQL for reliable and efficient database management.

PostgreSQL architecture and Write-Ahead Logging

This chapter introduces PostgreSQL’s internal architecture, focusing on how it manages processes, memory, and durability. Highlights include:

  • The main background processes and their responsibilities
  • Shared and per-process memory areas, and their tuning
  • How PostgreSQL organises files in PGDATA
  • The role of Write-Ahead Logging (WAL) in ensuring data consistency and recovery

This chapter explores PostgreSQL’s Multi-Version Concurrency Control (MVCC) model and how it ensures both consistency and concurrency. Highlights include:

  • How PostgreSQL manages row versioning with system columns such as xmin, xmax, and ctid
  • The impact of isolation levels (READ COMMITTED, REPEATABLE READ, SERIALIZABLE) on transaction consistency
  • The internals of VACUUM and autovacuum: cleaning dead tuples, trigger conditions, and tuning options
  • Strategies to prevent bloat and protect against transaction ID wraparound

This chapter introduces the principles and practices of Point-in-Time Recovery (PITR) in PostgreSQL. Highlights include:

  • Continuous archiving and its role in recovery
  • Configuring WAL archiving for PITR
  • Performing file system backups with pg_basebackup or manual methods
  • Executing a point-in-time recovery and controlling recovery targets
  • Best practices for backups, restore testing, and minimising downtime

This chapter introduces declarative table partitioning in PostgreSQL, a feature designed to simplify the management of large datasets. Highlights include:

  • An overview of the partitioning methods: list, range, and hash
  • How to define multi-column and nested (sub-)partitions
  • Managing partitions: attach, detach, and default partitions
  • Performance considerations and planning-time behaviour
  • Common limitations and best practices for effective partitioning

This chapter explores how PostgreSQL can efficiently handle large numbers of client connections through connection pooling, focusing on PgBouncer. It covers:

  • Why and when to use a connection pooler
  • Comparison of pooling modes: session, transaction, and statement
  • Installation, configuration, and monitoring of PgBouncer
  • Advanced usage: delegated authentication, query cancellation, and multi-instance scaling

Format and Schedule

This extensive PostgreSQL course consists of 5 live sessions (3h30m each), delivered over five days, w/c 12 January 2026.

To receive a certificate of attendance, participants must attend all five sessions.

  • Sessions will be conducted in English via Zoom.
  • Participants must have the latest version of Zoom installed on their computer.
  • Please note: Sessions will not be recorded.
  • The course format combines theoretical slides with live demos, led by the instructor in real time. Each session includes a live Q&A for direct interaction.
  • There will be a 10-minute break halfway through each 3.5-hour session.

Cost: €850 before taxes.

Session Schedule

(all times CEST)

Monday,
12 January

10:00–13:30

 

Tuesday,
13 January

10:00–13:30

 

Wednesday,
14 January

10:00–13:30

Thursday,
15 January

10:00–13:30

 

Friday,
16 January

10:00–13:30

Register now!

Course duration: 5 days, 5 sessions; 3.5 hours each 

Course cost: €850 before taxes

Course Terms & Conditions

📝 Following the form submission: You’ll receive payment instructions via email.

💳 Payment Methods: Credit card or direct bank transfer.

⚠️ Important: Your spot is only confirmed once payment is received.

đź“© If you have any questions or issues, please contact us at [email protected]

By providing your information, you consent to its processing as described in our Privacy Policy and agree to receive updates and communications from Data Egret GmbH. You may withdraw your consent at any time.

Instructors

Thom Brown has worked in the industry for over 20 years. With many years of experience working with PostgreSQL, he has extensive expertise in supporting clients on their PostgreSQL journey, helping them achieve high availability for their business-critical projects.
Thom Brown
PostgreSQL Consultant

Stefan has close to 15 years of expertise in the database space, boasting extensive experience in client support, maintenance, and architectural consulting.
He is a recognised PostgreSQL contributor and a contributor to pgBackRest, a reliable backup and restore solution for PostgreSQL.

Stefan Fercot
Senior PostgreSQL Expert

© 2025 All Rights Reserved.