Advice on which route to take....

Good Afternoon, So I have been on the MS Website and looked over the MCSA's for SQL and I didn't realize there were so many, I'm struggling understand where to start as a SQL Novice?? Can you advise on best route to take please?

MCSA: SQL 2016 BI Development
MCSA: SQL 2016 Database Development
MCSA: SQL Server 2012/2014
MCSA: SQL 2016 Database Administration

Any advice or questions for me please let me know,

Thanks

Find more posts tagged with

Comments

adam9870

Hello,

Do you want to work with administration or programming of SQL Server?

SQLnoobie

Ideally a bit of both, but if I had to choose then Programming.

adam9870

Get interested in MCSA: SQL 2016 Database Development or: MCSA: SQL Server 2012/2014 (start with 70-461 about T-SQL or 70-462 about administration of SQL Server, next 70-463 about data warehousing).

Lappy

SQLnoobie
70-764 + 70-765 = MCSA SQL administration
70-761 + 70-762 = MCSA SQL Development, MCSE Data mgmt&analytics
70-765 is the easiest one, whereas the other three are pretty hard.
70-764 and 70-762 exams have common area called in 764 "Manage and monitor SQL Server instances" and in 762 "Optimize database objects and SQL infrastructure"; of course exam questions are not the same.
In my opinion it is a good idea to study both for SQL server administration and SQL db development