<- Back to all courses

[DBA 1]

 PostgreSQL

Essentials

🗓️ 23-27 February, 2026

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

🎤 Includes: Q&A, theory and live demo

🏷️ Price: €850 before taxes

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
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 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.

Format and Schedule

This extensive PostgreSQL course consists of 5 live sessions (3h30m each), delivered over five days, w/c 23 February, 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 CET)

Monday,
23 February

10:00–13:30

 

Tuesday,
24 February

10:00–13:30

 

Wednesday,
25 February

10:00–13:30

Thursday,
26 February

10:00–13:30

 

Friday,
27 February

10:00–13:30

Register

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

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.