Microsoft Exam 70-450
 
 

Microsoft Exam 70-450:
Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Training Course


  
Certify I.T Training's Microsoft Exam 70-450 training course 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.

Certify I.T Training follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.

 


 
Deployment Methods
 
 

Microsoft Exam 70-450

 
 
Microsoft Exam 70-450, 1 Yr Access, & Technical Email Support, 1 Study guide, 40 hours Self Study, 1 Yr Technical Email Support, Training simulations.
 
 
COURSE PRICE: £245.00 + VAT
 

Microsoft Exam 70-450: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Training

Course Outline

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
MediFailure
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

 
 
About us | Contact us | Support | T&C | Privacy Policy | Site Map | Guarantee ©2010 - 2013 Certify IT Training