Designing A Microsoft SQL Server 2005 Infrastructure

Tipo de curso:	Cursos de especialización	Metodología:	Presencial
Centro:	New Horizons Barcelona	Nº de horas:	12.00
Sedes:	No presencial

Precio:

¡ Gratuito !

Justificación/Descripción del curso:

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.

Requisitos de acceso al curso:

Nnguno

Temario cubierto por el curso:

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