Designing a Database Server Infrastructure for SQL Server 2005

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

Overview

To specify the appropriate requirements for implementing SQL Server 2005, identify suitable instance and physical storage strategies, and determine the appropriate way to design a database consolidation plan, given a SQL Server scenario

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

130 min.

Course Objectives

Designing a Database Server Infrastructure for SQL Server 2005

  • identify the infrastructure requirements for implementing SQL Server 2005 database server in a given scenario.
  • determine the appropriate configuration requirements of a given SQL Server 2005 implementation scenario.
  • identify an appropriate SQL Server instance deployment strategy for a given scenario.
  • identify the appropriate physical storage strategy for SQL Server 2005 in a given scenario.
  • determine the appropriate instance and physical storage strategies to implement for a specific SQL Server deployment scenario.
  • identify issues to be taken into consideration when gathering information for consolidation.
  • identify the steps involved in designing a SQL Server consolidation strategy, given a specific database scenario.
  • determine the appropriate strategy for designing a migration plan for a consolidated environment, given a specific SQL Server database scenario.

 

SUBSCRIPTION COST



 

NEED HELP OR NOT SURE?