2
For Administrators
DBA1, 3 days
Basic Course
on PostgreSQL Administration
DBA2, 4 days
Configuration and Monitoring
QPT, 3 days
Query Optimization
DBA3, 2 days
Backup
and Replication
SQL Basics
Any textbook of your choice
PGPRO, 3 days
Features of
Postgres Pro Enterprise
Prior knowledge of the basics of the SQL language is required to complete
all courses. There is no course on the SQL language in our line of courses,
but there are many books and other educational resources that can help you
master SQL.
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 provides an
overview of access control, 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.
The DBA3 course is devoted to backup, as well as physical and logical
replication configuration and scenarios for its use. It also provides an
overview of the methods and difficulties of building highly accessible,
scalable clusters.
The QPT course examines in detail the mechanisms for planning and
executing queries, discusses the configuration of instance parameters
related to performance, and examines the options for finding problematic
queries and optimizing them.
The PGPRO course discusses additional features provided by the Postgres
Pro Enterprise DBMS.