Designing a Database Server Infrastructure for SQL Server 2005

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

---

Overview/Description
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 (hours)
2.2

Lesson 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.

Course Number:
236740_eng