T-SQL Fundamentals, 4th Edition
- Length: 608 pages
- Edition: 4
- Language: English
- Publisher: Microsoft Press
- Publication Date: 2023-05-05
- ISBN-10: 0138102104
- ISBN-13: 9780138102104
- Sales Rank: #1039007 (See Top 100 Books)
Starting with the background to T-SQL querying and programming, including: logical query processing, book-querying constructs (single table queries, joins, subqueries, table expressions, set operators, data analysis), data modifications, temporal tables, transactions and concurrency, SQL Graph (completely new to this edition), as well as programmatic T-SQL constructs. The book includes extensive exercises and solutions with explanations, allowing the reader to practice what they’ve learned.
This book is widely considered as the authoritative guide on T-SQL fundamentals. It focuses on understanding why things work the way they do, and not just how to make them work. When people understand the “why” the code they write tends to be more correct and more meaningful. This edition of the book includes coverage of the newest T-SQL additions up to and including SQL Server 2022.
Cover Page Title Page Copyright Page Pearson’s Commitment to Diversity, Equity, and Inclusion Dedication Page Contents at a Glance Table of Contents Acknowledgments About the author Introduction Who Should Read This Book Organization of This Book System Requirements Code Samples Errata & Book Support Stay in Touch Chapter 1. Background to T-SQL querying and programming Theoretical background SQL Server architecture Creating tables and defining data integrity Conclusion Chapter 2. Single-table queries Elements of the SELECT statement Predicates and operators CASE expressions NULLs The GREATEST and LEAST functions All-at-once operations Working with character data Working with date and time data Querying metadata Conclusion Exercises Solutions Chapter 3. Joins Cross joins Inner joins More join examples Outer joins Conclusion Exercises Solutions Chapter 4. Subqueries Self-contained subqueries Correlated subqueries Returning previous or next values Using running aggregates Dealing with misbehaving subqueries Conclusion Exercises Solutions Chapter 5. Table expressions Derived tables Common table expressions Views Inline table-valued functions The APPLY operator Conclusion Exercises Solutions Chapter 6. Set operators The UNION operator INTERSECT operator The EXCEPT operator Precedence Circumventing unsupported logical phases Conclusion Exercises Solutions Chapter 7. T-SQL for data analysis Window functions Pivoting data Unpivoting data Grouping sets Time series Conclusion Exercises Solutions Chapter 8. Data modification Inserting data Deleting data Updating data Merging data Modifying data through table expressions Modifications with TOP and OFFSET-FETCH The OUTPUT clause Conclusion Exercises Solutions Chapter 9. Temporal tables Creating tables Modifying data Querying data Conclusion Exercises Solutions Chapter 10. Transactions and concurrency Transactions Locks and blocking Isolation levels Deadlocks Conclusion Exercises Chapter 11. SQL Graph Creating tables Querying data Data modification considerations Conclusion Exercises Solutions Cleanup Chapter 12. Programmable objects Variables Batches Flow elements Cursors Temporary tables Dynamic SQL Routines Error handling Conclusion Appendix: Getting started Getting started with Azure SQL Installing a SQL Server box product Downloading and installing SQL Server Management Studio Downloading source code and installing the sample database Index Code Snippets
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.