PostgreSQL - Bespoke Certificate for Sorin Bragus
Certificate ID:
797207
Authentication Code:
1e269
Certified Person Name:
Sorin Bragus
Trainer Name:
Michał Kuna
Duration Days:
5
Duration Hours:
35
Course Name:
PostgreSQL - Bespoke
Course Date:
27 January 2025 10:00 to 31 January 2025 17:00
Course Outline:
Architecture
Memory management, CPU, IO, cgroup for postgresql – resource management
Basic configuration & Installation
Access Control
Backup (logical, physical, PITR) - in depth
Replication (sync, async, replication slots) - in depth
Extensions: FDW, monitoring, statement optimization
partitioning
PLPGSQL - cover basics for Admins
Slony
Upgrade
Tablespaces
Vacuum including extensions
HOT
Query plans
Transactions and locking
Indexes
CTEs
Monitoring
Logs