Microsoft® SQL Server® 2008 T-SQL Fundamentals
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 practi...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2008.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627343206719 |
Tabla de Contenidos:
- Cover; Copyright; Dedication; Contents at a Glance; Table of Contents; Acknowledgments; Introduction; Who This Book Is For; What This Book Is About; Companion Content; Hardware and Software Requirements; Find Additional Content Online; Support for This Book; Questions and Comments; Chapter 1: Back to T-SQL Querying and Programming; Theoretical Background; SQL; Set Theory; Predicate Logic; The Relational Model; The Data Life Cycle; SQL Server Architecture; SQL Server Instances; Databases; Schemas and Objects; Creating Tables and Defining Data Integrity; Creating Tables; Defining Data Integrity
- ConclusionChapter 2: Single-Table Queries; Elements of the SELECT Statement; The FROM Clause; The WHERE Clause; The GROUP BY Clause; The HAVING Clause; The SELECT Clause; The ORDER BY Clause; The TOP Option; The OVER Clause; 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; Catalog Views
- Information Schema ViewsSystem Stored Procedures and Functions; Conclusion; Exercises; Solutions; Chapter 3: Joins; Cross Joins; ANSI SQL-92 Syntax; ANSI SQL-89 Syntax; Self Cross Joins; Producing Tables of Numbers; Inner Joins; ANSI SQL-92 Syntax; ANSI SQL-89 Syntax; Inner Join Safety; Further Join Examples; Composite Joins; Non-Equi Joins; Multi-Table Joins; Outer Joins; Fundamentals of Outer Joins; Beyond the Fundamentals of Outer Joins; Conclusion; Exercises; Solutions; Chapter 4: Subqueries; Self-Contained Subqueries; Self-Contained Scalar Subquery Examples
- Self-Contained Multi-Valued Subquery ExamplesCorrelated Subqueries; The EXISTS Predicate; Beyond the Fundamentals of Subqueries; Returning Previous or Next Values; Running Aggregates; Misbehaving Subqueries; Conclusion; Exercises; Solutions; Chapter 5: Table Expressions; Derived Tables; Assigning Column Aliases; Using Arguments; Nesting; Multiple References; Common Table Expressions; Assigning Column Aliases; Using Arguments; Defining Multiple CTEs; Multiple References; Recursive CTEs; Views; Views and the ORDER BY Clause; View Options; Inline Table-Valued Functions; The APPLY Operator
- ConclusionExercises; Solutions; Chapter 6: Set Operations; The UNION Set Operation; The UNION ALL Set Operation; The UNION DISTINCT Set Operation; The INTERSECT Set Operation; The INTERSECT DISTINCT Set Operation; The INTERSECT ALL Set Operation; The EXCEPT Set Operation; The EXCEPT DISTINCT Set Operation; The EXCEPT ALL Set Operation; Precedence; Circumventing Unsupported Logical Phases; Conclusion; Exercises; Solutions; Chapter 7: Pivot, Unpivot, and Grouping Sets; Pivoting Data; Pivoting with Standard SQL; Pivoting with the Native T-SQL PIVOT Operator; Unpivoting Data
- Unpivoting with Standard SQL
