Home Page Icon
Home Page
Table of Contents for
Close
by Kathi Kellenberger, Scott Shaw
Beginning T-SQL 2012
Title
Dedication
Contents at a Glance
Contents
Foreword
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Getting Started
Installing SQL Server Express Edition
Installing the Sample Databases
Using SQL Server Management Studio
Exploring Database Concepts
Summary
Chapter 2: Writing Simple SELECT Queries
Using the SELECT Statement
Filtering Data
Working with Nothing
Performing a Full-Text Search
Sorting Data
Thinking About Performance
Summary
Chapter 3: Using Functions and Expressions
Expressions Using Operators
Using Functions
The TOP Keyword
Ranking Functions
Thinking About Performance
Summary
Chapter 4: Querying Multiple Tables
Writing INNER JOINS
Writing Outer Joins
Writing Subqueries
Writing UNION Queries
Exploring Derived Tables and Common Table Expressions
Thinking About Performance
Summary
Chapter 5: Grouping and Summarizing Data
Aggregate Functions
The GROUP BY Clause
The ORDER BY Clause
The WHERE Clause
The HAVING Clause
DISTINCT
Aggregate Queries with More Than One Table
Isolating Aggregate Query Logic
GROUPING SETS
CUBE and ROLLUP
Thinking About Performance
Summary
Chapter 6: Manipulating Data
Inserting New Rows
Deleting Rows
Updating Existing Rows
Using Transactions
Thinking About Performance
Database Cleanup
Summary
Chapter 7: Understanding T-SQL Programming Logic
Variables
The IF… ELSE Construct
WHILE
Error Handling
Temporary Tables and Table Variables
Thinking About Performance
Summary
Chapter 8: Working with XML
Converting XML into Data Using OPENXML
Retrieving Data as XML Using the FOR XML Clause
XML Data Type
XML Methods
Summary
Chapter 9: Moving Logic to the Database
Tables
Views
User-Defined Functions
Stored Procedures
User-Defined Data Types
Triggers
Thinking About Performance
Database Cleanup
Summary
Chapter 10: Working with Data Types
Large-Value String Data Types (MAX)
Large-Value Binary Data Types
Enhanced Date and Time
HIERARCHYID
Spatial Data Types
Sparse Columns
Summary
Chapter 11: Writing Advanced Queries
Advanced CTE Queries
The OUTPUT Clause
The MERGE Statement
GROUPING SETS
Pivoted Queries
Numbers Table
Database Cleanup
Summary
Chapter 12: Where to Go Next?
Online Resources
Conferences
User Groups
Vendors
Books
Classes
SQL Server Books Online
Practice, Practice, and More Practice
Teach Someone Else
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset