asked
SQL Server Certification for the beginner
Hello, I am new in Sql Server. I have installed Sql Server 2012 on my machine and have been practicing from 1 year own my own watching YouTube videos. Now I want to take one Sql Server exam. Which one can I take for the starter like me?
Take a look at [this page][1] and filter on technology='SQL Server' At the basic level you can take the Microsoft Technology Associate (MTA) certification, although this does not qualify you as an MCP (Microsoft Certified Professional) - it is aimed at giving you fundamental level knowledge - take a look at what is covered and examined - it may be that you are already above this if you have 1 years experience. Next up is the Microsoft Certified Solutions Associate (MCSA) - there are currently 7 different flavours of this and you need to pass 2 or 3 exams, depending on which you choose. Once you have the MCSA you can then consider going further to Microsoft Certified Solutions Expert (MCSE). Also you may want to look downloading, installing and using SQL Server 2017 - the Developer edition is free to download from
https://www.microsoft.com/en-gb/sql-server/sql-server-downloads Good luck! [1]:
https://www.microsoft.com/en-gb/learning/browse-all-certifications.aspx
Depends on which aspect you find easier! Both are needed for the MCSA and both cover various aspects of development 70-761 is Querying Data with Transact-SQL - so this more about using T-SQL to query and manipulate data. 70-762 is Developing SQL Databases and covers more design related aspects.
I would say it is possible to pass these exams without real work experience as long as you cover all the material in the study guides, and use your practice server to gain first hand experience. Microsoft Virtual Academy (
https://mva.microsoft.com/ ) used to have a good selection of videos to watch, although the site does seem a little bare on SQL content at the moment - hopefully they are just refreshing it. Check the special offers section on Microsoft Learning - they run offers all the time and currently you can get Exam Replays - these give you a second shot at the exam. So even if you fail the first one, you'll have a good idea of the kind of material you need to improve on.
17 People are following this question.
