[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:

Great learning experience. I did not think that I was capable of absorbing all of the material needed for the MCSE/MCSA certification in 14 days. Thanks to the instructor and staff at The Training Camp I was able to learn and understand the course material and achieve my professional goal of certification in Windows 2000.

Steve Eichhorn, United States Marshals Service

The seven-day boot camp experience was an extremely challenging but rewarding experience. I would strongly recommend it to any experienced developer looking for a "fast lane" to readiness in the .NET Framework. Buckle up tight and hold on!

David O. McCrea, Highpoint Solutions

The training received by Samir was awesome. You can go to the class with little experience such as myself and still get the necessary information that you need to be successful.

Tony Stephens, MMC