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


How many tests do I need for 2012 after I get my MCITP


How many tests do I need for 2012 after I get my MCITP

Author
Message
quackhandle1975
quackhandle1975
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2756 Visits: 1227
Duncan Pryde (7/19/2013)
Hi Elizabeth

I know this post is a month old so you may have started taking the tests already, but I've just completed the last of the three upgrade exams, so thought I'd chip in.

As you've said, the three exams you need are 70-457, 70-458 and 70-459. Of the three, I found 70-458 by far the most challenging as it required some quite in-depth studying of SSIS which I had relatively little experience with. The other two were ok, and didn't require much as much study.

You can get most of the information from the Microsoft Learning website, but essentially the exams cover:
70-457 - Admin, Querying
70-458 - Admin, SSIS/Master Data Services/Data Quality Services/Data Warehousing
70-459 - Admin, Development

I used the three Microsoft MCSA books for studying, and went through all the examples for the "Implementing a Data Warehouse" book. For the other two books I read through most of the Querying book (mostly because I found it quite an enjoyable read!) and skim-read the Admin book, focussing on the bits that were new to SQL 2012 - e.g. AlwaysOn. According to the Microsoft Learning website, most of the 70-459 exam content seemed to be covered by the Querying and Admin books, so I just used those plus Books Online for any bits that weren't covered. In any case, if you read the Skills Measured you'll see that exam is more about the application of knowledge than the knowledge itself, so that's where on-the-job experience and general reading around the subject will help enormously.

I must say, I've enjoyed the whole process of studying for these exams, and learned quite a few new things along the way - which is why I force myself to go through this process every few years (roll on SQL 2014!). I thought the study books were all well-written and the exams were very fair in the sorts of questions they asked.

So good luck, and I hope you do well. Any help I can give you without breaking NDAs, I'm happy to give, so ask if you've got any more questions.

Duncan


Thanks for posting this Duncan, good to know. (I have 457 & 458 to complete before end of 2014, under a prometric offer)

Edit: I would have thought 459 would have been the most challenging exam being the "Expert" one.



qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47365 Visits: 44392
quackhandle1975 (7/25/2014)
Edit: I would have thought 459 would have been the most challenging exam being the "Expert" one.


None of them are 'expert' level. Not even close.


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


Luis Cazares
Luis Cazares
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8566 Visits: 18143
GilaMonster (7/25/2014)
quackhandle1975 (7/25/2014)
Edit: I would have thought 459 would have been the most challenging exam being the "Expert" one.


None of them are 'expert' level. Not even close.

Redefine 'expert' level as those exams are to obtain the MS Solutions Expert certification. Of course, I wouldn't trust someone is an expert just because they are certified as a MCSE. :-)


Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
quackhandle1975
quackhandle1975
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2756 Visits: 1227
Luis Cazares (7/25/2014)
GilaMonster (7/25/2014)
quackhandle1975 (7/25/2014)
Edit: I would have thought 459 would have been the most challenging exam being the "Expert" one.


None of them are 'expert' level. Not even close.

Redefine 'expert' level as those exams are to obtain the MS Solutions Expert certification. Of course, I wouldn't trust someone is an expert just because they are certified as a MCSE. :-)


Hence where I got the "Expert" from (MCSE).

Gail I would be interested to hear your thoughts on why they are not even close to expert level.

qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47365 Visits: 44392
quackhandle1975 (7/27/2014)Gail I would be interested to hear your thoughts on why they are not even close to expert level.


No, you don't want to. ;-)

Tell me, if someone claims to be an 'expert', what exactly do you expect from that person?


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


quackhandle1975
quackhandle1975
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2756 Visits: 1227
GilaMonster (7/27/2014)
quackhandle1975 (7/27/2014)Gail I would be interested to hear your thoughts on why they are not even close to expert level.


No, you don't want to. ;-)

Tell me, if someone claims to be an 'expert', what exactly do you expect from that person?


Fair point. I used to have those sort of discussions with an AI lecturer at university "What defines an expert?"

In answer to your question, possibly an expert has a set level of knowledge? Someone to get the job/task done? A person with more knowledge than yourself? (I am just surmizing here.)

Sounds like a decent topic for an SSC Editorial Gail (if not touched upon in the past) :-D

qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47365 Visits: 44392
quackhandle1975 (7/28/2014)In answer to your question, possibly an expert has a set level of knowledge? Someone to get the job/task done?


If that's your definition of expert (just enough to get the job done), then the exams are 'expert' level (assuming the job is just day-to-day DBA/dev work).

Sounds like a decent topic for an SSC Editorial Gail (if not touched upon in the past) :-D


Hmmm... and I have one due next week.


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


quackhandle1975
quackhandle1975
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2756 Visits: 1227
GilaMonster (7/28/2014)

If that's your definition of expert (just enough to get the job done), then the exams are 'expert' level (assuming the job is just day-to-day DBA/dev work).


Not necessarily my definition I was just putting some possible answers out there. As in, "lets get an expert in to solve this problem/task/etc"."

The OED lists an "expert" as:

A person who is very knowledgeable about or skilful in a particular area (noun)
+
Having or involving a great deal of knowledge or skill in a particular area. (Adjective).


qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47365 Visits: 44392
quackhandle1975 (7/28/2014)
The OED lists an "expert" as:

A person who is very knowledgeable about or skilful in a particular area (noun)
+
Having or involving a great deal of knowledge or skill in a particular area. (Adjective).


With that definition, the MCSE exams certainly are not expert level.


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


Elizabeth Block
Elizabeth Block
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 57
I think the beginning phase of becoming an expert is knowing what you don't know. When you're at the junior level you don't even know what you don't know. Reaching intermediate status can mean that you know some stuff, like what you need to pass the exams, but are starting to "grok" the large amount of knowledge you haven't reached yet. When I've talked to real SQL experts, I've been amazed at how humble many of them are. They know they know more than me but they're not too impressed with themselves to answer my questions. Personally, I'm more impressed with those kind of experts than the few that want to beat you up with how much they know. I've met so many wonderful people at PASS and SQL Saturdays and have learned a lot from those events. I am really amazed at how many true experts are willing to give of their time and money to share what they know.
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