< Return To Course List
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/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.
Target 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.
Expected Duration (hours)
30.0
Lesson ObjectivesIdentify 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
Course Number:
LLMS0029
Designing a Database Server Infrastructure with Microsoft SQL Server 2005 Expert Encore
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/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.
Target 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.
Certification
MCITP Professional: Database Administrator for SQL Server 2005
Exams
70-443
Skills
- Automating administrative tasks
- Monitoring and Troubleshooting database servers
- Defining infrastructure
Outline
Designing a Database Server Infrastructure with Microsoft SQL
Server 2005 Expert Encore
- 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
Expected Duration (hours)
30.0
Lesson Objectives
Designing a Database Server Infrastructure with Microsoft SQL Server 2005 Expert Encore
LLMS0029
Copyright© 2009 SkillSoft - All Rights Reserved