Designing the Physical Database for SQL Server 2005

This course is included in our On-demand training solution.

Overview

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

165 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?