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