Skip to main content

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

Length: 42 Minutes 16 seconds

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

Module 2: Demo 1

In this demonstration you will see how to:

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

Video Download

Length: 4 Minutes 6 seconds

Module 2: Demo 2

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

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