Contents

Introduction

Chapter 1 Background to T-SQL querying and programming

Theoretical background

SQL

Set theory

Predicate logic

The relational model

Types of database systems

SQL Server architecture

The ABCs of Microsoft RDBMS flavors

SQL Server instances

Databases

Schemas and objects

Creating tables and defining data integrity

Creating tables

Defining data integrity

Conclusion

Elements of the SELECT statement

Chapter 2 Single-table queries

The FROM clause

The WHERE clause

The GROUP BY clause

The HAVING clause

The SELECT clause

The ORDER BY clause

The TOP and OFFSET-FETCH filters

A quick look at window functions

Predicates and operators

CASE expressions

NULLS

All-at-once operations

Working with character data