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

Ben Forta is Adobe Systems’ Senior Director of Education Initiatives and has more than three decades of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes, spinoff titles (like this one), the ColdFusion Web Application Construction Kit series, Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on Internet and database technologies. 

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