<- Back to all courses

[DBA 1]

 PostgreSQL

Essentials

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

🎤 Includes: Q&A, theory and live demo

🏷️ Price: €850 before taxes

🗓️ 24-28 August, 2026

Register

PREREQUISITES

Basic command line skills in Linux, basic SQL knowledge, and familiarity with networking concepts and configuration files.

For details see the course T&Cs

Intensive five-day course for database administrators, who want to build a strong foundation in PostgreSQL operations and management.

  • PostgreSQL installation
  • Definition of key PostgreSQL concepts
  • Day-to-day DBA tasks
  • Maintenance tasks
Course Curriculum

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 project and community
This chapter introduces PostgreSQL’s development, release process, ecosystem, community, and key concepts. Highlights include:
  • Project history: evolved from Ingres in the 1980s, PostgreSQL became open source in 1996 and is now a leading relational database system.
  • Release cycle: annual major releases and five years of support, with quarterly minor updates.
  • Ecosystem: rich set of extensions and tools (e.g., PostGIS, Citus, TimescaleDB) via CREATE EXTENSION.
  • Community: active global network with mailing lists, events (e.g., pgconf.eu), and user groups.
  • Core concepts: SQL standard compliance, ACID properties, MVCC, transactional DDL, and isolation levels.
This chapter introduces the essentials of setting up and understanding PostgreSQL. Highlights include:
  • Installation methods: from source, PGDG packages, Docker, or Windows installer.
  • Key SQL objects: instances, global (databases, roles, tablespaces) and local (schemas, tables, views, indexes).
  • Important configuration files: postgresql.conf for server settings, pg_hba.conf for client authentication.
  • Version management: applying minor upgrades and planning major version migrations.
This chapter introduces the essential operations for running PostgreSQL on a daily basis. Highlights include:
  • Connecting to PostgreSQL: using psql and understanding connection methods.
  • Database management: creating and managing databases with SQL commands and createdb / dropdb.
  • Roles and privileges: understanding and administering roles, privileges, and ownership.
  • Routine maintenance: performing tasks with VACUUM, ANALYZE, and REINDEX.
  • Data export/import: using pg_dump, pg_dumpall, and pg_restore.

This chapter introduces key tools and techniques for monitoring PostgreSQL databases and diagnosing performance issues. Highlights include:

  • Server logs: analysing logs to detect problems, audit activity, and identify slow queries.
  • Statistics views: exploring built-in views such as pg_stat_activity.
  • Key performance indicators: monitoring cache hit ratio, I/O, WAL activity, replication, and bloat.
  • Extensions and tools: using extensions and external tools for diagnostics and query analysis (e.g., pg_stat_statements, auto_explain, pgBadger).
  • Troubleshooting workflow: applying a structured process to quickly identify and resolve issues.

Course Format & Requirements

Structure
5 live sessions (3.5 hours each)

Certificate
Participants must attend all five sessions to receive a certificate of attendance.

Platform
Sessions are conducted in English via Zoom. Please ensure you have the latest version installed.

Learning Format
The course combines theoretical slides with live demos and includes a live Q&A during each session.

Breaks
A 10-minute break halfway through each session.

Recording
Sessions will not be recorded.

Session Schedule

(all times CET)

Monday,
24 August

10:00–13:30

 

Tuesday,
25 August

10:00–13:30

 

Wednesday,
26 August

10:00–13:30

Thursday,
27 August

10:00–13:30

 

Friday,
28 August

10:00–13:30

Register now!

How registration works

1
Fill out the form

Complete the registration form below with your details.

2
Receive your invoice

An invoice and payment instructions will be sent to your inbox.

3
Complete payment

You can pay by credit card or direct bank transfer.

4
Secure your place

Your spot on the course is confirmed once payment has been received.

Course details

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

Dates: 24–28 August 2026

Course cost: €850 before taxes

Course Terms & Conditions

đź“© 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

Daria Nikolaenko is a database specialist with a strong focus on monitoring, high availability, performance tuning, and scalable system architecture. She has hands-on experience with PostgreSQL exporters and metric analysis, and brings deep expertise in building robust data infrastructures.
With a background in banking, finance, and telecommunications, Daria combines technical precision with real-world reliability.
Daria Nikolaenko
PostgreSQL Database Administrator

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

© 2026 All Rights Reserved.