Facing The Challenge: Designing a BI Infrastructure With SQL 2008 (70-452)

21 February, 2012 (10:00) | Books, Professional Development, SQL | By: Mark V

On Monday, Feb 6th, I passed exam 70-452, Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008. Hazzah. I am really excited about that, not because I get a shiny new MCITP certification, but because it validates how much I have learned. When I started working with SQL Server about 5 years ago, I started down the DBA track, even earning an MCITP in the SQL Server 2005 DBA track. It was not too long after that when I determined that Business Intelligence was where I really wanted to hang my career hat.

This post isn’t really about that, though. I have a process that I use to learn the material. I then use the exams to measure that learning. The process I have has worked pretty well. Actually, I am 6 for 6 when I commit to this process. Since it seems to work really well for me, I thought I would share it in case it may help someone else as well.

Typically, I like to use the Microsoft Press Self-Paced exam guides. I find them to be a great starting point and cover the key areas of the technology in question. In the case of exam 70-452, as of the time of this writing, there is not a Microsoft Press exam guide for that exam. Therefore, I instead chose Delivering Business Intelligence with Microsoft SQL Server 2008 by Brian Larson. I found it to be a great base for my prep for 70-452. In areas where I felt I needed to go deeper, I turned to Books Online.

My process consists of a few key steps.

1. I go through the text taking notes on the details of each topic. I make sure to make my notes in my own words and avoid taking anything word for word from the text. This helps a lot in that I must process the information more than once as I go.

2. The books I have used have all featured do-it-yourself style exercises during which you put what you learned into practice. I find this really valuable to gain at least some experience, particularly with skills I have never used in real life.

3. I read through the notes several times over, just like studying for test back in school.

It does not seem like much and certainly is not very elaborate. There are no tesla coils involved or anything. But sometimes it is the simple things people overlook.

Since I titled this post “Facing The Challenge,” I figured I should also show some of the faces I used during the process outline above.

 Confusion. Some of the content was confusing at first.










 Determination. I knew I had to commit myself to understanding all the concepts.










 Realization. Ah. NOW I get it.










 Blue Steel.










 Satisfaction. I passed. I dun learned something.










Well, there you have it.


Comment from Dan English
Time February 21, 2012 at 10:23 am

Congrats and way to go! Big props to Brian I see. Don’t forget to leverage the Microsoft Partner resources, tons of free material to prep for exams.

Comment from Shannon Waldrop
Time February 21, 2012 at 4:51 pm

Congratulations, Mark! An informative and entertaining post. Thanks for sharing your strategy.

Comment from Mark V
Time February 21, 2012 at 9:04 pm

Thanks much, Dan. I must admit I have neglected the Microsoft Partner resources. I wil fix that, though. I had the pleasure of telling Brian about it tonight at PASSMN.

Comment from Mark V
Time February 21, 2012 at 9:06 pm

Thanks Shannon. I hope you can put it to good use. The “Blue Steel” look is REALLY important. :)

Comment from Alana
Time February 22, 2012 at 8:54 pm

Huge congrats, Marky Mark. Madeline would be proud.

Comment from Mark V
Time February 22, 2012 at 9:52 pm

Thanks, Alana. :)

Write a comment