PostgreSQL – administration and performance tuning
This course is perfectly suitable for database administrators and sysadmins, dealing with topics related to administration and performance tuning.
Information about the course
| Designed for the product: | PostgreSQL |
|---|---|
| Group size: | Group of up to 15 students |
| Type of exam: | 30 min, theoretical |
| Requirements: | None |
| Next level: | PostgreSQL – High Availability & Patroni |
| Previous level: | PostgreSQL Professional |
| Course language: | Czech |
| Available online: | Yes |
| Course length: | 4 DAYS |
| Course price: | € 2,000 excluding VAT |
Course content
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
Jakub Zemanek
Technical Consultant & DBAJakub's main interests in the OpenSource world are advanced PostgreSQL configuration and database troubleshooting, followed by automation using Ansible, and last but not least the ELK Stack (LOG Management) and the security product Wazuh (SIEM). As Jakub likes to say about himself: "I'd rather do it best than somehow." This is also why he is constantly educating himself and pushing the boundaries of his capabilities.
Additional information
Each participant will be provided with a PDF of the presentations
Certificate
- Each participant will be provided with a PDF of the presentations
- After successfully passing the exam, you will obtain the offical Cybertec certification
Course Gifts
