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.

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

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