Registration - Online Course: SQL Server Locking, Blocking and Row Versions

Online Course: SQL Server Locking, Blocking and Row Versions

Five On-Demand Sessions Start on Oct. 11, 2011 and End Nov. 10, 2011

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.

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 classes, 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, office hours and the ability to email questions to the instructor are included with course purchase only.

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

Event Registration

Confirm Conference Registration Selection

Online Course: SQL Server Locking, Blocking and Row Versions
EVENT is Closed
- Standard Rate: $199.00

High Definition DVD
- Get an additional copy of the video presentations and other materials on DVD for later viewing. $399.00

SSWUG Membership
- Receive a 12-Month Membership to SSWUG.ORG to Access Exclusive Content and Save on Future Virtual Classes, Expos and Webcasts. $79.00

Registration Total: $0.00

Please Confirm Your Information

Email Address Invalid Email Format
Email Required

Desired or Current Password Password Required

First Name *	Last Name *	Phone Number * *
Address Line 1 *	Address Line 2	Zip/Postal Code *
City *	State/Province *	Country *
Company: *
Name on Credit Card *	Card Number * Note: no dashes or spaces	Email CC for Receipt * We'll email a copy of the receipt to this address.
Card Security Code: * What's This?	Expiration Date:

Attendee Survey

What is your organization’s size?	* *
Which industry do you work in?	* *
Which of these options best summarizes your current job title?	* *

Submitting Registration

reg

By registering, you agree that your registration information may be shared with the sponsors of this offering (if any) to be used in providing newsletters, announcements or other online or offline materials of interest.

Conference Registration

Your registration includes:
- Access to the virtual event's video content
- Live, interactive chat with other attendees, speakers and sponsors
Not sure you can attend on the first day? No problem! All the video content will be available on-demand for 30 days. If you are unable to view all sessions within the 30 days, we can offer a course extension for $79.00.