Module 2: Database Architecture

In this module, you will learn the following:

• Schema and Data Structure (Objects)
• Storage Architecture
• Data Blocks, Extents, and Segments
• Storage Allocation
• Managing Extents and Pages
• Tablespaces and Datafiles
• SQL Server Data Files
• Mapping of Tablespaces and Filegroups
• Logging Model
• Data Dictionary

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 16 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:

• Connect to an instance
• Review system databases
• Review application or user databases

Video Download
WMV

Length: 4 Minutes 6 seconds

In this demonstration you will learn how to:

• View the dictionary with object explorer
• View the data dictionary with catalog views
• View the data dictionary within a database
• View the data dictionary via system stored procedures

Video Download
WMV

Length: 9 Minutes 32 seconds