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 very first week of next year. The title of the course is ‘MS SQL Server 2005/2008 Query Optimization And Performance Tuning‘.
The course is scheduled to be delivered from 4th Jan, 2010 and 6th Jan, 2010 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.
Call to register – +91 98817 95739, +91 98508 43664, +91 99229 33319
Email to register – workshop “at” seedinfotech.com
If due to any reason, you can not 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 you space for sure.
We do plan to offer this course in other cities. Keep checking this blog.
Reference: Pinal Dave (http://blog.SQLAuthority.com)