Prepare For Microsoft Exam 70-761and Help Demonstrate Your Real-world Mastery Of Sql Server 2016 Transact-sql Data Management, Queries, And Database Programming. Designed For Experienced It Professionals Ready To Advance Their Status, Exam Ref Focuses On The Critical-thinking And Decision-making Acumen Needed For Success At The Mcsa Level. Focus On The Expertise Measured By These Objectives: Filter, Sort, Join, Aggregate, And Modify Data Use Subqueries, Table Expressions, Grouping Sets, And Pivoting Query Temporal And Non-relational Data, And Output Xml Or Json Create Views, User-defined Functions, And Stored Procedures Implement Error Handling, Transactions, Data Types, And Nulls This Microsoft Exam Ref: Organizes Its Coverage By Exam Objectives Features Strategic, What-if Scenarios To Challenge You Assumes You Have Experience Working With Sql Server As A Database Administrator, System Engineer, Or Developer Includes Downloadable Sample Database And Code For Sql Server 2016 Sp1 (or Later) And Azure Sql Database Querying Data With Transact-sql About The Exam Exam 70-761 Focuses On The Skills And Knowledge Necessary To Manage And Query Data And To Program Databases With Transact-sql In Sql Server 2016.