Beginning Microsoft SQL Server 2012 ProgrammingISBN: 978-1-118-10228-2
Paperback
864 pages
April 2012
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability.   Other Available Formats: E-book
|
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
Buy Both and Save 25%!
+
Beginning Microsoft SQL Server 2012 Programming (US $39.99)
-and- Discovering SQL: A Hands-On Guide for Beginners (US $34.99)
Total List Price: US $74.98
Discounted Price: US $56.23 (Save: US $18.75)
