Wiley
Wiley.com
Print this page Share

Beginning Microsoft SQL Server 2012 Programming

ISBN: 978-1-118-10228-2
864 pages
April 2012
Beginning Microsoft SQL Server 2012 Programming (1118102282) cover image
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server

The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.

You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.

  • Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements
  • Addresses essential topics including managing keys, writing scripts, and working with store procedures
  • Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services

Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

See More

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

See More

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.

See More
Download TitleSizeDownload
README 669 bytes Click to Download
Complete code download for Beginning Microsoft SQL Server 2012 Programming 30.84 KB Click to Download
AdventureWorks Database Readme
Updated on 4/3/13
462 bytes Click to Download
Bonus Appendix 1: System Functions 3.60 MB Click to Download
Bonus Appendix 2: Very Simple Connectivity Examples 1.02 MB Click to Download
See More
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)

Buy Both
Cannot be combined with any other offers. Learn more.

Related Titles

Back to Top