PostgreSQL Administration

Basic course

13

Copyright

© Postgres Professional, 2015–2022

Authors: Egor Rogov, Pavel Luzanov, Ilya Bashtanov

Feedback

Please send your feedback, comments and suggestions to:

Disclaimer

In no event shall Postgres Professional company be liable for any damages

or loss, including loss of profits, that arise from direct or indirect, special or

incidental use of course materials. Postgres Professional company

specifically disclaims any warranties on course materials. Course materials

are provided “as is,” and Postgres Professional company has no obligations

to provide maintenance, support, updates, enhancements, or modifications.

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 with which you

For administrators, we offer the following courses.

The DBA1 course (this one) is a basic overview course. It provides general

information about the architecture of PostgreSQL, the installation process,

basic configuration and server 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.

and examines the options for finding problematic queries and optimizing

them.

DEV1, 4 days

QPT, 2 days

For backend developers, we offer the following courses.

The DEV1 course is the introduction to backend development. It provides

general information about the architecture of PostgreSQL and the use of

basic database objects; server-side programming in SQL and PL/pgSQL

languages using basic data types (including the composite type and arrays),

as well as fronted interactions.

The DEV2 course examines the features of the server's internal structure

that affect the development of application code, and comprehensively

discusses extensibility: the ability to extend server mechanisms with your

own code, which allows you to use PostgreSQL to solve a wide variety of

The QPT course is intended for both developers and administrators.

If you are taking the course on your own, start with the Student's guide.

Among other things, it shows where to download and how to use the virtual

machine and other materials. All course materials, including the Student’s

Completing practical assignments is very important to gain the basic skills

in working with PostgreSQL. Try to complete the assignments yourself first,

and then review the provided keys, even if the assignment did not raise

questions. Assignment keys may contain additional information that is not

mentioned in presentations and demonstrations.

Course handouts (presentations, demonstrations, practical assignments and

keys) are available in two formats: html is good for browsing and copying

code snippets, while pdf is split in pages and is more convenient for printing.

Additional reference materials will help you quickly find the information you

need.