Acknowledgments
Introduction
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
An Overview of Database Objects
The Database Object
The Transaction Log
The Most Basic Database Object: Table
Filegroups
Diagrams
Views
Stored Procedures
User-Defined Functions
Users and Roles
Rules
Defaults
User-Defined Data Types
Full-Text Catalogs
SQL Server Data Types
NULL Data
SQL Server Identifiers for Objects
What Gets Named?
Rules for Naming
Summary
Chapter 2: Tools of the Trade
Books Online
The SQL Server Configuration Manager
Service Management
Network Configuration
The Protocols
On to the Client
The SQL Server Management Studio
Getting Started
Query Window
SQL Server Integration Services (SSIS)
Bulk Copy Program (bcp)
SQL Server Profiler
sqlcmd
Summary
Chapter 3: The Foundation Statements of T-SQL
Getting Started with a Basic SELECT Statement
The SELECT Statement and FROM Clause
The WHERE Clause
ORDER BY
Aggregating Data Using the GROUP BY Clause
Placing Conditions on Groups with the HAVING Clause
Outputting XML Using the FOR XML Clause
Making Use of Hints Using the OPTION Clause
The DISTINCT and ALL Predicates
Adding Data with the INSERT Statement
The INSERT INTO... SELECT Statement
Changing What You've Got with the UPDATE Statement
The DELETE Statement
Summary
Exercises
Chapter 4: JOINs
JOINs
INNER JOINs
How an INNER JOIN Is Like a WHERE Clause
OUTER JOINs
The Simple OUTER JOIN
Dealing with More Complex OUTER JOINs
Seeing Both Sides with FULL JOINs
CROSS JOINs
Exploring Alternative Syntax for Joins
An Alternative INNER JOIN
An Alternative OUTER JOIN
An Alternative CROSS JOIN
……
Chapter 5: Creating and Altering Tables
Chapter 6: Constraints
Chapter 7: Adding More to Our Queries
Chapter 8: Being Normal: Normalization and Other Basic Design Issues
Chapter 9: SQL Server Storage and Index Structures
Chapter 10: Views
Chapter 11: Writing Scripts and Batches
Chapter 12: Stored Procedures
Chapter 13: User Defined Functions
Chapter 14: Transactions and Locks
Chapter 15: Triggers
Chapter 16: A Brief XML Primer
Chapter 17: Reporting for Duty, Sir!: A Look At Reporting Services
Chapter 18: Getting Integrated With Integration Services
Chapter 19: Playing Administrator
Appendix A: Exercise Solutions
Appendix B: System Functions
Appendix C: Finding the Right Tool
Appendix D: Very Simple Connectivity Examples
Appendix E: Installing and Using the Samples
Index
鄂公网安备 42010302001612号 