Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club

Course Length: 2 days.   

Overview

This two-day instructor-led clinic 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 emphasises 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. At the end of the course, students should be able to analyse storage, CPU, memory and network capacity needs. They will also be able to design a strategy for data archiving, database server consolidation, data distribution and data recovery. They will also be able to design a database server infrastructure and establish database conventions and standards.

Audience

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

Outline

1. Analysing Capacity Needs
2. Designing a Strategy for Data Archiving
3. Designing a Strategy for Database Server Consolidation
4. Designing a Strategy for Data Distribution
5. Designing a Database Server Infrastructure
6. Designing a Strategy for Data Recovery
7. Establishing Database Conventions and Standards

Prerequisites

Before attending this workshop, students must understand the trade-offs among the different redundant storage types, understand how replication works and how it is implemented. They should be familiar with reading user requirements and business-need documents and have some knowledge of how queries execute. Students should also have basic knowledge of the dependencies between system components, be able to design a database to third normal form (3NF) and know the trade-offs when backing out of a f