Refactoring Cursors into Queries by Using Microsoft® SQL Server„¢ 2005(4373)


Description:

In this 2-hour workshop you will learn how to refactor row-cursor based operations into queries in order to enhance performance in your Microsoft® SQL Server™ 2005 Database solutions. Within the workshop, you will learn several different methods for refactoring, as well as guidelines for when to use cursors.

In the lab, you will refactor several different types of cursors into queries. 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.

 

Objectives:

  • Identify guidelines for using cursors
  • Describe how cursors impact performance
  • Refactor cursors in queries
  • Use Common Table Expressions and Pivot

 




User Reviews

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

Course Info

  • Code: EL-RCQ-SQL
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend