Beginning Microsoft SQL Server 2012 Programming - Product Image

Beginning Microsoft SQL Server 2012 Programming

  • ID: 2247251
  • Book
  • 864 Pages
  • John Wiley and Sons Ltd
1 of 4

Get the tools to change the way you develop database applications

This step–by–step tutorial will show you how to create more productivemanagement applications and gain business intelligence from your SQLServer database environment. You′ll learn the foundation objects of SQL and basic queries and joins. You′ll then add objects to your database and use items that are important to the physical design. Next, you′ll explore SQL Server scripting. By the end, you′ll have gained the necessary skills to build a world–class database for your world–class application, using the full capabilities of SQL Server 2012.

Beginning Microsoft SQL Server 2012 Programming:

  • Explores the key concepts for developing SQL Server applications, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and the development of Business Intelligence applications

  • Walks you through client–connectivity enhancements, security and compliance, and data warehouse performance improvements

  • Addresses essential topics including managing keys, writing scripts, and working with stored procedures

  • Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services

wrox.com

Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that guides you through all the techniques involved.

READ MORE
Note: Product cover images may vary from those shown
2 of 4

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

Note: Product cover images may vary from those shown
3 of 4

Loading
LOADING...

4 of 4

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.

Note: Product cover images may vary from those shown
5 of 4
Note: Product cover images may vary from those shown
Adroll
adroll