MICROSOFT CERTIFIED DATABASE ADMINISTRATOR TRAINING Course
Baltimore | Columbia | Maryland | Washington DC | Northern Virginia
If you're looking for fast, professional MCITP certification from an accredited Maryland learning institute headquartered in Columbia--near Baltimore and DC-- then this is what need.
Learn more by clicking on the tabs below.
MCITP Database Administrator: SQL 2008 Boot Camp Course Description
The Microsoft Database Administrator training and certification supports professionals in the IT field who currently have knowledge of core or foundation concepts and want to earn their MCITP certification in Database Administration. The purpose of this program is to increase:
- The number of participants in training that will result in an employer-recognized certifications
- The retention rate and number of completions of the training; and
- The number of professionals qualified for, achieving, and maintaining employment in demand occupations as it relates directly to the training program.
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.
MCITP Database Administrator: SQL 2008 Boot Camp Course Outline
Exam 70-432
Lesson 1: How to Install and Configure SQL Server 2008 R2
Lesson 2: How to Work with Databases
Lesson 3: How to Backup SQL Server 2008 R2 Databases
Lesson 4: How to Restore SQL Server 2008 R2 Databases
Lesson 5: How to Authenticate and Authorize Users
Lesson 6: How to Assign Server and Database Roles
Lesson 7: How to Authorize Users to Access Resources
Lesson 8: How to Automate SQL Server 2008 R2 Management
Lesson 9: How to Configure Security for SQL Server Agent
Lesson 10: How to Perform Ongoing Database Maintenance
Lesson 11: How to Monitor SQL Server 2008 R2
Lesson 12: How to Create Databases and Database Files
Lesson 13: How to Create Data Types and Tables
Lesson 14: How to Create and Tune Indexes
Lesson 15: How to Implement Data Integrity Using Constraints and Triggers
Lesson 16: How to Use XML
Lesson 17: How to Implement Views
Lesson 18: How to Implement Stored Procedures
Lesson 19: How to Implement Functions
Lesson 20: How to Manage Transactions and Locks
Exam 70-450
Lesson 21: How to Design a Conceptual Database Model
Lesson 22: How to Design a Logical Database Model
Lesson 23: How to Design a Physical Database Model
Lesson 24: How to Design Design a Strategy for Database Access
Lesson 25: How to Design Queries for Optimal Performance
MCITP Database Administrator: SQL 2008 Bootcamp Exams and Testing
Exam 70-432
Credit Toward Certification
- When you complete this exam, you satisfy the requirements for Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance
- Exam 70-432 also gives credit toward the MCSA and MCSE certifications
Skills Being Measured
Ability to Install and Configure SQL Server 2008 (10 percent)
Ability to Maintain SQL Server Instances (13 percent)
Ability to Manag SQL Server Security (15 percent)
Ability to Maintain a SQL Server Database (16 percent)
Ability to Perform Data Management Tasks (14 percent)
Ability to Monitor and Troubleshoot SQL Server (13 percent)
Ability to Optimize SQL Server Performance (10 percent)
Ability to Implement High Availability (9 percent)
Exam 70-450
Credit Toward Certification
Completing Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 gives credit toward the Microsoft Certified IT Professional: Database Administrator 2008 certification
Skills Being Measured
Ability to Design a SQL Server Instance and a Database Solution (14 percent)
Ability to Design a Database Server Security Solution (15 percent)
Ability to Design a Database Solution for High Availability (15 percent)
Ability to Design a Backup and Recovery Solution (20 percent)
Ability to Design a Monitoring Strategy (13 percent)
Ability to Design a Strategy to Maintain and Manage Databases (14 percent)
Ability to Design a Strategy for Data Distribution (9 percent)
Phoenix TS is an authorized testing center for both Pearson VUE & Prometric. You can register for your Microsoft Certification Exams at the Phoenix TS test centers in Washington DC, Baltimore, or Columbia, Maryland. Simply go to the Pearson VUE or Prometric website or call us directly (301-258-8200).
(MCITP: Database Administrator) Standard Price
|
Total Cost |
$ 3,425.00 |
Price Includes:
- Training instruction and class exercises
- Courseware books, pens, highlighters, notepads and other material
- Exam voucher
- Exam Retake option
- Course Retake option
- Sample Exam Questions from leading industry vendors
- Full breakfast including a combination of doughnuts, bagels, fruits, yogurt, juices
- Coffee/tea/soda available all day
- Afternoon fresh baked cookies (participating locations)
(MCITP: Database Administrator) Group Price
Please call 301-258-8200 to discuss pricing.
View all MCITP Database Administrator: SQL 2008 Boot Camp classes
How Can MCITP Boot Camp Help Your Career?
After completing this course and gaining MCITP database certification, you'll join a select elite of professionals who have used these same skills to advance their careers. Some of what you’ll gain by choosing MCITP Boot Camp includes:
- Advanced understanding of MCITP administration and database development principles,
- Refined technical skills to stay current in today's fast-paced work environment, and
- A disciplined approach to acquiring additional knowledge.
Get Started Today
If you’re ready to hone your skills with professional training and start earning what you know you deserve, it’s time to get serious. Take this opportunity to learn with us and fulfill your potential with the MCITP Database Boot Camp course
Phoenix TS is a training solutions provider at work around the globe. Join us for classes at our headquarters in Columbia, MD--near Baltimore and Washington DC--or contact us to discuss hosting a class near your location.
If you have questions or you want to speak to a Phoenix TS representative, you can call us at (301) 258-8200 or click here to fill out our contact form for more information about us.
Begin learning CWTS by clicking the “register” button to start your training today.
View upcoming MCITP Database Boot Camp | Get ahead of the competition Classes
View all IT and Computer Training Courses in MD/DC/VA
Go back to the PhoenixTS.com HOMEPAGE