New Horizons Computer Learning Center of Knoxville: Course Outline



SkillPort Login Learning Port Login Mentored Learning Manager Login

Learning Methods Classroom Learning eLearning Mentored Learning Clubs Career Training Small/Medium Business Government Enterprise Certifications Room Rentals

Title:	2786 Designing a Microsoft SQL Server 2005 Infrastructure - ML
Delivery Method:	Mentored Learning
Duration:	4 Sessions
Overview:	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.
Pre-requisite(s):	Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience 2780 Maintaining a Microsoft SQL Server 2005 Database 2779 Implementing a Microsoft SQL Server 2005 Database 2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
CPE Information:	CPE Credits: 0 hours Course Level: Basic Instructional Method: Group-live Additional CPE Information

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