Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


BI certification?


BI certification?

Author
Message
SQL_path
SQL_path
SSC-Enthusiastic
SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)

Group: General Forum Members
Points: 160 Visits: 342
Hi,

I need help on deciding the track for certification in BI. I did search MS website , however it left me a little confused. Looking for latest information on :

1.The Path/track and time involved in preparing and taking the test. How effective are MS training materials?
2. What is the cost if one takes it independently?

thank you !!
Kenneth.Fisher
Kenneth.Fisher
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3592 Visits: 2021
SQL_path (8/7/2012)
Hi,

I need help on deciding the track for certification in BI. I did search MS website , however it left me a little confused. Looking for latest information on :

1.The Path/track and time involved in preparing and taking the test. How effective are MS training materials?
2. What is the cost if one takes it independently?

thank you !!


First of all I'm assuming you are looking at the 2008 track since you didn't specify otherwise :-). The 2012 track is completely different and I've only looked at it briefly. I've done the 2008 Administrative track and I'm working on the Development one (no BI) but hopefully my experience will be close enough.

First the MCTS. I'm fairly cheep so I don't do any of the classes I just went out and bought the MS Press book on the test, read that, and then bought another book on the subject and read that. That was enough, just barely. You need to look at the "Skills Tested" link for the exam and make sure you are at least familiar with each subject. Even then you will get some screwball questions. I ended up with one about trace flags. I'd never studied trace flags, they weren't in either book. I had to guess.

Second the MCITP. There are no books specific to this test. At least no books that get anything like a good review. There are classes but again I'm far to cheep. I reread the books I had and got a couple more. I watched selected MCM readiness videos. You can search for them on line. They are really excellent free training videos. They are at a higher level, but to my mind that is all to the good. Then I went through the "Skills Tested" list and made sure I had hit every subject at least once. This went much better than the MCTS test had.

Right now I'm reading the sections of the books I have on development, making sure I hit the skills on the "Skills Tested" list that I'm not strong at, and watching the MCM Videos that seem appropriate. I'm hoping to test in the next month or so.

Both tests were $150 each + 4-5 books at about $50 each for a total cost of ~$500. One thing you should note though is that the 2008 exams will no longer be given after the middle of next year. June or July I'm not sure off the top of my head which.

Hope that helps. If you need help with the 2012 BI track I can probably take a look and walk through it here but I don't have any experience with 2012 yet.

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com
SQL_path
SQL_path
SSC-Enthusiastic
SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)

Group: General Forum Members
Points: 160 Visits: 342
Thank you a bunch !! Smile Smile

I see exams 70-448, 70-452, 70-467 , 70-460.

I work on 2008 what would be better ?
these are the videos you talked about ?

http://www.microsoft.com/feeds/TechNet/en-us/How-to-videos/SQL_Server_2008_Microsoft_Certified_Master_(MCM)_Readiness_Videos.xml
Kenneth.Fisher
Kenneth.Fisher
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3592 Visits: 2021
[left][/left]
SQL_path (8/8/2012)
Thank you a bunch !! Smile Smile

I see exams 70-448, 70-452, 70-467 , 70-460.

I work on 2008 what would be better ?
these are the videos you talked about ?

http://www.microsoft.com/feeds/TechNet/en-us/How-to-videos/SQL_Server_2008_Microsoft_Certified_Master_(MCM)_Readiness_Videos.xml


70-460: This is if you already have your MCITP in 2008 BI to transition over to 2012 (one of several)

70-467: This is part of the 2012 BI Certification

70-452: MCITP BI 2008
http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-452&Locale=en-us

70-448: MCTS BI 2008
http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-448&Locale=en-us

I would personally start with 2008 as it will help with 2012 and you already have the experience. You just need to remember that these exams are only offered through July 31 2013.

Yes that is the link for the videos. Here is another one http://www.sqlskills.com/T_MCMVideos.asp.

SQL Skills also has additional reading links/suggestions for each video listed here
http://www.sqlskills.com/MCM.asp

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com
SQL_path
SQL_path
SSC-Enthusiastic
SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)

Group: General Forum Members
Points: 160 Visits: 342
Thank you for your advice !! That helped a lot !!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search