Description

Welcome to this course: Microsoft SQL Server 2016 Certification (70-761) - Querying Data with Transact-SQL. This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries. In this course, you'll learn: Manage data with Transact-SQLCreate Transact-SQL SELECT queriesQuery multiple tables by using joinsImplement functions and aggregate dataModify dataQuery data with advanced Transact-SQL componentsQuery data by using subqueries and APPLYQuery data by using table expressionsGroup and pivot data by using queriesQuery temporal data and non-relational dataProgram databases by using Transact-SQLCreate database programmability objects by using Transact-SQLImplement error handling and transactionsImplement data types and NULLsAt the end of this course, you will have developed the knowledge and skills necessary to pass the Querying Data with Transact-SQL Exam. So let's get started.