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