Course description
- Each participant will be provided with a PDF of the presentations
- After successfully passing the exam, you will obtain the offical Cybertec certification
- Type of exam: 30 min, theoretical
PostgreSQL – administration and performance tuning
Course code: PSQLAPT
This course is perfectly suitable for database administrators and sysadmins, dealing with topics related to administration and performance tuning.
Professional
and certified lecturers
Internationally
recognized certifications
Wide range of technical
and soft skills courses
Great customer
service
Making courses
exactly to measure your needs
Course dates
Starting date: 23.02.2026
Type: In-person/Virtual
Course duration: 4 days
Language: en/cz
Price without VAT: 2 000 EUR
Starting date: 19.10.2026
Type: In-person/Virtual
Course duration: 4 days
Language: en/cz
Price without VAT: 2 000 EUR
Starting date: Upon request
Type: In-person/Virtual
Course duration: 4 days
Language: en/cz
Price without VAT: 2 000 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| 23.02.2026 | In-person/Virtual | 4 days | en/cz | 2 000 EUR | Register | ||
| 19.10.2026 | In-person/Virtual | 4 days | en/cz | 2 000 EUR | Register | ||
| Upon request | In-person/Virtual | 4 days | en/cz | 2 000 EUR | Register | ||
| G | Guaranteed course | ||||||
Course structure
Day 1
- PostgreSQL project, support, community
- Architecture overview
- Installation, initializing data dir, starting and stopping the server
- The psql client
- Working with B-Tree indexes
- EXPLAIN
- Transactions: Atomicity, Isolation, Locking
Day 2
- Transactions: optimistic and pessimistic locks
- MVCC
- VACUUM
- Autovacuum
- Logical backup using pg_dump
- Physical backup, WAL archiving
- Point In Time Recovery
Day 3
- Streaming replication
- Synchronous replication
- Hot standby and conflict management
- Failover
- High availability, Patroni framework
- User management, authentication
- Remote access
- Permissions
Day 4
- Configuration settings
- Logging
- Resource management
- Parameters setting tuning
- Security
- Upgrade
- Statistics and monitoring
- SQL queries tuning
- EXPLAIN (ANALYZE, BUFFERS)
- Extended statistics
Prerequisites
Basic knowledge of PostgreSQL and basic knowledge of Linux OS.
Certification
- Type of exam: 30 min, theoretical
