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 «««123

How many tests do I need for 2012 after I get my MCITP Expand / Collapse
Author
Message
Posted Friday, July 25, 2014 4:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:53 AM
Points: 2,462, Visits: 1,065
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


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1596153
Posted Friday, July 25, 2014 1:49 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
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 2008, MVP
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

Post #1596393
Posted Friday, July 25, 2014 2:20 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:23 PM
Points: 4,049, Visits: 9,214
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.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1596402
Posted Sunday, July 27, 2014 1:25 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:53 AM
Points: 2,462, Visits: 1,065
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


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1596645
Posted Sunday, July 27, 2014 2:11 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
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 2008, MVP
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

Post #1596649
Posted Monday, July 28, 2014 2:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:53 AM
Points: 2,462, Visits: 1,065
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)

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1596725
Posted Monday, July 28, 2014 3:28 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
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)


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



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1596737
Posted Monday, July 28, 2014 3:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:53 AM
Points: 2,462, Visits: 1,065
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


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1596741
Posted Monday, July 28, 2014 11:47 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
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 2008, MVP
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

Post #1596994
Posted Monday, July 28, 2014 12:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:40 PM
Points: 7, Visits: 55
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.
Post #1597010
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse