Managing Concurrency by Using Microsoft® SQL Server„¢ 2005(4375)


Description:

In this 2-hour workshop, you will learn how to apply a locking strategy to your Microsoft® SQL Server™ 2005 Database solutions. Topics include transaction isolation levels and effective techniques to reduce locking and blocking.

Within the workshop, you will analyze database locking and blocking issues and apply techniques to reduce concurrency issues. As a workshop, most of the learning will be done within the lab itself.

Having this experience will enable you to address bottlenecks that occur in multiuser databases due to locking.

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

 

Objectives:

  • Use Transaction Isolation Levels
  • Reduce locking and blocking
  • Resolve deadlocks



User Reviews

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

Course Info

  • Code: EL-MCU-MSQL
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend