Otra Información:
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. 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. www.nhbarcelona.com

Descripción :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. www.nhbarcelona.com

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 www.nhbarcelona.com