O'Reilly logo

Exam Ref 70-761 Querying Data with Transact-SQL, First Edition by Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required