Skip to main content

Module 5: Data Access

In this module, you will learn the following:

  • Introduce database components involved in data access
  • Introduce concepts of Transact -SQL and Procedural SQL as tools to access and manipulate data
  • Discuss transactional management concepts

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: 42 Minutes 32 seconds

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

Module 5: Demo 1

In this demonstration you will see how to:

  • Provide tracing within SQL Server
  • Review the execution plan for simple queries
  • Compare execution plan to the trace profiler
  • Review execution plan

Video Download

Length: 13 Minutes 46 seconds

Module 5: Demo 2

In this demonstration you will see how to:

  • Generate a query
  • Declare and use variables and row constructors
  • Aggregate summary data

Video Download

Length: 13 Minutes 24 seconds

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?