This is very short note announcing details about my course details for ‘Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning’.
The course is scheduled to be delivered from 19th Nov, 2009 and 21st Nov, 2009 in Pune, India.
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 2005/2008. This course is designed to prepare the SQL Server developers and administrators for a transition to SQL Server 2005/2008 while discussing best practices for a variety of topics.
Day 1 : Strengthen the basics along with SQL Server 2005/2008 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 are 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.
Reference: Pinal Dave (http://blog.SQLAuthority.com)