<- Back to all courses

[DBA 1]

 PostgreSQL

Essentials

🗓️ Registration is now closed. If you are interested in attending a future sessions, please join the waitlist.

đź’» 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
Join Waitlist
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 17 November 2025.

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,
17 November

10:00–13:30

 

Tuesday,
18 November

10:00–13:30

 

Wednesday,
19 November

10:00–13:30

Thursday,
20 November

10:00–13:30

 

Friday,
21 November

10:00–13:30

Join the waitlist 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

Ilya Kosmodemiansky has been working with PostgreSQL for more than 20 years, supporting clients in building robust, high-performance database systems.


As a recognised PostgreSQL contributor and consultant, he brings deep technical expertise and a passion for open-source excellence.

Ilya Kosmodemiansky
CEO, Founder, Data Egret GmbH & PostgreSQL Consultant

© 2025 All Rights Reserved.