T-SQL Fundamentals
by Itzik Ben-Gan
4th Edition
Publisher: Microsoft Press PTG
Book Details
| Print ISBN | 9780138102104 |
| eText ISBN | 9780138102081 |
| Publisher | Microsoft Press PTG |
| Publishing Year | 2023 |
| Edition | 4th Edition |
| Language | English |
| Pages | 608 |
T-SQL Fundamentals, 4th Edition, by Itzik Ben-Gan, provides textbook coverage of fundamental Transact-SQL concepts. The text guides readers in writing code to query and modify data across modern Microsoft platforms, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.
The volume covers relational theory, database architecture, table creation, and data integrity definitions. It also addresses foundational retrieval techniques, including single-table SELECT statements, multiple-table joins, subqueries, and table expressions.
To support practice, the textbook supplies reusable sample code designed for cloud, on-premises, and hybrid environments, alongside guidance for setting up the environment and installing sample databases.
Table of Contents
Chapter 1: Background to T-SQL querying and programming
Chapter 2: Single-table queries
Chapter 3: Joins
Chapter 4: Subqueries
Chapter 5: Table expressions
Chapter 6: Set operators
Chapter 7: T-SQL for data analysis
Chapter 8: Data modification
Chapter 9: Temporal tables
Chapter 10: Transactions and concurrency
Chapter 11: SQL Graph
Chapter 12: Programmable objects
Chapter Appendix: Getting started
Customer Reviews
0.0
0 reviews
No reviews yet. Be the first to review this book!
Write a Review
Reviewed by GradeFocus Editorial Team
