MCITP Database Administrator, SQL Server 2008 Boot Camp
OneSource Professional Training Solutions, Inc.

Delivery Method

Seminar

Target Audience

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

Summary
MCITP Database Administrator, SQL Server 2008 Boot Camp

Description/Agenda

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 from Global Knowledge 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.

Send Score Report to:
Fax: 919-468-4801
E-mail: GKVoucherRequests.NAM@globalknowledge.com

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 Should Attend

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

Course 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)

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

All Date/Location Information