Microsoft® SQL Server® 2008 T-SQL Fundamentals.

Format:

Book

Author/Creator:

Ben-Gan, Itzik.

Ben-Gan, Itzik, Author.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

SQL (Computer program language).

Local Subjects:

Client/server computing.

SQL (Computer program language).

SQL server.

Physical Description:

1 online resource (415 p.)

Edition:

1st edition

Place of Publication:

Sebastopol : Microsoft Press, 2008.

Language Note:

English

System Details:

text file

Summary:

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 maintain

Contents:

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

Notes:

Description based upon print version of record.

ISBN:

9780735636224

0735636222

OCLC:

311509956