☀ MS BI # 87– MCSA : Microsoft Certified Solutions Associate # 2 – Certification Overview , Benefits and Available Certification Paths

Hi friendsimage

As promised, In this article we are going to cover all our basic understanding of all New / Current Microsoft Certification.

After completing my research on Microsoft certification, I have also completed my this year first certificate (Actually comprise of three certificate) in SQL Server 2012 , this was really nice experience and really lot of work while climbing from one certificate to another.

Will discuss my certification later, As currently everyone are really excited and want more information on Microsoft Certification Initiatives in 2012 ..

I have couple of my blog already posted regarding certification  id any of you missed it click on following link :

Note : On this article Please click on any Images and Links for more details , which will Redirect you directly to Microsoft website

In this article we are going to cover

  • Major available certificate
  • Certification Overview
  • Example with SQL Server certification
  • Certification benefits
  • Frequently asked questions
  • Resource Links

    Major Available Certificate

    Microsoft has decided to do away with it for future technologies as we move closer to cloud computing. Microsoft introduces new ”Cloud-Built Certifications” The new certification path is based on a 3 tier design with levels being Associate, Expert and Master. The current MCITP certifications are based on a “flat” scheme as such which fails to correctly indicate actual skill level of the candidate.

Following are three major certificate

  • Microsoft Certified Solutions Associate (MCSA)
  • Microsoft Certified Solutions Expert (MCSE)
  • Microsoft Certified Solutions Developer (MCSD)


In addition to these, there are also one new Master certification known as MCSM certifications which will respectively replace MCM certification tracks.

  • Microsoft Certified Solutions Master (MCSM)


    All Certificate are fall under any of the above category

    Certification Overview

We can have certification on following category


Microsoft Certified Solutions Associate (MCSA)


Microsoft Certified Solutions Expert (MCSE)


Microsoft Certified Solutions Developer (MCSD)


Microsoft Certified Solutions Master (MCSM)


Example with SQL Server certification

If you are willing to do certificate in SQL Server 2012

First comes the MCSA series of exams. You need to pass all three to earn the MCSA SQL Server certification.

  • 70-461: Querying Microsoft SQL Server 2012
  • 70-462: Administering Microsoft SQL Server 2012 Databases
  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Next, determine your path from here. Are you more interested in Business Intelligence (BI) or Database Administration (DBA) , Select based on your interest.

  • MCSE: Data Platform (DBA Track)
  • 70-464: Developing Microsoft SQL Server 2012 Databases
  • 70-465: Designing Database Solutions for Microsoft SQL Server 2012
  • MCSE: Business Intelligence (BI Track)
    • 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
    • 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
  • Most of content copied and collaborated from this link

    Certification benefits

    The number of job postings in the cloud computing industry is growing so rapidly that there aren’t enough qualified workers available to fill the positions. Get certified and be part of the solution.

    Get hired
    • Eighty-six percent of hiring managers indicate IT certifications are a high or medium priority during the candidate evaluation process. (CompTIA, Employer Perceptions of IT Training and Certification, January 2011)
    • Eight in ten HR execs verify certifications among job candidates. (CompTIA, Employer Perceptions of IT Training and Certification, January 2011)
    • Ninety-one percent of hiring managers consider certification as part of their hiring criteria. (Microsoft, Microsoft Certification Program Satisfaction Study, April 2012)
    • Find out more about how earning a Microsoft Certification can help you get a job.
    Get recognized
    • Sixty-four percent of IT hiring managers rate certifications as having extremely high or high value in validating the skills and expertise of job candidates. (CompTIA, Employer Perceptions of IT Training and Certification, January 2011)
    • Certification, training, and experience are three of the top four most important characteristics when selecting a candidate for a cloud-related position. (IDC/Microsoft, Climate Change: Cloud’s Impact on IT Organizations and Staffing, November 2012)
    • See success stories demonstrating how Microsoft Certifications help people in their careers.
    Get ahead
    • In a survey of 700 IT networking professionals, 60 percent said certification led to a new job. (Network World and SolarWinds, IT Networking Study, October 2011).
    • Training and certification will play essential roles in preparing IT professionals for the evolving IT org. (IDC/Microsoft, Climate Change: Cloud’s Impact on IT Organizations and Staffing, November 2012)

    Frequently asked questions

    For more specific questions addressing the certification exam policies, please visit the Exam policies and FAQ page.

    Show allHide all

    Q.What is the recertification requirement?
    A.In order to ensure that our certifications are meaningful and valuable indicators of candidates’ skills, Microsoft has implemented a recertification requirement for the MCSE, MCSD, and MCSM certifications. MCSE and MCSM candidates will be required to recertify every three years, while MCSD candidates will recertify every two years. Initially, recertification requires passing one or two exams or earning the associated Masters certification. Microsoft is exploring other recertification options and will announce those options as appropriate.

    MCSA certifications do not require recertification.

    Q.How long is a Microsoft Certification valid?
    A. Microsoft Certifications are valuable in the market and will remain valuable as long as companies are using the technologies covered in the certification. Over time, certifications will retire and will transition to a “legacy” status. Legacy Microsoft Certifications will appear on your transcript designated as such. Refer to the certification page for the most current information regarding status.
    Q.Are there upgrade paths available for Microsoft Certifications?
    A. Depending on the certification you have achieved, most certifications have an upgrade path available. Please check the appropriate certification page and view the section on how to upgrade for more information.
    Q.How do I find out about new certification releases?
    A. Please refer to the newly released certification exams on the Certifications exams page.
    Q.Which certification should I start with?
    A. For those new to technology, Microsoft Technology Associate (MTA) is the recommended starting point for our certifications. MTA certifications provide a solid foundation for those preparing for the Microsoft Certified Solutions Associate (MCSA) and MCSD certifications. Those who have been working with the technology should start with the MCSA or MCSD certification. These are prerequisites for any further certifications. The MCSA certification validates that job seekers have a minimum set of skills to hit the ground running.
    Q.What do I gain from passing a Microsoft Certification exam?
    A. When you pass your first Microsoft Certification exam, you become a member of the Microsoft Certified Professional (MCP) community with access to all of the benefits provided through the Microsoft Certification Program and the MCP member site. You can share your transcript with others to prove that you passed that exam and show your progress towards a specific certification. In some cases, such as when you pass an MTA or Specialist exam, that single exam will also earn you the associated certification.
    Q.Why don’t all of the certification titles include version numbers?
    A. Certifications that require recertification are not “versioned” because they may cover multiple technologies.
    Q.How will earning the expert-level certification better prepare me to pursue a master-level certification?
    A. Expert-level certifications better prepare you to pursue a master-level certification by validating the full range of skills and abilities required to be successful at building technology solutions. Expert-level certifications also validate deeper technology skills than in the past, which helps bridge the gap to the difficulty level of master certifications.
    Q.Will I be able to earn a Microsoft Certified Technology Specialist (MCTS) certification for passing exams that count towards the MCSA: Windows Server 2008 certification?
    A. You will continue to earn an MCTS for passing Exams 70-640 and 70-642 until July 31, 2013. Also until July 31, 2013, when you earn an MCSA: Windows Server 2008 certification, you will receive the MCITP: Server Administrator certification. After July 31, 2013, the MCITP: Server Administrator and MCITP: Enterprise Administrator certifications will be retired.
    Q.Will getting certified help with my matriculation?

    Resource Links

    Hope this helps !!

    Those who have not ye subscribe my Blog yet they can subscribe it !So that I can post you @ real time and all sort of knowledge in your mail without Zero spamming !!

    Happy Learning and Sharing !!

    If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

    Link Resource Website

    For More information related to BI World visit my Mentalist Blog

    SQL Server Mentalist >> SQL Learning Blog

    Business Intelligence Mentalist >> BI World

    Connect With me on

    | Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |

    3 thoughts on “☀ MS BI # 87– MCSA : Microsoft Certified Solutions Associate # 2 – Certification Overview , Benefits and Available Certification Paths

    1. Hey Brooks.. I intend that statement because such boot camp does not happen in frequently, Also not happened in india .. So i suggested rather than waiting for Boot camp just go grab your certificate whenever you want !..Thanks brook for stop by and comment.. Or else boot Camp is one of the great certification platform ..

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s