Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BI certification? Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 6:34 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:35 AM
Points: 158, Visits: 336
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 !!
Post #1341193
Posted Tuesday, August 7, 2012 8:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 2:02 PM
Points: 3,464, Visits: 1,802
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
Post #1341315
Posted Wednesday, August 8, 2012 6:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:35 AM
Points: 158, Visits: 336
Thank you a bunch !! :) :)

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
Post #1341822
Posted Wednesday, August 8, 2012 11:53 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 2:02 PM
Points: 3,464, Visits: 1,802
[left][/left]
SQL_path (8/8/2012)
Thank you a bunch !! :) :)

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
Post #1342083
Posted Friday, August 10, 2012 8:36 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:35 AM
Points: 158, Visits: 336
Thank you for your advice !! That helped a lot !!
Post #1343448
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse