Designing a Microsoft SQL Server 2005 Infrastructure (2786)

OBJETIVOS
This 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.
After completing 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

PARTICIPANTES
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

EQUIPOS Y DURACIÓN
Se dispone de un ordenador por alumno. El curso tiene una duración de 10 horas (consultar los horarios disponibles en el calendario de New Horizons). El nº de plazas es limitado.

 

[Temario]

Analyzing Capacity Needs
Estimating Storage Requirements
Estimating CPU Requirements
Estimating Memory Requirements
Estimating Network Requirements

Designing a Strategy for Data Archiving
Identifying Requirements that Affect Data Archiving
Determining the Structure of Archival Data
Creating a Data Archival Plan

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

Designing a Strategy for Data Distribution
Overview of Data Distribution
Creating a Data Distribution Plan Using Replication

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

Designing a Strategy for Data Recovery
Creating a Backup and Restore Strategy
Creating a Database Disaster Recovery Plan

Establishing Database Conventions and Standards
Establishing Database Naming Conventions
Defining Database Standards