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
Exam Ref AZ-900 Microsoft Azure Fundamentals, 2nd Edition
Prepare for Microsoft Exam AZ-900demonstrate your real-world knowledge of cloud services and how they can be …
book
T-SQL Querying
T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency …
book
Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. …
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 …