Advanced PgSQL (3 days)
What is it about?
The course places particular emphasis on database tuning (SQL and performance tuning), benchmarking, monitoring, and gaining a deeper understanding of specialized PostgreSQL features such as partitioning, extensions, managing external data sources (FDW), and optimizing connection management. The course covers both the theoretical and practical aspects of the tools and techniques needed to perform these tasks effectively.
Who is this course recommended for?
We recommend this training to professionals who already have a basic understanding of PostgreSQL, who are experienced database administrators (DBAs) and work in system and software architecture, and who are proficient in database management. IT professionals who wish to gain deeper technical knowledge in optimizing PostgreSQL environments
Prerequisite for starting the course:
The training is not tied to any specific degree, but a degree in computer science (at the high school or college level) may be an advantage. To successfully participate, you need general knowledge of the PostgreSQL system, basic database administration experience, intermediate knowledge of relational database management system (RDBMS) concepts, basic knowledge of the SQL language, and basic proficiency with the Linux operating system.
Planned topics for the course
- Introduction – An Overview of PostgreSQL's Advanced Features
- Database Monitoring – Monitoring Tools and Metrics, Log Analysis
- SQL Optimization – Query Analysis, How the Planner Works
- Performance Tuning – System-Level and SQL-Based Tuning Techniques
- Benchmarking – Designing tests, performance evaluation
- Extensions – Expanding functionality, e.g., pg_stat_statements, PostGIS
- Table Partitioning – Declarative and Inheritance-Based Partitioning, Performance
- Optimizing Connection Management – Using Connection Poolers (e.g., PgBouncer, Pgpool-II)
- Foreign Data Wrappers (FDW) – Connecting external systems (e.g., other databases, files)
- Upgrade Procedures – Version Upgrades, Migration, Data Security
Information about course dates can be found here. If you are interested in on-site or customized courses, would like to register for our courses, or would like to receive a quote, please contact us at training@ulx.hu and/or call us at +36 1 450 0921.