Beginning Transact-SQL with SQL Server 2000 and 2005

Contents

Acknowledgments

Foreword

Chapter 1: Introducing Transact-SQL and Data Management Systems

Transact-Structured Query Language

T-SQL: Programming Language or Query Language?

What's New in SQL Server 2005

Database Management System (DBMS)

SQL Server as a Relational Database Management System

Tables

Relationships

RDBMS and Data Integrity

SQL Server and Other Products

Microsoft SQL Server

Oracle

IBM DB2

Informix

Sybase SQLAnywhere

Microsoft Access

MySQL

Summary

Chapter 2: SQL Server Fundamentals

Who Uses SQL Server?

SQL Server Editions and Features

SQL Server 2000

SQL Server 2005

Relational Database Engine

Semantics

Changing Terminology

Relationships

Primary Keys

Foreign Keys

Normalization Rules

Transforming Information into Data

Applying Normalization Rules

Thinking Ahead

Multiple Associations

Multi-valued Columns

To Normalize or to De-normalize?

Question Authority

Client/Server Processes

The Mechanics of Query Processing

The Adventure Works Cycles Database

Summary

Chapter 3: Tools for Accessing SQL Server

Tools for SQL Server 2000

Enterprise Manager

Query Analyzer

Using Books Online

OSQL Command-line Utility

Tools for SQL Server 2005

SQL Computer Manager

SQL Server Management Studio

Business Intelligence Development Studio

SQLCMD Command-line Utility

Summary

Exercises

Exercise 1

Exercise 2

Exercise 3

Exercise 4

Chapter 4: Introducing Transact-SQL Language

The Nature of SQL

Where to Begin

Data Manipulation Language (DML)

Queries Have Layers

Set-Based Operations

Row-Based Operations ...