Beginning Microsoft SQL Server 2012 Programming (eBook)
864 Seiten
John Wiley & Sons (Verlag)
978-1-118-22388-8 (ISBN)
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.
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.
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
| Erscheint lt. Verlag | 9.4.2012 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Schlagworte | Computer Science • Database & Data Warehousing Technologies • Datenbanken u. Data Warehousing • Informatik • SQL Server |
| ISBN-10 | 1-118-22388-8 / 1118223888 |
| ISBN-13 | 978-1-118-22388-8 / 9781118223888 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Größe: 92,9 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
