PostgreSQL Professional
This course provides a deep insight into advanced PostgreSQL topics like indexing, storage parameters, optimization, replication, monitoring, etc. It covers the technical foundations required for replication, scaling, point-in-time recovery, and the successful operation of synchronous and asynchronous replication solutions. Moreover, details of processing that are essential for optimization and performance tuning are highlighted, so that you can get the most out of your system and queries.
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 – administration and performance tuning |
| Previous level: | Introduction to PostgreSQL |
| Course language: | Czech |
| Available online: | Yes |
| Course length: | 3 DAYS |
| Course price: | € 1,500 excluding VAT |
Course content
Day 1
- Installation
- Advanced psql
- Advanced indexing: Multi column indexes, GIN indexes, GiST indexes
- Full text search
- Exclusion Constraints
- Range data types
- Arrays and JSON in the database
- Transactions: isolation levels, serialization
- Prepared transactions, two-phase commit
Day 2
- Physical Backup: Low-level API
- Autovacuum: advanced tuning
- Streaming replication
- Synchron replication
- Hot Standby and conflict management
- Failover
- High Availability, Patroni
- Logical replication
Day 3
- Partitioning
- Parallel queries
- Foreign Data Wrapper
- Functions
- Statement tuning: finding slow statements
- 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
- After successfully passing the exam, you will obtain the offical Cybertec certification
Course Gifts
