LOGO For Immediate Assistance Call 855-211-9361

Open Enrollment

MCITP: Database Administrator, SQL Server 2008 Boot Camp

Price: $3,495.00

Call for availability 855-211-9361

This Boot Camp provides qualified IT professionals the opportunity to obtain the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Implementation and Maintenance certification and the Microsoft Certified IT Professional (MCITP): Database Administrator 2008 certification.

In this intensive test-preparation program where the goal is certification, you will practice sample questions and take simulated exams using Transcender, the industry-leading test-preparation product. This Boot Camp includes two exam vouchers, along with one free retake voucher for each exam if needed. A fast-paced, rapid review session prior to each exam covers key material, providing comprehensive exam preparation. You Will Prepare for These Exams:

New certification candidates will take two exams:

  • Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
  • Exam 70-450: PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution using Microsoft SQL Server 2008
Experienced professionals who have already earned the MCITP: Database Administrator, SQL Server 2005 certification, will take one upgrade exam:
  • Exam 70-453: Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008

Our Guarantee

Students who take the MCITP: Database Administrator, SQL Server 2008 Boot Camp will be issued a free retake exam voucher, if needed. Should any student fail the initial exam, he or she will be eligible to receive a second exam voucher.* To Receive Your Second Exam Voucher:

Send us a copy of the results of your first test, and we'll e-mail you a new exam voucher.

*Note: The second exam voucher will only be issued within one year of the first exam voucher issue date.

Course Overview

What You'll Learn

  • Key topics and concepts covered on the MCITP exams
  • Structure of the MCITP exams and the most effective test-taking strategies
  • Use Transcender test-preparation software to reinforce learning objectives, validate current knowledge, and review the most comprehensive and realistic exam questions
  • Pinpoint your weak areas and strengthen them to ensure success on the MCITP exams

Course Outline

    Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance

  • Installing and Configuring SQL Server 2008

    • Install SQL Server 2008 and related services
    • Configure SQL Server instances
    • Configure SQL Server services
    • Configure additional SQL Server components
    • Implement database mail
    • Configure full-text indexing
  • Maintaining SQL Server Instances

    • Manage SQL Server Agent jobs
    • Manage SQL Server Agent alerts
    • Manage SQL Server Agent operators
    • Implement the declarative management framework (DMF)
    • Back up a SQL Server environment
  • Managing SQL Server Security

    • Manage logins and server roles
    • Manage users and database roles
    • Manage SQL Server instance permissions
    • Manage database permissions
    • Manage schema permissions and object permissions
    • Audit SQL Server instances
    • Manage transparent data encryption
    • Configure surface area
  • Maintaining a SQL Server Database

    • Back up databases
    • Restore databases
    • Manage and configure databases
    • Manage database snapshots
    • Maintain database integrity
    • Maintain a database by using maintenance plans
  • Performing Data Management Tasks

    • Import and export data
    • Manage data partitions
    • Implement data compression
    • Maintain indexes
    • Manage collations
  • Monitoring and Troubleshooting SQL Server

    • Identify SQL Server service problems
    • Identify concurrency problems
    • Identify SQL Agent job execution problems
    • Locate error information
  • Optimizing SQL Server Performance

    • Implement Resource Governor
    • Use the Database Engine Tuning Advisor
    • Collect trace data by using SQL Server Profiler
    • Collect performance data by using Dynamic Management Views (DMVs)
    • Collect performance data by using System Monitor
    • Use Performance Studio
  • Implementing High Availability

    • Implement database mirroring
    • Implement a SQL Server clustered instance
    • Implement log shipping
    • Implement replication
  • Exam 70-450: PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution using Microsoft SQL Server 2008

  • Designing a SQL Server Instance and a Database Solution

    • Design for CPU, memory, and storage capacity requirements
    • Design SQL Server instances
    • Design physical database and object placement
    • Design a migration, consolidation, and upgrade strategy
  • Designing a Database Server Security Solution

    • Design instance authentication
    • Design instance-level security configurations
    • Design database, schema, and object security parameters
    • Design a security policy and an audit plan
    • Design an encryption strategy
  • Designing a Database Solution for High Availability

    • Design a failover clustering solution
    • Design database mirroring
    • Design a high-availability solution that is based on replication
    • Design a high-availability solution that is based on log shipping
    • Select high-availability technologies based on business requirements
  • Designing a Backup and Recovery Solution

    • Design a backup strategy
    • Design a recovery strategy
    • Design a recovery test plan
  • Designing a Monitoring Strategy

    • Design a monitoring solution at the operating-system level
    • Design a monitoring solution at the instance level
    • Design a solution to monitor performance and concurrency
  • Designing a Strategy to Maintain and Manage Databases

    • Design a maintenance strategy for database servers
    • Design a solution to govern resources
    • Design policies by using Policy-Based Management
    • Design a data compression strategy
    • Design a management automation strategy
  • Designing a Strategy for Data Distribution

    • Administer SQL Server Integration Services (SSIS) packages
    • Design a strategy to use linked servers
    • Design a replication strategy for data distribution
  • Exam 70-453: Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008

  • Installing and Configuring SQL Server 2008

    • Install SQL Server 2008 and related services
    • Configure SQL Server instances
    • Configure SQL Server services
  • Maintaining SQL Server Instances

    • Manage SQL Server Agent jobs
    • Implement the declarative management framework (DMF)
    • Backup a SQL Server environment
  • Managing SQL Server Security

    • Manage users and database roles
    • Manage SQL Server instance permissions
    • Manage schema permissions and object permissions
    • Audit SQL Server instances
  • Maintaining a SQL Server Database

    • Back up databases
    • Restore databases
    • Manage and configure databases
  • Performing Data Management Tasks

    • Manage data partitions
    • Maintain indexes
  • Monitoring and Troubleshooting SQL Server

    • Identify SQL Server service problems
    • Identify concurrency problems
  • Optimizing SQL Server Performance

    • Collect trace data by using SQL Server Profiler
    • Collect performance data by using Dynamic Management Views (DMVs)
    • Use Performance Studio
  • Implementing High Availability

    • Implement database mirroring
    • Implement a SQL Server clustered instance
  • Designing a SQL Server Instance and a Database Solution

    • Design for CPU, memory, and storage capacity requirements
    • Design physical database and object placement
  • Designing a Database Server Security Solution

    • Design database, schema, and object security parameters
    • Design a security policy and audit plan
  • Designing a Database Solution for High Availability

    • Select high-availability technologies based on business requirements
    • Design a failover clustering solution
    • Design database mirroring
  • Designing a Backup and Recovery Solution

    • Design a backup strategy
    • Design a recovery strategy
    • Design a recovery test plan
  • Designing a Monitoring Strategy

    • Design a monitoring solution at the instance level
    • Design a solution to monitor performance and concurrency
  • Designing a Strategy to Maintain and Manage Databases

    • Design a maintenance strategy for database servers
    • Design a management automation strategy
  • Designing a Strategy for Data Distribution

    • Administer SQL Server Integration Services (SSIS) packages
    • Design a replication strategy for data distribution