none
what is the difference between 98-364 and 70-761, i want to take an exam and im confused

    Question

  • Hello All 

    i just started learning sql server, and i want to get certified , and i checked internet , but i got confused

    there is exam 98-364 , 70-461, 70-761, and i want to get MCSA in SQL

    could some one explain to me what should i do ... 

    regarads

    Thursday, February 09, 2017 6:37 AM

Answers

  • MCSA or Microsoft Certified Solutions Associate in SQL Server can be earned on following areas with respective exams:

    – Database Development (761, 762)
    – Database Administration (764, 765)
    – Business Intelligence (767, 768)

    Exam 98-364 is to get Microsoft Technology Associate (MTA) certification. It is the most basic exam that focuses just on basic SQL, and is for people new to technology, who need to validate their knowledge of fundamental concepts before moving on to more advanced certifications. This exam covers:

    1. RDBMS, DBMS concepts and terms, like Normanization, PK, FK, etc.
    2. Plain SQL querying knowledge, like DDL, DML, etc. and indexes.
    3. Simple DBA stuff, like security, backup/restore, etc.

    Link: https://www.microsoft.com/en-in/learning/exam-98-364.aspx

    Exam 70-761 is also an advanced exam which is based upon SQL Server 2016, which is the latest version of SQL Server as of today. To earn MCSA you have to take 70-762 exam as well mentione . Check this link for MCSA SQL Server 2016: https://www.microsoft.com/en-in/learning/mcsa-sql-2016-certification.aspx

    Exam 70-461 is also an advance level exam but now older based upon SQL Server 2012 or 2014. Check this link for MCSA SQL Server 2012/2014: https://www.microsoft.com/en-in/learning/mcsa-sql-certification.aspx

    Prepare for Exam 70-461 (2014)

    Please note: Exam 98-364 is not required here, and as mentioned above its just to make sure you have knowledge in working with basic SQL Querying.


    ~manoj | SQLwithManoj.com



    Thursday, February 09, 2017 9:07 AM
  • Hi Siyamand,

    Below is the link for Microsoft Certifications for SQL Server. There is MCSA in SQL Server 2014/12 and Also MCSA in SQL Server 2016. 

    Exams details for both courses are provided here. 

    https://www.microsoft.com/en-in/learning/sql-certification.aspx

    Let me know if any questions..

    Thanks,


    Kindly mark the reply as answer if they help

    Thursday, February 09, 2017 8:29 AM

All replies

  • Hi Siyamand,

    Below is the link for Microsoft Certifications for SQL Server. There is MCSA in SQL Server 2014/12 and Also MCSA in SQL Server 2016. 

    Exams details for both courses are provided here. 

    https://www.microsoft.com/en-in/learning/sql-certification.aspx

    Let me know if any questions..

    Thanks,


    Kindly mark the reply as answer if they help

    Thursday, February 09, 2017 8:29 AM
  • MCSA or Microsoft Certified Solutions Associate in SQL Server can be earned on following areas with respective exams:

    – Database Development (761, 762)
    – Database Administration (764, 765)
    – Business Intelligence (767, 768)

    Exam 98-364 is to get Microsoft Technology Associate (MTA) certification. It is the most basic exam that focuses just on basic SQL, and is for people new to technology, who need to validate their knowledge of fundamental concepts before moving on to more advanced certifications. This exam covers:

    1. RDBMS, DBMS concepts and terms, like Normanization, PK, FK, etc.
    2. Plain SQL querying knowledge, like DDL, DML, etc. and indexes.
    3. Simple DBA stuff, like security, backup/restore, etc.

    Link: https://www.microsoft.com/en-in/learning/exam-98-364.aspx

    Exam 70-761 is also an advanced exam which is based upon SQL Server 2016, which is the latest version of SQL Server as of today. To earn MCSA you have to take 70-762 exam as well mentione . Check this link for MCSA SQL Server 2016: https://www.microsoft.com/en-in/learning/mcsa-sql-2016-certification.aspx

    Exam 70-461 is also an advance level exam but now older based upon SQL Server 2012 or 2014. Check this link for MCSA SQL Server 2012/2014: https://www.microsoft.com/en-in/learning/mcsa-sql-certification.aspx

    Prepare for Exam 70-461 (2014)

    Please note: Exam 98-364 is not required here, and as mentioned above its just to make sure you have knowledge in working with basic SQL Querying.


    ~manoj | SQLwithManoj.com



    Thursday, February 09, 2017 9:07 AM
  • thank you for the reply 

    so now which one should i take , as my understanding the MTA Is the button of the pyramid , and MCSA Is the second level of the pyrmaid

    Microsoft Technology Associate (MTA) MTA               and                  MCSA: SQL Server  MCSA

    So i have to take the MTA exam first then go to MCSA EXAM

    or if i take MCSA , This is means that im MTA certified which out taking the exam?

    But there is three types of MCSA, Which one should i go ?

    THIS 761 AND 762                                 7643 AND 765                                                   767 AND 768

    MCSA: SQL 2016 Database Development                            MCSA: SQL 2016 Database Administration                 MCSA: SQL 2016 Business Intelligence Development


    • Edited by Siyamand Thursday, February 09, 2017 2:24 PM
    Thursday, February 09, 2017 2:18 PM