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