Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself

Introduction

Who Is This Book For?

Companion Website

Conventions Used in This Book

1 Understanding SQL

Database Basics

What Is SQL?

Try It Yourself

2 Introducing SQL Server

What Is SQL Server?

Getting Started with SQL Server and T-SQL

Preparing for Your Lessons

3 Working with SQL Server

Making the Connection

Navigating SQL Server Management Studio

Creating the Example Tables

Selecting a Database

Learning About Databases and Tables

4 Retrieving Data

The SELECT Statement

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Retrieving Distinct Rows

Limiting Results

Using Fully Qualified Table Names

5 Sorting Retrieved Data

Sorting Data

Sorting by Multiple Columns

Specifying Sort Direction

6 Filtering Data

Using the WHERE Clause

The WHERE Clause Operators

7 Advanced Data Filtering

Combining WHERE Clauses

Using the IN Operator

Using the NOT Operator

8 Using Wildcard Filtering

Using the LIKE Operator

Tips for Using Wildcards

9 Creating Calculated Fields

Understanding Calculated Fields

Concatenating Fields

Performing Mathematical Calculations

10 Using Data Manipulation Functions

Understanding Functions

Using Functions

11 Summarizing Data

Using Aggregate Functions

Aggregates on Distinct Values

Combining Aggregate Functions

12 Grouping Data

Understanding Data Grouping

Creating Groups

Filtering Groups

Grouping and Sorting

SELECT Clause Ordering

13 Working with Subqueries

Understanding Subqueries

Filtering by Subquery

Using Subqueries as Calculated Fields

Checking for Existence with Subqueries

14 Joining Tables

Understanding Joins

Creating a Join

15 Creating Advanced Joins

Using Table Aliases

Using Different Join Types

Using Joins with Aggregate Functions

Using Joins and Join Conditions

16 Combining Queries

Understanding Combined Queries

Creating Combined Queries

17 Full-Text Searching

Understanding Full-Text Searching

Setting Up Full-Text Searching

Performing Full-Text Searches

18 Inserting Data

Understanding Data Insertion

Inserting Complete Rows

Inserting Multiple Rows

Inserting Retrieved Data

Reporting On Inserted Data

19 Updating and Deleting Data

Updating Data

Deleting Data

Reporting On Updated And Deleted Data

Guidelines for Updating and Deleting Data

20 Creating and Manipulating Tables

Creating Tables

Updating Tables

Deleting Tables

Renaming Tables

21 Using Views

Understanding Views

Using Views

22 Programming with T-SQL

Understanding T-SQL Programming

Using Variables

Using Conditional Processing

Grouping Statements

Using Looping

23 Working with Stored Procedures

Understanding Stored Procedures

Why Use Stored Procedures

Using Stored Procedures

24 Using Cursors

Understanding Cursors

Working with Cursors

25 Using Triggers

Understanding Triggers

Using Triggers

26 Managing Transaction Processing

Understanding Transaction Processing

Controlling Transactions

27 Working with XML and JSON

Using SQL Server XML Support

Using SQL Server JSON Support

Retrieving Data as JSON

The JSON Functions

28 Globalization and Localization

Understanding Character Sets and Collation Sequences

Working with Collation Sequences

Managing Case Sensitivity

Working with Unicode

29 Managing Security

Understanding Access Control

Managing Users

Managing Access Rights

30 Improving Performance

Improving Performance

Appendixes

A The Example Tables

B T-SQL Statement Syntax

C T-SQL Datatypes

D T-SQL Reserved Words




9780672337925, TOC, 11/18/2016