Tuesday, July 22, 2014
 
 

Understanding Database Architecture

In this tutorial, 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
 

Connecting and Reviewing Databases

In this tutorial you will see how to:

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









 

Review Catalogs & Data Dictionary

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





 
Understanding SQL Server 2008 Data, Storage and Transaction Logging Architecture

In this module, you will learn about schema and data structure (objects), storage architecture, logging model, and the data dictionary.
HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM