Login to Course Campus | Call Us: 1-877-797-2799  

 

Microsoft Course Listings

Designing a Database Server Infrastructure with Microsoft SQL Server 2005

Overview
Skills Taught
Audience		 Prerequisites
Outline
Duration: 30 Hours
Skill Level: Intermediate
Certifications: MCSA 2003; MCSE 2003; MCTS: SQL Server 2005
Delivery Type: Expert Live; Expert Encore

 

Description
Designing a Database Server Infrastructure with Microsoft SQL Server 2005 is for professional database administrators who are interested in defining highly available and secure solutions for enterprise or midsize organizations. Topics covered in this course include designing replication strategies, recovery solutions, service and object level security, physical storage, and database mirroring. This course prepares database administrators for the following certification: Microsoft Certified IT Professional: Database Administrator.

Skills Taught
After completing this course, students will be able to:
  • Identify the infrastructure requirements for implementing SQL Server 2005 database server
  • Identify security requirements when designing a SQL Server Environment for
  • Identify considerations for designing a disaster recovery plan
  • Identify considerations when designing the physical structure of a database
  • Identify a strategy for implementing replication
  • Recognize how to install failover clustering for SQL Server 2005
  • Recognize how server role switching works in database mirroring
  • Recognize the considerations involved in designing a database mirroring strategy
  • Identify the considerations involved in designing a log shipping strategy

Audience
Candidates for this course include certified SQL Server 2000 database administrators who are on the upgrade path for the IT Professional: Database Administrator for SQL 2005 certification. This is the second of two exams necessary to earn the MCITP credential. The first exam is Technology Specialist: SQL Server 2005. Individuals not interested in earning certification but do have three years experience specifically with databases will also benefit from this class.

Prerequisites
To fully benefit from this course, students should have completed the course Implementing and Maintaining SQL Server 2005 or have three years of experience specializing in database administration.

Outline
Module 1 – Database Server Infrastructure Fundamentals
  • Lesson one: Identifying Infrastructure Requirements
  • Lesson Two: Designing Server Instances
  • Lesson Three: Designing Physical Storage
  • Lesson Four: Gathering Information for Database Consolidation
  • Lesson five: Designing a Database Consolidation Plan

Module 2 – Securing an SQL Server Environment

  • Lesson one: Identifying Business Requirements for Security
  • Lesson Two: Identifying Enterprise Authentication Requirements
  • Lesson Three: Designing Windows Password Policies
  • Lesson Four: Designing Windows Services and a Secure Network
  • Lesson five: Designing Service Level Security
  • Lesson SIX: Designing Service Level Security
  • Lesson SEVEN: Designing Object Level Security

Module 3 – Database Designing

  • Lesson one: Designing the Physical Database
  • Lesson Two: Normalizing and Documenting a Database
  • Lesson Three: Designing Filegroups for a Database
  • Lesson Four: Designing Tables for a Database
  • Lesson five: Designing Indexes and Views
  • Lesson SIX: Identifying Naming Conventions and Standards
  • Lesson SEVEN: Identifying Procedures for Change Control

Module 4 – Replication with SQL Server

  • Lesson one: Designing a RAID Solution for Availability
  • Lesson Two: Designing a SAN Solution for High Availability
  • Lesson Three: Identifying Different Replication Solutions
  • Lesson Four: Designing a Strategy for Replication

Module 5 – Cluster Configuration for SQL Server

  • Lesson one: Designing a Microsoft Cluster Service
  • Lesson Two: Designing a Cluster Configuration for SQL Server
  • Lesson Three: Identifying Server Roles for Database Mirroring
  • Lesson Four: Designing a Strategy for Database Mirroring
  • Lesson Five: Designing a Log Shipping Strategy

Module 6 – Backup and Data Recovery for a Database

  • Lesson one: Identifying Business Requirements for Data Recovery
  • Lesson Two: Designing a Database Backup Strategy
  • Lesson Three: Database Backup Considerations
  • Lesson Four: Designing a Disaster Recovery Plan
  • Lesson Five: Designing a Recovery Strategy for a Database