Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Server 2008 Certification Resources

By: Tibor Nagy | Read Comments (3) | Print Tibor is a Technical Analyst and administers large scale SQL Server databases and is also familiar with MySQL and DB2. Related Tips: More

Problem

There are three Microsoft certifications available for SQL Server 2008. In this tip we look at available resources for each of the different certifications: Database Administrator, Database Developer and Business Intelligence Developer.

Solution

There are three tracks for Microsoft SQL Server 2008 certifications. As a result you should take different exams to become a certified Microsoft SQL Server DBA, Developer or BI expert. Additionally there are specific exams which allow you to upgrade your certifications from SQL Server 2005 to SQL Server 2008.

Below is an outline of resources for each track.

---

SQL Server 2008 - MCITP: Database Administrator

Certification Requirements

• MCTS: SQL Server 2008, Implementation and Maintenance
• MCITP: Database Administrator 2008

Certification Exams

• Upgrade from SQL Server 2005
  • Exam 70-453: UPGRADE: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008
• Microsoft Technology Specialist
  • Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
• MCITP DBA
  • Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

Training Classes

• Microsoft Technology Specialist
  • 6231A: Maintaining a Microsoft SQL Server 2008 Database (5 days)
  • 6232B: Implementing a Microsoft SQL Server 2008 Database (5 days)
• MCITP
• 50400A: Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 (5 days)

Certification Books

• MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance
• SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450)
• The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance
• Measure Up Practice Tests - TS
• Measure Up Practice Tests - ITP
• Measure Up Practice Tests - Upgrade

Testing Centers

• Prometric Testing Centers

Additional Resources

• 6369AE: Implementing and Maintaining Microsoft SQL Server 2008 (16 Hours)

---

SQL Server 2008 - MCITP: Database Developer

Certification Requirements

• MCTS: SQL Server 2008, Database Development
• MCITP: Database Developer 2008

Certification Exams

• Upgrade from SQL Server 2005
  • Exam 70-454: UPGRADE: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD
• Microsoft Technology Specialist
  • Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
• MCITP Developer
  • Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Training Classes

• Microsoft Technology Specialist
  • 6231A: Maintaining a Microsoft SQL Server 2008 Database (5 days)
  • 6232B: Implementing a Microsoft SQL Server 2008 Database (5 days)
• MCITP
  • 50401A: Designing and Optimizing Database Solutions with Microsoft SQL Server 2008 (5 days)

Certification Books

• MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development
• The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit: Database Design
• Measure Up Practice Tests - TS

Testing Centers

• Prometric Testing Centers

Additional Resources

• 6370AE: Microsoft SQL Server 2008 R2 Database Development (20 Hours)
• 10344AE: MCTS (Exam 70-433): TS: Microsoft SQL Server 2008, Database Development (18 Hours)

---

SQL Server 2008 - MCITP: Business Intelligence Developer

Certification Requirements

• MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
• MCITP: Business Intelligence Developer 2008

Certification Exams

• Upgrade from SQL Server 2005
  • Exam 70-455: Upgrade: Transition Your MCITP SQL Server 2005 Business Intelligence Developer to MCITP SQL Server 2008 Business Intelligence Developer
• Microsoft Technology Specialist
  • Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• MCITP BI Developer
  • Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Training Classes

• Microsoft Technology Specialist
  • 6234A: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services (3 days)
  • 6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (3 days)
  • 6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 days)
• MCITP
  • 50399A: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008 (5 days)

Certification Books

• MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance
• Measure Up Practice Tests - TS

Testing Centers

• Prometric Testing Centers

Additional Resources

• 6233AE: Implementing and Maintaining Business Intelligence in Microsoft SQL Server 2008: Integration Services, Reporting Services and Analysis Services (24 Hours)

---

Please note that the SQL Server 2005 exams have been retired on June 30, 2011.

Next Steps

• Setup your certification goals.
• Setup target dates for preparation.
• Get your employer to pay your exams and your training if needed.
• Check out some practice test to become familiar with the test format.
• Read these related tips:
  • The Value of the MCDBA and MCITP DBA Certification
  • Do You Want to be a Microsoft Certified SQL Server DBA Expert
  • Do You Want to be a Certified SQL Server Database Development Expert

Related Tips: More | Become a paid author

Last Update: 11/21/2011

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

Comments and Feedback:

Monday, November 21, 2011 - 9:55:44 AM - JR
Good outline...Is it really worth the time to get certified?  You don't really mention anything about that. JR

Monday, November 21, 2011 - 2:33:11 PM - Tibor
Hello, There is already a tip about the advantages and disadvantages of getting certified so I included only a link at the bottom.: The Value of the MCDBA and MCITP DBA Certification Regards, Tibor

Friday, February 10, 2012 - 11:40:30 AM - Oded Dror
Tibor, There is no books for 70-452 why? and next month SQL Server 2012 is coming anyway Thanks, Oded Dror

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis! The SQL Developer Bundle - 10 essential tools every database developer needs. Download a free trial. SQL Server Issues? Not sure where to turn for answers? Innovative SQL DBA consultants Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Learn SQL Server 2008, Performance Tuning, Development, Administration, Replication and more - free webcasts