Module 6: Data Protection

In this module, you will learn the following:

Protecting data from unauthorized users and authorized users who are trying to update the same data simultaneously
Using locking modes to achieve concurrency and consistency
Implementing database security features to protect the database, database objects and data
Using auditing features to monitor database activity

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 23 Minutes 57 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.

Module 6: Demo 1

In this demonstration you will see how to:

Create a dirty read
Create a committed read with blocking
Create a snapshot isolation to remove blocking

Video Download
WMV

Length: 22 Minutes 55 seconds

Module 6: Demo 2

In this demonstration you will see how to:

Create a Windows user account
Associate a SQL Server login with the Windows user account

Video Download
WMV

Length: 7 Minutes 20 seconds