Choosing a Cursor Strategy for Microsoft® SQL Server„¢ 2005(4352)


Description:

In this 1-hour premium course you will learn about how to design a cursor strategy within your Microsoft® SQL Server™ 2005 Database solutions. Topics covered include client-side and server-side cursors as well as best practices and pros and cons of each type.

Having this experience will enable you to design databases that correctly meet the data retrieval and processing needs of your organizations applications.

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

 

Objectives:

  • Use row-based and set-based operations
    • Use result set-based operations
    • Select cursor-based operations
    • Replace cursors with set-oriented operations
  • Use server-side cursors
    • Cursor lifecycle
    • Performing row-by-row Operations without cursors
    • Monitor Transaction Isolation Level effect
    • Use Positional Updates
  • Use client-side cursors
    • Use client data access libraries

 




User Reviews

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

Course Info

  • Code: EL-CCS-MSS205
  • Duration: 1 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend