SQL

2784A Tuning and Optimizing Queries Using Microsoft SQL Server 2005

About this Course
Elements of this syllabus are subject to change.
This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times. The workshop focuses on systematic identification and optimization of database factors that impact query performance.
Audience Profile
This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.
At Course Completion
After completing this course, students will be able to:
Normalize databases.
Design a normalized database.
Optimize a database design by denormalizing.
Optimize data storage.
Manage concurrency
Manage concurrency by selecting the appropriate transaction isolation level.
Select a locking granularity level.
Optimize and tune queries for performance.
Optimize an indexing strategy.
Decide when cursors are appropriate.
Identify and resolve performance-limiting problems.