SQL Performance Pitfalls: Identification and Optimization Lab

This interactive workshop presents realistic examples of bad SQL programming that often lead to performance problems in practice. The aim of the session is to show participants how to identify, analyze and optimize inefficient SQL queries/SQL code in order to achieve significant performance improvements.
The workshop focuses on five to ten concrete, poorly implemented SQL coding scenarios. For each of these scenarios, the underlying problems are explained in detail and optimization approaches are then presented. Different techniques and best practices are presented that are essential for improving query speed and system efficiency.
With the help of practical lab exercises, load tests are generated to measurably compare performance before and after optimization. This allows participants to directly understand which measures lead to a significant reduction in response times and what impact they have on the overall system load.
At the end of the session, participants will have a better understanding of the most common pitfalls in SQL programming practices and will be able to perform in-depth performance analyses and make optimizations.

- Identify and analyze inefficient SQL coding practices through real‑world examples that commonly cause performance issues. Apply optimization techniques and best practices to improve query speed and overall system efficiency. Evaluate performance improvements via hands‑on lab exercises and load tests, gaining practical skills in measuring and reducing response times.