Beginning Microsoft SQL Server 2012 Programming (Paperback)

INTRODUCTION xxv

CHAPTER 1: RDBMS BASICS: WHAT MAKES UP A SQL SERVER DATABASE? 1

CHAPTER 2: LEARNING THE TOOLS OF THE TRADE 23

CHAPTER 3: THE FOUNDATION STATEMENTS OF T-SQL 49

CHAPTER 4: JOINS 91

CHAPTER 5: CREATING AND ALTERING TABLES 129

CHAPTER 6: KEYS AND CONSTRAINTS 175

CHAPTER 7: ADDING MORE TO YOUR QUERIES 213

CHAPTER 8: BEING NORMAL: NORMALIZATION AND OTHER BASIC DESIGN ISSUES 257

CHAPTER 9: SQL SERVER STORAGE AND INDEX STRUCTURES 305

CHAPTER 10: VIEWS 353

CHAPTER 11: WRITING SCRIPTS AND BATCHES 383

CHAPTER 12: STORED PROCEDURES 435

CHAPTER 13: USER-DEFINED FUNCTIONS 489

CHAPTER 14: TRANSACTIONS AND LOCKS 509

CHAPTER 15: TRIGGERS 537

CHAPTER 16: A BRIEF XML PRIMER 561

CHAPTER 17: BUSINESS INTELLIGENCE FUNDAMENTALS 615

CHAPTER 18: BI STORAGE AND REPORTING RESOURCES 649

CHAPTER 19: REPORTING FOR DUTY, SIR! A LOOK AT REPORTING SERVICES 681

CHAPTER 20: GETTING INTEGRATED WITH INTEGRATION SERVICES 719

CHAPTER 21: PLAYING ADMINISTRATOR 747

APPENDIX: ANSWERS TO EXERCISES 783

INDEX 807

ONLINE APPENDICES

BONUS APPENDIX 1: SYSTEM FUNCTIONS 1

BONUS APPENDIX 2: VERY SIMPLE CONNECTIVITY EXAMPLES 69