Time for a certification bender

I’ve got nothing better to do, I am going to be spending the next few months working on completing some certifications.  I figure I’ve got about 60-70% of the knowledge I need via real world experience, and I’ll really only have to cover things like hardware requirements, Service Broker, endpoints, XML, etc.

I’ve mapped out a quick plan to achieve my goals of MCITPs for Database Administration and Business Intelligence in both SQL Server 2005 and 2008.

MCTS – SQL Server 2005 – Exam 70-431

The first step on my path, and my introduction to many of the technologies that I’m weak with.  This one will take me a few weeks of study and practice.

MCITP – Database Administrator – Exam 70-443 (database design)

This one should be pretty easy.  Designing DBs is what I do, and I don’t think I’ll have much of an issue here.

MCITP – Database Administrator – Exam 70-444 (optimizing and maintaining)

 Basic database administration here, simple stuff.

MCITP – Database Administrator 2008 – Exam 70-453

 The upgrade to 2008, I’ll likely spend more time on this one, since it will cover the new technologies in SQL 2008 that I haven’t had much exposure to in the real world.  I’ll be forced to learn things like geospatial and temporal data handling, filestreams, and other bleeding edge technology.  I expect this to be one of the more enjoyable studies, but it may take me 2 months to get a hold of the material.

MCTS – Business Intelligence  – Exam 70-445

 This one should be difficult, as I am quite well versed in reporting services, but have almost no experience with SSIS and Microsoft’s ETL.

MCITP – Business Intelligence – Exam 70-446

 More of the same here, lots of new technology to learn with respect to Data Warehousing and Data Mining.  I don’t even know how much MDX I’ll have to learn to pass this one.  

MCITP – Business Intelligence Developer – Exam 70-455

 Since I’ve been quite interested in the capabilities of SQL 2008’s data warehousing, this one should be a really fun study.

MCAS Excel 2007 – Exam 77-602

The cherry on top of my certification stack, this will give me the basic Excel chops to extend my BI work on the desktop.

Once these are complete, we’ll have a look at the MySQL CMA exam, and possibly the Database Developer MCITP track.  Someday, maybe even the $20,000 3 week Master Certification for SQL Server 2008.  Has anyone looked deeply into this certification?  I’d be very, very interested in talking with you!