The Microsoft SQL Server 2008 DBA certifications offer you more choices and simpler paths to achieve your certification goals. These certifications differentiate technology skills and job-role skills, and validate actual IT roles.

Master the new features and capabilities of Microsoft SQL Server 2008 by earning a Microsoft Certified IT Professional (MCITP) certification.  This certification help you gain hands-on experience, in-depth expertise, and industry-recognized validation, which inspire customer and employer confidence in your skills.

Training Course  Description DBA VS DBD
You may attend the first 7 days and acheive your SQL Server DBA Certification, or stay for the full 14 days and earn both DBA and DBD Credentials. Please note Days 1-7  covers the DBA Administrator Certification and the days 8-14 cover the DBD Developer CertificationDuring the DBA Administration  class you will learn how to work with SQL Server 2008 and performing database administrator tasks: installing, configuring, and maintaining. During the DBD Developer Class you be  writing application code against systems that run SQL Server 2008, writing T-SQL or Microsoft .NET CLR code that runs inside SQL Server 2008, or developing solutions in SQL Server 2008.

Our MCITP: DBA Boot Camp course is a lab-intensive, residential course, designed for information technology professionals that require effective, real-world skill-building and timely certification.  You will live, learn, and test on-site

Training dates and location nationally

Training Class Outline
 Day 1

• Installing and Configuring SQL Server 2008 , Configuration and Maintenance, Tables and Constraints,  SQL Server Indexes

Day 2

• Partitioning Data, Importing and Exporting Data, Designing Policy Based Management, Backing up and Restoring a Database     

Day 3

• Automating SQL Server, Designing SQL Server Security, Monitoring SQL Server  

Day 4

• Optimization, Failover Clustering, Database Mirroring, Log Shipping, Replication 

Day 5

• EXAM: Microsoft SQL Server 2008 - Installation and Maintenance  70-432 
  
  Day 6

• Implementing Tables and Views, Implementing Programming Objects, Working with Query Fundamentals, Additional SQL Server Components, Working with XML Data, Dynamic Management Views, Catalog Views 

Day 7

• EXAM: Microsoft SQL Server 2008 - Database Development  70-433

Starts the DBD Developer Course
Day 8

• Designing a SQL Server Instance and a Database Solution, Designing a Database Server Security Solution

Day 9

• Designing a Database Solution for High Availability, Designing a Backup and Recovery Solution, Designing a Monitoring Strategy

Day 10

• Designing a Strategy to Maintain and Manage Databases, Designing a Strategy for Data Distribution

Day 11

• 11 EXAM: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008   "70-450

Day 12

• Designing a Database Strategy, Designing Database Tables, Designing Programming Objects, Designing a Transaction and Concurrency Strategy 

Day 13

• Designing an XML Strategy, Designing Queries for Performance, Designing a Database for Optimal Performance

Day 14

• EXAM: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008   70-451

Boot Camp Class Includes

• Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
• Blended-Learning Instruction comprised of comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software.
• Deluxe Package of Seven (7) or Fourteen (14) Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee.
• 24-Hour Lab and Instructor Access.
• Examination Vouchers & On-site Certification Testing.
• Examination Passing Policy.