Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Purchase Benefits
What is included with this book?
Paul Atkinson works for Huron Healthcare as a BI Architect and Team Lead developing both traditional and real-time BI solutions. His training classes in high-performance TSQL programming are among the most popular course offerings available at Huron.
Robert Vieira is a Software Architect with Huron Consulting Group and is considered one of the leading authorities on Microsoft SQL Server. He speaks at conferences nationally and is well known for his unique tutorial approach in his teaching and writing.
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
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.