Book description
Master the foundations of T-SQL with the right balance of
conceptual and practical content. Get hands-on
guidance—including exercises and code samples—that show
you how to develop code to query and modify data. You’ll gain
a solid understanding of the T-SQL language and good programming
practices, and learn to write more efficient and powerful
queries.
Discover how to:
Apply T-SQL fundamentals, create tables, and define data integrity
Understand logical query processing Query multiple tables using
joins and subqueries Simplify code and improve maintainability with
table expressions Explore pivoting techniques and how to handle
grouping sets Write code that modifies data Isolate inconsistent
data and address deadlock and blocking scenarios
Table of contents
- Acknowledgments
- Introduction
- 1. Background to T-SQL Querying and Programming
-
2. Single-Table Queries
- Elements of the SELECT Statement
- Predicates and Operators
- CASE Expressions
- NULLs
- All-At-Once Operations
-
Working with Character Data
- Data Types
- Collation
- Operators and Functions
- The LIKE Predicate
-
Working with Date and Time Data
- Date and Time Data Types
- Literals
- Working with Date and Time Separately
- Filtering Date Ranges
- Date and Time Functions
- Querying Metadata
- Conclusion
- Exercises
- Solutions
- 3. Joins
- 4. Subqueries
- 5. Table Expressions
- 6. Set Operations
- 7. Pivot, Unpivot, and Grouping Sets
- 8. Data Modification
- 9. Transactions and Concurrency
- 10. Programmable Objects
- A. Getting Started
- Itzik Ben-Gan
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® SQL Server® 2008 T-SQL Fundamentals
- Author(s):
- Release date: October 2008
- Publisher(s): Microsoft Press
- ISBN: 9780735626010
You might also like
book
Inside Microsoft® SQL Server® 2008: T-SQL Querying
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside …
book
Inside Microsoft® SQL Server® 2008: T-SQL Programming
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database …
book
Inside Microsoft® SQL Server™ 2005: T-SQL Querying
This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of …
book
Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008
If you have never programmed with T-SQL but have some background programming knowledge and experience, Beginning …