CHAPTER 1 RDBMS Basics: What Makes Up a SQL Server Database?
CHAPTER 2 Learning the Tools of the Trade
CHAPTER 3 The Foundation Statements of T-SQL
CHAPTER 4 JOINs
CHAPTER 5 Creating and Altering Tables
CHAPTER 6 Keys and Constraints
CHAPTER 7 Adding More to Your 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-Defi ned Functions
CHAPTER 14 Transactions and Locks
CHAPTER 15 Triggers
CHAPTER 16 A Brief XML Primer
CHAPTER 17 Business Intelligence Fundamentals
CHAPTER 18 BI Storage and Reporting Resources
CHAPTER 19 Reporting for Duty, Sir! A Look at Reporting Services
CHAPTER 20 Getting Integrated with Integration Services
CHAPTER 21 Playing Administrator
APPENDIX Answers to Exercises
INDEX