Designing the Physical Database for SQL Server 2005


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures

Target Audience
Professionals pursuing a career as a Database Administrator

Prerequisites
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005

Expected Duration (hours)
2.8

Lesson Objectives

Designing the Physical Database for SQL Server 2005

  • identify considerations when designing the physical structure of a database in a given scenario.
  • recognize how to normalize and document a database in a given scenario.
  • determine how to improve a database design for performance using normalization, given a scenario.
  • identify the appropriate strategy for designing filegroups in a given database scenario.
  • identify the appropriate strategy for designing tables in a given database scenario.
  • identify the appropriate strategy for designing indexes and views, given a scenario.
  • determine the appropriate strategy for designing database objects in a given scenario.
  • recognize best practices for using naming conventions and standards in a given scenario.
  • recognize best practices for establishing a database change control procedure for a given scenario.
  • determine the appropriate database naming standards and change control procedures to use in a given scenario.

    • Course Number:
    236765_eng