CONTENTS
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
An Overview of Database Objects
SQL Server Identifiers for Objects
Chapter 2: Learning the Tools of the Trade
Getting Help with Books Online
SQL Server Configuration Manager
SQL Server Data Tools (formerly BIDS)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)
Chapter 3: The Foundation Statements of T-SQL
Getting Started with a Basic SELECT Statement
Adding Data with the INSERT Statement
Changing What You’ve Got with the UPDATE Statement
Combining Table Data with JOINs
Selecting Matching Rows with INNER JOIN
Retrieving More Data with OUTER JOIN
Seeing Both Sides with FULL JOINs
Exploring Alternative Syntax for Joins
Chapter 5: Creating and Altering Tables
Chapter 6: Keys and Constraints
Rules and Defaults — Cousins of Constraints
Chapter 7: Adding More to Your Queries