MCITP: Database Administrator, SQL Server 2008 Boot Camp

In this 5 day, 60 hour Boot Camp class, qualified IT professionals are provided 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

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

Who Needs to Attend

Professional database administrators who optimize and maintain database solutions, typically in an enterprise or a medium-sized organization

Prerequisites

  • At least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle
  • MCITP: Database Administrator, SQL Server 2005 certification
  • Experience with: Defining high-availability solutions
    • Data distribution
    • Automating administrative tasks (for example, checking db stats, backups)
    • Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
    • Defining security solutions
    • Monitoring and troubleshooting the database server
    • Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
    • Designing and executing deployments
    • Deployments and migration
    • Defining the infrastructure (for example, storage, hardware, and number of servers or instances)

Certification Programs and Certificate Tracks

This course is part of the following programs or tracks:

Course Outline

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

1. 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

2. 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

3. 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

4. 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

5. Performing Data Management Tasks

  • Import and export data
  • Manage data partitions
  • Implement data compression
  • Maintain indexes
  • Manage collations

6. Monitoring and Troubleshooting SQL Server

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

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

8. 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

1. 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

2. 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

3. 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

4. Designing a Backup and Recovery Solution

  • Design a backup strategy
  • Design a recovery strategy
  • Design a recovery test plan

5. 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

6. 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

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

1. Installing and Configuring SQL Server 2008

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

2. Maintaining SQL Server Instances

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

3. Managing SQL Server Security

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

4. Maintaining a SQL Server Database

  • Back up databases
  • Restore databases
  • Manage and configure databases

5. Performing Data Management Tasks

  • Manage data partitions
  • Maintain indexes

6. Monitoring and Troubleshooting SQL Server

  • Identify SQL Server service problems
  • Identify concurrency problems

7. Optimizing SQL Server Performance

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

8. Implementing High Availability

  • Implement database mirroring
  • Implement a SQL Server clustered instance

9. Designing a SQL Server Instance and a Database Solution

  • Design for CPU, memory, and storage capacity requirements
  • Design physical database and object placement

10. Designing a Database Server Security Solution

  • Design database, schema, and object security parameters
  • Design a security policy and audit plan

11. Designing a Database Solution for High Availability

  • Select high-availability technologies based on business requirements
  • Design a failover clustering solution
  • Design database mirroring

12. Designing a Backup and Recovery Solution

  • Design a backup strategy
  • Design a recovery strategy
  • Design a recovery test plan

13. Designing a Monitoring Strategy

  • Design a monitoring solution at the instance level
  • Design a solution to monitor performance and concurrency

14. Designing a Strategy to Maintain and Manage Databases

  • Design a maintenance strategy for database servers
  • Design a management automation strategy

15. Designing a Strategy for Data Distribution

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

To Hire an AMS Microsoft SQl Server Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!

Leave a Reply