Description
Training objective: The learner will learn to optimize the performance of applications linked to a PostgreSQL database.
Learning Objectives
- Optimize configuration options
- Understand the differences between tables, views, and materialized views to improve development and performance
- Apply partitioning
- Implement indexes
- Control transactions and their impact on performance
- Read the execution plan of an SQL query
- Use statistics to modify the execution plan of an SQL query
- Develop processing by parallelizing queries
- Execute efficient data loads
- Develop a methodology for diagnosing slow queries and countermeasures
Target Audience
Database Administrators
System Engineers
Project Managers
Senior Developers
Prerequisites
Mastery of relational databases and SQL language
Practical experience with PostgreSQL database server
Program Outline
Informations
Duration
3 jour(s)
21h
Tarif
2100 € HT
HT
Similar Trainings
IA & Data
Cloud Migration
2 jour(s)
Sur demande
IA & Data
AI Agents – Designing Autonomous Systems with LangChain and LangGraph – Advanced
3 jour(s)
Sur demande
IA & Data
European AI Act — Understanding your obligations and ensuring compliance — Beginner level
1 jour(s)
Sur demande
IA & Data
Data Analysis with Microsoft Power BI (4-167)
3 jour(s)
2200 € HT