New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents

2786 Designing Microsoft SQL Server 2005 Infrastructure and Services On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure

Course Description/Agenda

This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. Who Should Attend: 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. At Course Completion: 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.
Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database 2779 Implementing a Microsoft SQL Server 2005 Database 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Outline:
Lesson 1: Analyzing Capacity Needs
Estimating Storage Requirements Estimating CPU Requirements Estimating Memory Requirements Estimating Network Requirements
Lesson 2: Designing a Strategy for Data Archiving
Identifying Requirements that Affect Data Archiving Determining the Structure of Archival Data Creating a Data Archival Plan
Lesson 3: 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
Lesson 4: Designing a Strategy for Data Distribution
Overview of Data Distribution Creating a Data Distribution Plan Using Replication
Lesson 5: 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
Lesson 6: Designing a Strategy for Data Recovery
Creating a Backup and Restore Strategy Creating a Database Disaster Recovery Plan
Lesson 7: Establishing Database Conventions and Standards
Creating Database Naming Conventions Defining Database Infrastructure Standards