|
Microsoft Exam 70-450 training course PRO- Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 teaches database administrators to make appropriate design and technology choice considerations for your SQL Server 2008 installations. Students will learn how to design a SQL Server Instance and Database Solution, how to design security solutions on SQL Server 2008, designing for high availability, designing a monitoring strategy, designing a maintenance strategy and how to design a strategy for data distribution
When you pass this exam, you earn credit towards the following certifications: MCITP Database Administrator, SQL Server 2008.
This Microsoft Certified Course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.
Course Introduction
Instructor Introduction
Course Overview
Module 1: Configuring SQL Server
Module Overview
Hardware Configuration
Windows Configuration
Instance Configuration
Database Configuration
Maintaining SQL Server
Upgrading
Module Review
Module 2: Designing Secure SQL Server Solutions
Module Overview
Authentication
Authorization
Encryption
Policies
SQL Server Auditing
Module Review
Module 3: Designing Highly Available SQL Server Solutions
Module Overview
Failover Clustering
Database Mirroring
Log Shipping
Combining Solutions
Module Review
Module 4: Designing Disaster Recovery Solutions
Module Overview
Backup Strategies
Recovery Strategies
Piecemeal Backup and Restore
Recovering Pages
Media Failure
Database Snapshots
Module Review
Module 5: Designing Data Distribution
Module Overview
SQL Server Integration Services
Replication
Module Review
Module 6: Monitoring SQL Server
Module Overview
Windows Resources
SQL Resources
Resource Governor
Module Review
Course Review
Exam Tips
|
