You are here

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

Primary tabs

Resell This Course

Request A Demo

About Our Platform

About Our Courses

When you pass this exam, you earn credit towards the following certifications: MCITP Database Administrator, SQL Server 2008.

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

Add New Discussion