Are you a SQL Server developer or administrator looking to enhance your skills and optimize the performance of your queries? Look no further! We are excited to announce our upcoming course on ‘Training MS SQL Server Query Optimization and Performance Tuning’.
This intensive three-day course is designed to provide attendees with an in-depth understanding of query optimization and performance tuning concepts and methods found in SQL Server 2005/2008. Whether you are preparing for a transition to SQL Server 2005/2008 or simply looking to improve your skills, this course is perfect for you.
Course Details
- Date: 19th November 2009 – 21st November 2009
- Location: Pune, India
Course Outline
Day 1: Strengthening the Basics and Exploring 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
Spaces for this course are limited, so we encourage you to register as soon as possible to secure your spot. If you are unable to attend this session, please contact us for information on future course schedules and locations.
Don’t miss out on this opportunity to enhance your SQL Server skills and take your query optimization and performance tuning to the next level. Register today!