Chapter 1. Manage data with Transact-SQL

Transact-SQL (T-SQL) is the main language used to manage and manipulate data in Microsoft SQL Server and Azure SQL Database. If you work with any of the Microsoft SQL products—as a developer, DBA, BI professional, data analyst, data scientist, or in any other capacity—you need to know your T-SQL. Exam 70-761 is a foundational exam that tests your T-SQL querying knowledge, and is a required part of several of the Microsoft SQL certification paths.

This chapter focuses on managing data with T-SQL. It covers the elements of the SELECT statement, how to combine data from multiple tables with set operators and joins, use of built-in functions, and how to modify data.

Important Have you read page xv?

It contains ...

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.