Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-761 Querying Data with Transact-SQL certification exam, the first of two exams required for MCSA: SQL 2016 Database Development certification. Exam Ref 70-761 Querying Data with Transact-SQL offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with T-SQL database queries. Coverage includes: Creating Transact-SQL SELECT queries Querying multiple tables with joins Implementing functions and aggregating data Querying temporal and non-relational data Querying data with subqueries, APPLY, and table expressions Grouping and pivoting data with queries Creating database programmability objects through Transact-SQL Implementing error handling and transactions Implementing data types and NULLs Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through "what if?" scenarios, and prepare them for Pro-level style exam questions Focus on the critical-thinking and decision-making acumen needed for success Explore big picture thinking around the planning and design aspects of the IT pro's job role Link to additional in-depth material wherever readers want deeper review of specific technical tasks or concepts For more information on Exam 70-761 and the MCSA: SQL Server 2016 certification, visit microsoft.com/learning.