Mi colega y amigo Itzik Ben-Gan ha finalizado otro libro más de T-SQL, esta vez para SQL Server 2008 con la caldiad que lo caracteriza.
Del sitio del propio libro http://www.sql.co.il/books/tsqlfund2008/ aquí tienes la tabla de contenidos.
Chapter 01: Background to T-SQL Querying and Programming
– Theoretical Background
– SQL Server Architecture
– Creating Tables and Defining Data Integrity
– Conclusion
Chapter 02: Single-Table Queries
– Elements of SELECT Statement
– Predicates and Operators
– CASE Expressions
– NULLs
– All-At-Once Operations
– Working with Character Data
– Working with Date and Time Data
– Querying Metadata
– Conclusion
– Exercises
– Solutions
Chapter 03: Joins
– Cross Joins
– Inner Joins
– Further Join Examples
– Outer Joins
– Conclusion
– Exercises
– Solutions
Chapter 04: Subqueries
– Self-Contained Subqueries
– Correlated Subqueries
– Beyond the Fundamentals of Subqueries
– Conclusion
– Exercises
– Solutions
Chapter 05: Table Expressions
– Derived Tables
– Common Table Expressions
– Views
– Inline User Defined Functions
– APPLY
– Conclusion
– Exercises
– Solutions
Chapter 06: Set Operations
– The UNION Set Operation
– The INTERSECT Set Operation
– The EXCEPT Set Operation
– Precedence
– Circumventing Unsupported Logical Phases
– Conclusion
– Exercises
– Solutions
Chapter 07: Pivot, Unpivot and Grouping Sets
– Pivoting Data
– Unpivoting Data
– Grouping Sets
– Conclusion
– Exercises
– Solutions
Chapter 08: Data Modification
– Inserting Data
– Deleting Data
– Updating Data
– Merging Data
– Modifying Data through Table Expressions
– Modifications with the TOP Option
– The OUTPUT Clause
– Conclusion
– Exercises
– Solutions
Chapter 09: Transactions and Concurrency
– Transactions
– Locks and Blocking
– Isolation Levels
– Deadlocks
– Conclusion
– Exercises
Chapter 10: Programmable Objects
– Variables
– Batches
– Flow Elements
– Cursors
– Temporary Tables
– Dynamic SQL
– Routines
– Error Handling
– Conclusion
Appendix A: Getting Started
– Installing SQL Server
– Downloading Source Code and Installing Sample Database
– Working with Microsoft SQL Server Management Studio
– Working with Microsoft SQL Server Books Online
