Online Course: SQL Server Locking, Blocking and Row Versions

Five Sessions Brought to you by SSWUG.org

 

Course Overview

In SSWUG.ORG’s virtual class, you will learn about locking, blocking and row versions, which are some of the most important topics to understanding SQL Server’s internal behavior. By the end of the five sessions, you will know how these technologies are used to manage SQL Server concurrency - the ability of multiple users to access data at the same time.

Watch Video

Kalen Delaney, course instructor and celebrated author of SQL Server 2008 Internals, will start by discussing what consistency might mean to one’s applications, and describe the details of how each of the concurrency models works internally. She will examine the costs and trade-offs between the two concurrency models that SQL Server 2008 supports through different transaction isolation levels.

The target audience of this class is administrators, developers or IT professionals who have some experience with SQL Server Management Studio and TSQL queries, as well as an understanding of basic transactional work processing. Most importantly, students should want to learn more about the way SQL Server works internally and how to take advantage of the inner working to create the best performing system and applications possible.

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Design an application with concurrency in mind
  • Understand the ways SQL Server manages concurrent user access
  • Spot causes of poor application performance
  • Troubleshoot concurrency problems
  • Recognize the details of both concurrency models – optimistic and pessimistic

     

Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (.PDF via e-mail).


  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


 
 

Group Registration

  • Does your company have more than 1 person interested in this class? Take advantage of immediate savings by completing the group registration process. To start the group registration process downoad our form here.


Speakers

  • Kalen Delaney

    Kalen Delaney has been working with SQL Server for over 26 years. She has provided performance consulting services and taught advanced courses...