Course Ref: 42140

Course: MS2784 Tuning and Optimizing Queries using Microsoft SQL Server 2005

Course Summary

This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft® SQL ServerT 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.

Course Outline

Modules include:

  • Measuring Database Performance
  • Optimizing Physical Database Design
  • Optimizing Queries for Performance
  • Refactoring Cursors into Queries  
  • Optimizing an Indexing Strategy
  • Managing Concurrency

By the end of the course, delegates should be able to:

  •       Normalize databases.
  •      Design a normalized database.
  •      Optimize a database design by denormalizing.
  •      Optimize data storage.
  •      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.

Where & When

LocationWokingham
Start Date20 Oct 08
Price (ex. VAT)£595.00
Venue Info Wokingham - Mulberry Business Park
ResidentialNo
AvailabilityFull
Duration3 days
Delivered AsVenue and on-site
Pre-course Reading
No precourse reading is specified.
Exam IncludedNo
Course Ref42140