Earlier this year we had offered Query Optimization course and it was sold out in minutes. Due to popular demand we are offering the same course in the very first week of next year. The title of the course is ‘MS SQL Server Query Optimization And Performance Tuning‘.
This three day course is an intensive course designed to give attendees an in-depth look at the query optimization and performance tuning concepts and methods found in SQL Server. This course is designed to prepare the SQL Server developers and administrators for a transition to SQL Server while discussing best practices for a variety of topics.
Day 1 : Strengthen the basics along with SQL Server New Features
Module 01: Subqueries, Ranking Functions, Joins and Set Operations
Module 02: Table Expressions
Module 03: TOP and APPLY
Module 04: SQL Server 2008 Enhancements
Day 2: Query Optimization & Performance Tuning 1
Module 05: Logical Query Processing
Module 06: Query Tuning
Module 07: Introduction to the Query Processor
Module 08: Review of common query coding, which causes poor performance
Day 3: Query Optimization & Performance Tuning 2
Module 09: SQL Server Indexing and index maintenance
Module 10: Plan Guides, query hints, UDFs, and Computed Columns
Module 11: Understanding SQL Server Execution Plans
Module 12: Real World Index and Optimization Tips
The space is limited and I encourage you to register as soon as possible.
If due to any reason, you cannot attend this course, please call or email on details above for future schedule for the course and location.
If you call and find whole course is sold out do contact me and I will try to get your space for sure.
We do plan to offer this course in other cities. Keep checking this blog.
Do reach out to me if you need any further help on this subject.
Reference: Pinal Dave (https://blog.sqlauthority.com)