# # # #

Service Center

Microsoft MCITP SQL Server 2008 DBA Administrator and DBD

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.
If you can not attend a boot camp, we also offer Microsoft MCITP SQL Server 2008 Self Paced Online or CD-ROM Training for Certification