Optimizing SQL queries requires attention to details. This course shows attendees how to maximize query performance through a variety of means, including index management, analyzing query execution plans, coding efficient queries, good data statistics, and more. Want to elevate yourself to a higher level of SQL programming? Want to differentiate yourself from most SQL developers in the world today? Want to understand how to execute and understand a SQL Server execution plan output? Want to know what it takes to get optimal performance out of queries, programs, and applications? Then this is your class! SQL statements will be broken down in detail so the participants understand in depth what the SQL Server optimizer goes through in fulfilling an SQL request, and what can be done in order to get it to run faster. Time will especially be spent breaking down SQL Joins, Subqueries, and Table Expressions in order to understand the fundamental issues associated with performance. Performance-related issues in relationship to database design, indexing, efficient and effective SQL queries, and the gathering of accurate statistical information for optimization are addressed. Participants will come out of this class being ‘Empowered’ and having a much better understanding of why certain optimizations are chosen, and what can be done to change them for the better. Much of the class will be in workshops where the participants will code and review queries, execute SQL Server explain plans, and performing analysis on the information. Many of the workshops have the participants rewrite and/or apply tuning statements to existing queries in order to get them to perform more efficiently. Participants will know exactly what steps to take in getting poor performing SQL queries to execute more efficiently.
Attendees should have knowledge of the Structured Query Language and some experience developing SQL queries.
3 Days/Lecture & Lab
This course is intended for SQL developers or anyone who is interested in tuning their queries to produce the best performance possible.
- SQL Server Optimization
- SQL Server Access Path Review/Plan Executions
- SQL Server Tuning Strategies
- Tuning Joins
- Aggregate Functions, SQL Subqueries & Performance
- Tables Expressions and Performance
- Statistics Analysis
- Working with the DBA