Skip to main content

Module 4: Data Objects

In this module, you will learn the following:

  • Tables are the main objects that store data
  • Indexes, views, stored programs and other objects are the support structures
  • Various table types compared based on data organization
  • Various index types compared
  • Native and non-native data type support
  • Block-level storage architecture

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 4: Demo 1

In this demonstration you will see how to:

  • Create a query to view allocation units
  • Determine why multiple results for a single index might be provided

Video Download
WMV

Length: 6 Minutes 9 seconds


Module 4: Demo 2

In this demonstration you will see how to:

  • Create a table taking advantage of filegroups for different types data structures
  • Review the results using SSMS

Video Download
WMV

Length: 12 Minutes 36 seconds


Module 4: Demo 3

In this demonstration you will see how to:

  • Define geometric shapes
  • Define an organizational structure for a company

Video Download
WMV

Length: 9 Minutes 11 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?