October 6, 2012 at 9:43 am
Hi ALL,
I am currently working with SQL server 2005 database and would like to pursue certifications. From microsoft site, i can see the current version is SQl 2012. Could you guide me with the map of SQL server certifications.
My intention is complete SQL server development certifications and then move on to DBA cert's.
Thanks in advance
October 6, 2012 at 9:49 am
This should have everything you need
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
There's no developer/DBA distinction for the 2012 exams. There's just the data platform certification which includes dev and DBA (and a bit of BI) aspects
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
October 6, 2012 at 9:55 am
Can i start the 2012 cert's with out completing 2008 etc? If so, any good sources for material?
October 6, 2012 at 10:17 am
Absolutely. See the link I posted.
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
October 7, 2012 at 12:23 pm
Where in all of this (SQL Server 2008 vs. 2012 vs. Azure; BIDS vs. SSDT; etc.) do SSIS, SSAS and SSRS fit? I am currently register for classes in each of those with the belief that they are an important part of certification for SQL Server and BI.
October 7, 2012 at 12:31 pm
They're part of the BI certs. See the link I posted.
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
October 7, 2012 at 12:42 pm
I reviewed the link, where is it stated that SSIS, SSRS and SSAS are part of SQL 2012?
Also, regarding certification, is the installed base of SQL Server 2008 such that a newbie should just do that or would 2012 certification be 'all inclusive'?
October 7, 2012 at 12:55 pm
dflbob (10/7/2012)
I reviewed the link, where is it stated that SSIS, SSRS and SSAS are part of SQL 2012?
Click on MCSA and MCSE:Business Intelligence and check each of the exams involved, the skills measured tab gives the details.
Or, is you want specifics
70-433 covers SSIS, MDS and DQS.
70-466 covers SSAS and SSRS
70-467 covers all of them, from a design perspective
Also, regarding certification, is the installed base of SQL Server 2008 such that a newbie should just do that or would 2012 certification be 'all inclusive'?
The 2012 cert is for 2012, not both versions. If you know 2008 and have experience with that, write the 2008 cert. If you know 2012 and have experience with that, write the 2012 cert. Or write the 2008 and then do the upgrade. There's no 'right' path
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
October 7, 2012 at 1:08 pm
First of all, I really appreciate your help. Thanks.
More questions, if I may: On this page, http://www.microsoft.com/learning/en/us/certification/cert-sql-server-MCSA.aspx, in the notes below the blue boxes there are two more tests referenced: 432 and 448 in the MCSA 2008 track, not MCTS - which is required in the 2nd row of blue boxes along with 457 and 458 to get an MCSA for 2012; But if I have an MCSA for 2008, how do I get to an MCSA for 2012? In other words, the page shows how to get to MCSA 2012 from MCTS 2008, but not how to get from MCSA 2008 to MCSA 2012. Which should I get - MCTS or MCSA? or, does it matter?
This is somewhat confusing even at the lowest level certification. Similar anomalies seem to occur in the MCSE path, but that can wait until another day!
Basically, what I'd like to figure out is this: will taking classes in SSIS, SSAS and SSRS be helpful for both SQL Server 2008 and 2012? (i.e. are they a good longer term investment of time and money?)
October 7, 2012 at 2:06 pm
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-all.aspx#tab2
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2008 certification validates a set of core SQL Server 2008 skills that are relevant across multiple job roles.
The MCSA: SQL Server 2008 certification does not fulfill the requirements for an MCSE on SQL Server. However, you can upgrade from the MCSA: SQL Server 2008 certification to the MCSA: SQL Server 2012 by passing Exam 70-457 and Exam 70-458.
and
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-MCSA.aspx
MCSA: SQL Server 2008
Demonstrate your essential skills on SQL Server 2008 by earning the MCSA: SQL Server 2008 certification.
Exam 70-432 Microsoft SQL Server 2008, Implementation and Maintenance
plus
Exam 70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
equal
MCSA: SQL Server 2008
It's not as plain as it could be, because the certs for SQL 2008 were originally the MCTS and MCITP. The MCSA was added as a combo of exams very recently. If you want the 2008 certs, I'd recommend rather the MCTS and MCITP certs.
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
October 7, 2012 at 2:18 pm
see next post
October 7, 2012 at 2:31 pm
ok, I think I've got it. Go for MCSA (Associate) as it covers both the previous MCTS and MCITP. Then, go on to MCSE (Expert) then MCSM (Master), if choose to go that far (per their vidio http://www.microsoft.com/learning/en/us/certification/cert-overview.aspx.
In the SQL Server track, this can be in either 2008 or 2012 or both. The exams depend upon which version I pursue 432, 448 for 2008; 461, etc. for 2012.
Does this accurately summarize things?
A key question for me, so if you'd advise on this point... SSIS, SSAS and SSRS are valid for both SQL Server 2008 & 2012?
My gut reaction is to go for 2008 as that is the current installed base and then upgrade to 2012 as 2008 ages out and 2012 becomes more prevalent.
October 7, 2012 at 2:33 pm
dflbob (10/7/2012)
ok, I think I've got it. Go for MCSA (Associate) as it covers both the previous MCTS and MCITP.
No it doesn't. The 2009 one's a combination of two of the MCTS exams (the database admin and BI ones), that's all.
A key question for me, so if you'd advise on this point... SSIS, SSAS and SSRS are valid for both SQL Server 2008 & 2012?
They haven't been discontinued, they're still part of the product and if you work in BI you'll very use 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
October 8, 2012 at 5:58 am
The problem with asking someone to "guide" you to the best Certification Exams to take is that it is actually not easy to do without a fair bit of knowledge about your background and experience.
The best that can be done in most cases is provide you with the information available and then you will have to determine what the best course of action is given your own personal circumstances.
October 8, 2012 at 8:31 am
I appreciate your input but I'm not really asking to be guided; just what's the better path as I thought it's pretty clear I'm in the SQL/BI world which is why I am asking about the future relevance of SSIS, SSAS and SSRS in the context of SQL 2008 vs. SQL 2012.
I now understand (hopefully correctly) that SSIS, SSAS and SSRS are still core to SQL Server/BI. So, my plan would be to get the cert in 2008 then upgrade to 2012 in time. Also, I believe I saw on the Microsoft site that recertification (renewal) for MCSE is required every two years; if that's correct, then ongoing training is part of the program.
If I'm incorrect on SSIS, SSAS and SSRS, please let me know as I'd like to not spend the time and money if they are not part of the future for SQL Server.
Thanks.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply