Paul Atkinson, Robert Vieira

Beginning Microsoft SQL Server 2012 Programming (eBook, PDF)

• Format: PDF

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 864
• Erscheinungstermin: 9. April 2012
• Englisch
• ISBN-13: 9781118223888
• Artikelnr.: 37876014

Autorenporträt

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. 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.

Inhaltsangabe

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 6