T-SQL Fundamentals

Itzik Ben-Gan, a long-time Microsoft Data Platform MVP, teaches T-SQL fundamentals for querying and modifying data with modern Microsoft data technologies. He covers logical query processing, single-table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, transactions, and concurrency. Ben-Gan provides reusable T-SQL sample code for cloud, on-premises, and hybrid environments.

Format: Paperback / softback
Length: 608 pages
Publication date: 08 June 2023
Publisher: Pearson Education (US)

Master the fundamentals of Transact-SQL and write efficient and reliable code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

Long-time Microsoft Data Platform MVP Itzik Ben-Gan, who has extensive experience in the field, guides you through key T-SQL concepts, helping you apply your knowledge through hands-on exercises.

Ben-Gan begins by introducing the theory and underlying logic of T-SQL, presenting it as both a language and a way of thinking. He then delves into core topics such as logical query processing, single-table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions and concurrency.

Building on this foundation, you'll enhance your coding capabilities, from programmatic constructs to the powerful new SQL Graph. Throughout the course, Ben-Gan provides reusable T-SQL sample code that works seamlessly in cloud, on-premises, and hybrid environments.

By the end of this course, you'll have a solid understanding of T-SQL and its applications in modern data platforms. You'll be able to write better code, review relational theory elements, create tables with data integrity, build complex queries, perform data analysis, and handle transactions and concurrency effectively. Additionally, you'll explore the use of SQL Graph, a powerful tool for data manipulation and visualization.

Whether you're a database administrator, developer, or data analyst, this course will empower you to leverage the full potential of T-SQL and modern data technologies to solve complex data-related challenges. So, enroll now and embark on a journey to becoming a skilled T-SQL developer!

Weight: 1094g
Dimension: 189 x 235 x 35 (mm)
ISBN-13: 9780138102104
Edition number: 4 ed