[0]

Microsoft SQL Server 2008 MCITP DBA

Overview CurriculumWhat's IncludedTestimonialsPricing

Getting MCITP certified shows you have arrived.
The knowledge that comes with it shows how you got there.

Click Here to Receive a Free Skills Assessment

During our 7-day Microsoft Certified IT Professional (MCITP): SQL Server 2008 Database Administrator Training Camp, students will live, learn, and take the exams at one of our state-of-the-art education centers. This blended-learning course employs outcome-based (Lecture | Lab | Review)™ delivery that focuses on preparing you with the real-world skills required to pass the exams and to hit the ground running in your career.

SQL Server 2008 MCITP Administration certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects. This level of knowledge is a must for technical architects and consultants who design and implement SQL Server solutions. This program covers both levels of SQL Server 2008 Administrator Certification: MCTS and MCITP.

With education from a Microsoft Gold Certified Partner, you gain hands-on experience, in-depth knowledge of Microsoft's most current products, and industry-recognized validation

HOW WE ARE BETTER

You will get certified.

We save you time. And money.

Our experts make learning easier.

We guarantee it.

Contact Us

A few reasons to get certified.

75% of managers believe that certification is important to team performance.

71% of employees believed Microsoft certification helped them receive a promotion or raise from their current employer.

66% of managers believe that certification improves the level of service and support offered to IT end users/customers.

55% of hiring managers consider employee certification as criterion for hiring.

65% of certified professionals surveyed had been in their jobs 24 months or longer.

(Sources: Fairfield Research survey, Zoomerang, “Prometric IT Candidate Study”, IDC whitepaper, “Value of Certification, Nov 2006”)

Is this course right for you?

This course is intended for students with a working knowledge of Transact-SQL and relational databases. Relevant job titles include:

Database Administrator
Database Technician
Database Specialist

Each training day is segmented into Lecture, Lab, and Review components that cater to a student's multiple learning styles (auditory, visual, and kinesthetic-tactual).

*Note that significant changes may be made to the schedule on a daily basis to ensure that the goals of the course are met.

Topics

Installing and Configuring SQL Server 2008
Configuration and Maintenance
Tables and Constraints
Designing Indexes
Full Text Indexing
Partitioning Data
Importing and Exporting Data
Policy Based Management
Backing up and Restoring a Database
Automating SQL Server
Designing SQL Server Security
Monitoring SQL Server
Optimization
Failover Clustering
Database Mirroring
Log Shipping
Replication
Designing a SQL Server Instance and a Database Solution
Designing a Database Server Security Solution
Designing a Database Solution for High Availability
Designing a Backup and Recovery Solution
Designing a Monitoring Strategy
Designing a Strategy to Maintain and Manage Databases
Designing a Strategy for Data Distribution

Exams:

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

Training Camp offers the highest quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on learning and certification objectives.

	Intensive Hands-on Training by Certified Trainers Utilizing Our (Lecture \| Lab \| Review)™ Delivery		Examination Vouchers & On-site Certification Testing
	Optional Package of Hotel Accommodations, Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee Available		Blended-learning Instruction Comprised of Comprehensive Study Materials, Lab Manuals, and Practice Exams
	Extended Lab and Instructor Access		Examination Passing Policy Guarantee More Details
			Should a student complete a Training Camp Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year. Students will only be responsible for accommodation and vendor exam fees.

Training Camp is proud to share in our students' success. Here is what they are saying about us:

An overwhelming experience, yet by the time we took the test, my head was full of knowledge I did not think I could have in a short period of time. Stress levels are high in the first couple days, but after that the confidence kicks in. A great road to success.

Roman Bulkiewicz, ExecuSpace, Inc.

The staff and the accommodations are great. They'll do whatever you need, or whatever you want while you're there. Being able to be "isolated" for two weeks to concentrate on nothing but the course is critical. I'm looking forward to sending our other system engineers to the Camp.

Patrick Fisher, Intrinsic

The instructor, Juan Castro, was on fire! He had a rapid-fire presentation style that kept us attentive and alert. He was very friendly, upbeat, and completely knowledgeable. And I passed all three tests: CCENT, CCNA, and CCDA!

Joe Wade, Lockheed Martin