Administrators
DBA1, 3 days
Basic Course
on PostgreSQL Administration
DBA2, 4 days
Configuration and Monitoring
QPT, 3 days
Query Performance Tuning
DBA3, 2 days
Backup and Replication
SQL Basics
Any textbook of your choice
PGPRO, 3 days
Features of
Postgres Pro Enterprise
For administrators, we offer the following courses.
The DBA1 basic course provides general information about the PostgreSQL
architecture, installation process, basic server configuration and
management. It also considers basic administration tasks and access
control issues. Lastly, it provides an overview of backup and replication
mechanisms.
The DBA2 course focuses on determining appropriate configuration
parameters based on an understanding of the internals of the server. It also
talks about monitoring the server and using feedback for iterative parameter
tweaking. Besides, it touches upon localization settings, extension
management, and server upgrades.
The DBA3 covers backups, as well as configuration and usage scenarios of
physical and logical replication. It also provides a general overview of how to
build scalable high-availability clusters and discusses the related challenges.
The QPT and PGPRO courses are intended for both developers and
administrators.
DBA courses can be interesting to developers if they would like to deepen
their knowledge of PostgreSQL internals, or if there is no separate
administrator role in their project.