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, 1st Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.