Course Ref: 42150

Course: MS2786 Designing a Microsoft SQL Server 2005 Infrastructure

Course Summary

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 trade-offs that need to be made during design.

This is the first course in the database administration curriculum and will serve as the entry point for other courses in the curriculum.

Course Outline

Modules include:

  • Analyzing Capacity Needs
  • Designing a Strategy for Data Archiving
  • Designing a Strategy for Database Server Consolidation
  • Designing a Strategy for Data Distribution
  • Designing a Database Server Infrastructure
  • Designing a Strategy for Data Recovery
  • Establishing Database Conventions and Standards

By the end of the course, delegates should 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.

Where & When

LocationWakefield
Start Date15 Jan 09
Price (ex. VAT)£445.00
Venue Info Wakefield - Wakefield 41 Business Park
ResidentialNo
AvailabilitySpaces
Duration2 days
Delivered AsVenue and on-site
Pre-course Reading
No precourse reading is specified.
Exam IncludedNo
Course Ref42150