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
WMV

Length: 42 Minutes 32 seconds

Downloads
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
WMV

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
WMV

Length: 13 Minutes 24 seconds