SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Microsoft Certified Master


Microsoft Certified Master

Author
Message
Jayanth_Kurup
Jayanth_Kurup
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5959 Visits: 1351
Brad Mcghee cover certification and its role in a DBA's career in this ebook how to become an exceptional DBA. You should probably go thru it to give you n idea about what certification means for you. You can download it from the left hand menu on this website under Books.

Jayanth Kurup
GilaMonster
GilaMonster
SSC Guru
SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)

Group: General Forum Members
Points: 237533 Visits: 46378
talkeffect (7/29/2011)
How is Knowledge Exam? Is it like 70-451 and 70-450 or a little bit harder?


Try several hundred times harder. It's also significantly more expensive. iirc $500 for the knowledge and $2000 for the lab

Because, I would like to plan this exam(Knowledge+Lab), in a week.


I assume you've watched all the videos here (http://www.sqlskills.com/T_MCMVideos.asp) and read all of the material here (http://www.sqlskills.com/MCM.asp) and understand all of it perfectly. If not, you really shouldn't be wasting your money trying. The pass rate among the SQL MVPs in the early part of the year was somewhere around 40%.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70831 Visits: 9671
GilaMonster (7/29/2011)
talkeffect (7/29/2011)
How is Knowledge Exam? Is it like 70-451 and 70-450 or a little bit harder?


Try several hundred times harder. It's also significantly more expensive. iirc $500 for the knowledge and $2000 for the lab

Because, I would like to plan this exam(Knowledge+Lab), in a week.


I assume you've watched all the videos here (http://www.sqlskills.com/T_MCMVideos.asp) and read all of the material here (http://www.sqlskills.com/MCM.asp) and understand all of it perfectly. If not, you really shouldn't be wasting your money trying. The pass rate among the SQL MVPs in the early part of the year was somewhere around 40%.


How many hours of study are you going to put in to even attempt it?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)

Group: General Forum Members
Points: 237533 Visits: 46378
Ninja's_RGR'us (7/29/2011)
GilaMonster (7/29/2011)
talkeffect (7/29/2011)
How is Knowledge Exam? Is it like 70-451 and 70-450 or a little bit harder?


Try several hundred times harder. It's also significantly more expensive. iirc $500 for the knowledge and $2000 for the lab

Because, I would like to plan this exam(Knowledge+Lab), in a week.


I assume you've watched all the videos here (http://www.sqlskills.com/T_MCMVideos.asp) and read all of the material here (http://www.sqlskills.com/MCM.asp) and understand all of it perfectly. If not, you really shouldn't be wasting your money trying. The pass rate among the SQL MVPs in the early part of the year was somewhere around 40%.


How many hours of study are you going to put in to even attempt it?


Once I get my Master's thesis (M.Sc) submitted, probably 2-3 months. That's solid studying, 5 evenings a week plus weekend.

I'm fairly strong on the core database engine, storage engine, query processing, etc. What I'll need to focus on mainly is stuff like clustering, mirroring, service broker, CLR, XML, the stuff that's not so core, that I haven't had much experience on.

Oh, and to put things in perspective, I wrote 70-432, 70-433, 70-450, 70-451 cold, no studying at all, and I got over 850 for all of them.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70831 Visits: 9671
So ballpark it at 2000 hours if you include all certs w00t.


Ok only 1999.99 hours to go on my end w00t
Robert Davis
Robert Davis
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6984 Visits: 1632
Just to answer a couple of questions that remain:

I don't believe that the system enforces that you take the knowledge exam first. However, it is the cheaper of the two exams and much easier, so it would certainly make sense to do so. You can only achive the MCM certification after meeting all pre-requisites and passing both exams, so there is no benefit to taking the harder and more expensive exam first. This does mean that if you do not have both MCITP exams and you pass both MCM exams, you won't get the MCM certification until you also get both MCITP certifications.

There is no time limit placed on you in regards to when you take the second exam. It will be up to you to schedule the seond exam when you are ready. That could be days, weeks, or even months.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Database Engineer at BlueMountain Capital Management
mike.mcquillan
mike.mcquillan
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1765 Visits: 458
I'm with Gail 100%, full-on study is the only way through this.

According to Microsoft's site, 60% pass the lab first time, with 80% passing the second time.

The MCM page specifically states the Knowledge exam must be passed before the lab. You don't find out if you have passed for up to 30 days, and you then have to wait 14 days after receiving your score before you can schedule the lab. So forget taking both of them in a week. If you fail an exam you have to wait 90 days before re-attempting it.

I am planning to study hard, upgrade my MCITP 2008 qualifications to 2011, and then take the MCM on 2011. However, anybody who holds MCM 2008 only needs to take the Knowledge exam to upgrade to MCM 2011.

At present I'm a decent all rounder but have minimal clustering experience (even though I know how it works in theory). But I am miles off MCM status. Hopefully I'll take it next year.

Mike.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)

Group: General Forum Members
Points: 237533 Visits: 46378
mike.mcquillan (7/29/2011)
According to Microsoft's site, 60% pass the lab first time, with 80% passing the second time.


I suspect that was from back when the MCM was a 3 week training + exam program.

However, anybody who holds MCM 2008 only needs to take the Knowledge exam to upgrade to MCM 2011.


I've been told by several reliable sources that to upgrade you now have to rewrite both. (one of the sources was someone who works on the exams)

At present I'm a decent all rounder but have minimal clustering experience (even though I know how it works in theory). But I am miles off MCM status. Hopefully I'll take it next year.


The one for Denali is unlikely to be out next year, assuming Denali releases late this year/early next year.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


mike.mcquillan
mike.mcquillan
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1765 Visits: 458
If you have to write both exams then there is effectively no upgrade path, although you are of course already armed with most of the knowledge required to pass the 2011 exams.

Interesting that they have changed this.

Based on the costs involved in taking these exams, I'm willing to wait for the Denali versions, even if that should be late on next year.

Mike.
Robert Davis
Robert Davis
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6984 Visits: 1632
I'm verifying the accuracy of the upgrade information on the website.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Database Engineer at BlueMountain Capital Management
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