In recent years, Microsoft has revamped their certification tracks for several of their product. One amongst their newer certification tracks is the Microsoft Certified Solutions Associate (MCSA) that replaces the Microsoft Certified IT Professional (MCITP). The MCSA for SQL Server 2012 is that the base level certification for Microsoft relational database answer, and is followed by the Microsoft Certified Solutions professional (MCSE) and also the Microsoft Certified Solutions Master (MCSM). so as to realize the MCSA for SQL Server 2012, you want to pass 3 exams Querying Microsoft SQL Server 2012 (Exam 70-461), Administering Microsoft SQL Server 2012 Databases (Exam 70-462), and Implementing an information Warehouse with Microsoft SQL Server 2012 (Exam 70-463). Upon roaring completion of all 3 exams, the MCSA: SQL Server 2012 is awarded. In keeping with Microsoft, this certification proves that you simply have the required qualifications to land a grip as a info developer or info analyst.
To earn the MCSA: SQL Server 2012 certification you need to pass three exams:
Exam 70-461: Querying Microsoft SQL Server 2012:- Querying Microsoft SQL Server 2012 is meant for database professionals with a minimum of two years SQL Server experience. It tests mastery of writing SQL queries and includes coverage of queries, indexes, and hold on procedures, triggers, error handling and additional.
Exam 70-462: Administering Microsoft SQL Server 2012 Databases:- Administering Microsoft SQL Server 2012 Databases is meant for database administrators who work with the installation, maintenance and configuration of SQL Server databases. It tests mastery of info administration tasks, backup procedures, storage optimization, and info security
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012:- Implementing information Warehouses with Microsoft SQL Server 2012 is meant for info professionals who add Extract rework Load (ETL) and information storage environments. It includes coverage of Master information Services, information Quality Services, information synchronization, ETL, SQL Server Integration Services and Windows Azure SQL Databases.
Candidates who with success complete these 3 exams are awarded the MCSA on SQL Server 2012. Once youve earned your MCSA certification, you will want to pursue one amongst the advanced info certifications. You will additionally want to pursue certification during a completely different technology, like Oracle or Microsoft Access.
Upgrading certifications to SQL 2012
If you have got any MCTS on SQL Server 2008, you wish to pass 2 exams to earn your MCSA: SQL 2012:
Exam 70-457: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Exam 70-458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Before I move to my expertise with those exams, i would like you to grasp that if you have got AN MCITP on SQL 2008, you will need to contemplate one amongst the subsequent exams once passing to the 2 listed on top of to upgrade your MCITP to AN MCSE in SQL 2012.