The 70-761 exam focuses on T-SQL querying and programming constructs. Whether you’re taking it as part of a Microsoft data platform related certification path, or to assess your T-SQL skills for any other reason, this is a crucial exam, since it covers the essential language constructs. If you need to do work with any of the Microsoft data platform technologies, a good grasp of T-SQL is vital.

The exam covers query constructs like filtering, grouping and sorting, combining data from multiple tables using joins, subqueries, set operators, modifying data, as well as some aspects of data definition like choosing data types and enforcing data integrity. The exam also covers more advanced query constructs like pivoting and unpivoting ...

Get Exam Ref 70-761 Querying Data with Transact-SQL, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.