New Horizons Computer Learning Center
410-597-9722

2786: Designing a Microsoft SQL Server 2005 Infrastructure

Course Length: 2 Days

Overview:
This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasizes the tradeoffs that need to be made during design.

Prerequisites:
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Course 2779: Implementing a Microsoft SQL Server 2005 Database
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Course Objectives:
Upon successful completion of this course, students will be able to:

• Analyze storage, CPU, memory, and network capacity needs
• Design a strategy for data archiving
• Design a strategy for database server consolidation
• Design a strategy for data distribution
• Design a database server infrastructure
• Design a strategy for data recovery
• Establish database conventions and standards

Course Content

Lesson 1: Analyzing Capacity Needs

• Estimating Storage Requirements
• Estimating CPU Requirements
• Estimating Memory Requirements
• Estimating Network Requirements
• Lab 1: Analyzing Capacity Needs
• Gathering Requirements that Impact or Affect Capacity Needs
• Estimating Capacity Needs

Lesson 2: Designing a Strategy for Data Archiving

• Identifying Requirements that Affect Data Archiving
• Determining the Structure of Archival Data
• Creating a Data Archival Plan
• Lab 2: Designing a Strategy for Data Archiving
• Designing an Archiving Solution
• Defending Your Archiving Solution

Lesson 3: Designing a Strategy for Database Server Consolidation

• Overview of Database Server Consolidation
• Designing a Strategy for SQL Server Instances
• Designing a Database Server Consolidation Plan
• Lab 3: Designing a Database Server Consolidation Strategy
• Designing a Consolidation Strategy
• Defending Your Consolidation Strategy

Lesson 4: Designing a Strategy for Data Distribution

• Overview of Data Distribution
• Creating a Data Distribution Plan Using Replication
• Lab 4: Designing a Data Distribution Strategy Using Replication
• Designing a Data Distribution Strategy
• Defending Your Data Distribution Strategy

Lesson 5: Designing a Database Server Infrastructure

• Evaluating the Current Database Server Infrastructure
• Gathering Requirements for Changing a Database Server Infrastructure
• Designing Modifications to a Database Server Infrastructure
• Lab 5: Designing a Database Server Infrastructure
• Choosing a Database Server Hardware and Software
• Defending Your Database Server Hardware and Software Choices

Lesson 6: Designing a Strategy for Data Recovery

• Creating a Backup and Restore Strategy
• Creating a Database Disaster Recovery Plan
• Lab 6: Designing a Data Recovery Solution
• Devising a Recovery Strategy
• Sharing Lessons Learned from Disaster Recovery

Lesson 7: Establishing Database Conventions and Standards

• Establishing Database Naming Conventions
• Defining Database Standards
• Lab 7: Establishing Database Conventions and Standards
• Proposing Improved Object Naming Conventions
• Proposing Improved Coding Standards

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com