Advice on which route to take....

SQLnoobieSQLnoobie Registered Users Posts: 2 ■□□□□□□□□□
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,



  • adam9870adam9870 Member Posts: 53 ■■□□□□□□□□

    Do you want to work with administration or programming of SQL Server?
  • SQLnoobieSQLnoobie Registered Users Posts: 2 ■□□□□□□□□□
    Ideally a bit of both, but if I had to choose then Programming.
  • adam9870adam9870 Member Posts: 53 ■■□□□□□□□□
    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).
  • LappyLappy Member Posts: 29 ■□□□□□□□□□
    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
Sign In or Register to comment.