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.
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.
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