Skip to main content

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

Length: 23 Minutes 57 seconds

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

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

Length: 7 Minutes 20 seconds