This course contain Practice test for Microsoft Certification exam 70-761 for SQL server 2016

Question database contains 310 questions - It's the biggest database for this exam on udemy (Cover 100% microsoft syllabus). At the end of this course, you will have developed the knowledge and skills necessary to pass the Querying Data with Transact-SQL Exam.

In this course, you'll learn:

• Manage data with Transact-SQL

• Create Transact-SQL SELECT queries

• Query multiple tables by using joins

• Implement functions and aggregate data

• Modify data

• Query data with advanced Transact-SQL components

• Query data by using subqueries and APPLY

• Query data by using table expressions

• Group and pivot data by using queries

• Query temporal data and non-relational data

• Program databases by using Transact-SQL

• Create database programmability objects by using Transact-SQL

• Implement error handling and transactions

• Implement data types and NULLs