Optimizing Queries for Performance by Using Microsoft® SQL Server„¢ 2005(4372)


In this 2-hour workshop, you will learn how to optimize database queries to enhance performance in your Microsoft® SQL Server™ 2005 Database solutions. Topics include the importance of query optimization, the role of the query optimizer, and the guidelines for building efficient queries.

In the lab, you will optimize stored procedures and views, as well as measure the performance after these database have been optimized. As a workshop, most of the learning will be done within the lab itself.

Having this experience will enable you to address performance issues that arise from poorly performing queries within your database solutions.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.



  • Describe how queries are processed by SQL Server
  • Identify the role of the query optimizer
  • Use subqueries
  • Build efficient queries


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-OQP-UMS
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend