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: | English |
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 & DBAAdditional information
Certificate
- After successfully passing the exam, you will obtain the offical Cybertec certification