Confused with SQL Server Certification track (2012/2016)

---

Hi :

I need to know which track that I need to follow to obtain the SQL Server Database Administration? plus here's a post that I added to this forum

querying SQL 2016

I have a very simliar question regarding where to start as a Database Administrator?

MTA-Database Fundamentals
MS Access Core Fundamentals 2016 ?
CompTIA Server+
MCSA-SQL Server 2016 ?
This is my plan in how to achieve, just not sure if this is realistic because of the time I have (deadline June 30th 2020) MCSA Certification expiring very soon

Dan Loyer

The MTA: Database Fundamentals certification is definitely the place to start. I would skip MS Access and CompTIA Server+ for now as they aren't deadline driven and aren't as useful to someone in the DBA role. The MCSA SQL Server 2016 only requires 2 exams and is certainly do-able in three months, but you are going to need to stay focused and dedicated. The replacement for the MCSA track is in beta right now and is set to launch on April 2nd. The new certification is called the Microsoft Certified: Azure Database Administrator Associate. Personally, I would hold off on the MCSA and pursue the new certification as it will provide more long-term value.

Hope that helps,

Don

@Don-Pezet said in Confused with SQL Server Certification track (2012/2016):

MCSA SQL Server 2016

Hi Don:

Thank you for the reply, Ok, this gives me some guidelines as what to do next, the MTA Database Fundamentals so you think that MS Access Core 2016? won't be helpful? MCSA SQL Server 2016 what are the 2 two exams code or Exam Number that I need to take? here's the information that I found on one of the VTC.com Free Videos regarding as to what to take regarding the MCSA SQL Server Database Administration

Do I need to take the following in order to pass these exams
Querying Data with T-SQL (70-761)
MCSA-SQL 2016 Database Administration
**Administration a SQL Database Infrastructure (70-764)
** Provisioning SQL Database (70-765)

What is meant by provisioning SQL Database, a simple definition for me to understand.

thanks

Dan L

Hi Don:

I am watching the Transact SQL Series, and wanted to know do I need to get the labs for this series in order to follow the lessons? plus do I need to download the T-SQL or SSMS ?? SQL Server managment Studio? in order to learn and practice the commands.

Dan L.