Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Exam 70-761 study material for Querying Data with Transact-SQL


By:   |   Read Comments (7)   |   Related Tips: More > Professional Development Certifications

Attend these FREE MSSQLTips webcasts >> click to register


Problem

I want to pass my first Microsoft SQL Server 2016 certification exam, what exam should I take and how can I study for this?

Solution

The first exam for SQL Server 2016 is the Microsoft Exam 70-761. It is the first exam related to querying data with Transact-SQL, which is the query language used in SQL Server.

Which exam should I take before this one?

If you want to get a Microsoft certification, we recommend taking this exam first.

Is this exam difficult?

If you have experience using T-SQL, it should not be very difficult.

What is the score to pass?

700/1000

What other exams are available for the SQL Server 2016 certification?

The 70-762, 70-764, 70-765, 70-767 and 70-768 Exam.

Is this exam similar to the SQL Server exam 70-461: Querying Microsoft SQL Server 2012/2014?

It is similar. Some topics are modified, some are in a different order and some were removed. For example, The Troubleshoot and Optimize module was removed in the new SQL Server 2016 exam. One topic that may require extra effort is the JSON topic. This is a new SQL Server 2016 feature that is included in the exam. Another new feature is temporal tables. Please pay attention to these two topics.

Which books do you recommend for this exam?

Unfortunately, there is no Microsoft Training Kit book for this exam yet. However, these books will help you pass the exam:

Do you recommend videos for this exam?

Yes, these books may be useful:

Which courses do you recommend for the exam?

The official Microsoft course is this one:

Course 20761A: Querying Data with Transact-SQL

This course does not include all the topics, but if you prefer a teacher rather than reading books or watching videos, it is a good choice to start.

Other courses recommended are the following:

  • SolidQ is a solid in the Course Catalogue, there are several basic and advanced T-SQL courses.
  • Pluralsight is another company that offers several courses related to T-SQL.

Which links do you recommend to this pass?

Here you have some links that we recommend:

Manage data with Transact-SQL

Query data with advanced Transact-SQL components

Program databases by using Transact-SQL

Next Steps

For more information, refer to these links:



Last Update:


signup button

next tip button



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Monday, October 09, 2017 - 9:23:45 AM - Daniel Back To Top

There are some non-official exams in Google. 

 


Monday, October 09, 2017 - 8:44:13 AM - Philip Back To Top

Hi Daniel. I am intending to take the Microsoft 70-761 exam. Is there a practice test that I can use as preparation before I go ? 

 


Tuesday, July 04, 2017 - 5:54:48 AM - Renu Back To Top

Microsoft has introduced the book:

 

https://www.microsoftpressstore.com/store/exam-ref-70-761-querying-data-with-transact-sql-9781509304332tting.


Thursday, March 16, 2017 - 4:28:31 PM - Daniel Calbimonte Back To Top

 

 

Thanks, we updated the link


Sunday, March 12, 2017 - 12:44:26 PM - Kyle Back To Top

Thank you for laying all of this out. Just a quick observation: Your link for Deterministic and Nondeterministic Functions does not point to that, it directs you to joining three or more tables.

 


Wednesday, January 25, 2017 - 12:07:48 PM - Daniel Calbimonte Back To Top

 Yes, there is a text search in this web page. Write 70-462 and press the search button. You will find an article similar to this one.

 


Wednesday, January 25, 2017 - 11:40:31 AM - Lau Back To Top

 Thank you very much for the information. I was a little disoriented because I can not find a study kit for the exam. Do you have information , links or study books for the 70-762 exam?

 

 


Learn more about SQL Server tools