Wrox Home  
Search

Topic: SQL Server

Beginning Microsoft SQL Server 2012 Programming (1118223888) cover image

Beginning Microsoft SQL Server 2012 Programming

Paul Atkinson, Robert Vieira
ISBN: 978-1-118-22388-8
E-book
864 pages
April 2012
Other Available Formats: Paperback
Electronic Version: US $25.99 Purchase This E-book

About This Title  |  Errata  |  P2P Forum for This Title
Table of Contents

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

Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free