
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
Query and modify data effectively with the latest T-SQL features Master Transact-SQL's fundamentals, and write correct, robust 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 explains key T-SQL concepts, helping you apply your knowledge with hands-on exercises. Ben-Gan first introduces T-SQL's theory and underlying logic, illuminating it as both a language and a way of thinking. Next, he walks through core topics, including 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, Ben-Gan presents reusable T-SQL sample code that works in cloud, on-premises, and hybrid environments. Microsoft Data Platform MVP Itzik Ben-Gan helps you: Understand why T-SQL works as it does, so you can write better code Review relational theory elements and modern SQL Server architecture Create tables and defi ne data integrity Build single-table SELECT queries, multiple-table joins, and subqueries Utilize derived tables, Common Table Expressions, views, inline table-valued functions, and APPLY Make the most of UNION, INTERSECT, and EXCEPT set operators Perform data analysis with window functions, pivoting, grouping sets, and time series Insert, update, delete, and merge data Get started with system-versioned temporal tables Understand and apply transactions and concurrency, including concurrent user connections, locks, blocking, isolation levels, and more Use SQL Graph to model, create, modify, and query graph-based data Explore SQL Server programmable objects and programming capabilities Set up your environment, install sample databases, and fi nd even more he
This book investigates how to effectively query and modify data using the latest T-SQL features across modern Microsoft data platforms. It details the theory and logic behind T-SQL, presenting it as both a language and a way of thinking. The author guides readers through core topics such as logical query processing, single and multiple table queries, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions. The content is designed to enhance coding capabilities with reusable T-SQL sample code applicable to cloud, on-premises, and hybrid environments.
This comprehensive guide is highly regarded for its in-depth exploration of T-SQL fundamentals, particularly its focus on modern Microsoft data technologies. It is praised for Itzik Ben-Gan's clear explanations of complex concepts and the practical application through hands-on exercises. The book is considered an essential resource for developers and database professionals seeking to write more efficient and robust T-SQL code. Its coverage of both foundational principles and advanced features, including SQL Graph and temporal tables, makes it a valuable reference for various environments.
Page Count:
1882
Publication Date:
2023-03-03
Publisher:
Pearson Technology Group
ISBN-10:
0138102082
ISBN-13:
9780138102081