Learn T-SQL and Work with Modern SQL Server Technologies
Learn the fundamentals of Transact-SQL (T-SQL) and how to write clear, reliable code for querying and modifying data. The book covers modern Microsoft technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.
Microsoft Data Platform MVP Itzik Ben-Gan explains important T-SQL concepts in a simple and practical way. The book combines theory with hands-on exercises and reusable examples that can be used in cloud, on-premises, and hybrid environments.
The book covers:
- T-SQL fundamentals and how the language works
- Relational theory and modern SQL Server architecture
- Creating tables and maintaining data integrity
- Writing single-table SELECT queries
- Working with joins and subqueries
- Using derived tables, CTEs, views, inline table-valued functions, and APPLY
- Using UNION, INTERSECT, and EXCEPT
- Analyzing data with window functions, pivoting, grouping sets, and time series
- Inserting, updating, deleting, and merging data
- Working with system-versioned temporal tables
- Understanding transactions and concurrency
- Learning about connections, locks, blocking, and isolation levels
- Using SQL Graph to create, modify, and query graph-based data
- Working with SQL Server programming features and programmable objects
- Setting up your environment and installing sample databases
What You Will Learn
This book helps you:
- Understand how and why T-SQL works
- Write better and more reliable SQL code
- Work with databases and maintain data integrity
- Create effective queries for simple and complex data
- Analyze data using modern SQL features
- Modify and manage database information
- Understand transactions and how multiple users work with databases at the same time
- Use SQL Graph for graph-based data
- Improve your T-SQL programming skills
Who Is This Book For?
This book is useful for:
- T-SQL developers
- SQL Server database administrators (DBAs)
- Business intelligence (BI) professionals
- Data scientists
- Report writers
- Data analysts
- Database architects
- SQL Server users and professionals
- Anyone who needs to write queries or T-SQL code
It is especially useful for people working with SQL Server, Azure SQL Database, or Azure SQL Managed Instance.
About the Author
Itzik Ben-Gan is a Microsoft Data Platform MVP and co-founder of SolidQ. He has been a Microsoft Data Platform MVP since 1999 and has trained professionals around the world in T-SQL querying, programming, and query tuning.
He has written several books about T-SQL and many articles and technical papers for publications such as SQL Server Pro, MSDN, and The SolidQ Journal.
Itzik has also presented at major technology events, including Tech-Ed, SQL PASS, SQL Server Connections, SQL Server user groups, and SolidQ events.
He is a T-SQL subject-matter expert at SolidQ and has created and taught advanced T-SQL and T-SQL fundamentals courses worldwide.
About This Ebook
Available File Formats
This ebook is available in the following formats:
- PDF: 6.8 MB
The file sizes are approximate. The actual download size may vary depending on the application you use to read the ebook.
Compatible Devices
You can read this ebook on:
- Windows
- Mac
- Linux
- iOS
- Android devices
It is compatible with more than 25,000 Android-based devices.
Required Software
Mobile:
Install the free reading app for iOS or Android.
Computer:
Use the free Thorium Reader or Adobe Digital Editions.
Web:
You can read the ebook directly in a web browser without installing any software.
Other options:
You can also use any device or reading app that supports Readium LCP or Adobe DRM.
Kindle Compatibility
This ebook is not compatible with regular Kindle devices. It can only be read on a Kindle Fire tablet.
Book Information
- Title: T-SQL Fundamentals
- Author: Itzik Ben-Gan
- Edition: 4th Edition
- Publisher: Pearson Education
- Imprint: Microsoft Press
- Published: March 2023
- Language: English
- Number of Pages: 608
