🗓️ 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

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.

Installing PostgreSQL

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.

Operating PostgreSQL Day-to-Day

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.

Monitoring and diagnostics in PostgreSQL

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