Nicht aus der Schweiz? Besuchen Sie lehmanns.de

Professional Microsoft SQL Server 2008 Programming (eBook)

(Autor)

eBook Download: EPUB
2010
John Wiley & Sons (Verlag)
978-0-470-63209-3 (ISBN)

Lese- und Medienproben

Professional Microsoft SQL Server 2008 Programming - Robert Vieira
Systemvoraussetzungen
32,99 inkl. MwSt
(CHF 32,20)
Der eBook-Verkauf erfolgt durch die Lehmanns Media GmbH (Berlin) zum Preis in Euro inkl. MwSt.
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing. The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some gotchas that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue. This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference-oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.

Experiencing his first infection with computing fever in 1978, Rob Vieira knew right away that this was something "really cool." In 1980 he began immersing himself into the computing world more fully -- splitting time between building and repairing computer kits, and programming in BASIC as well as Z80 and 6502 assembly. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes and dropped out in 1985 to pursue other interests. Later that year, he caught the "PC bug" and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in business administration in 1990 and since has typically worked in roles that allow him to combine his unique knowledge of business and computing. Beyond his bachelor's degree, he has been certified as a Certified Management Accountant (CMA); Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA); and even had a brief stint certified as an EmergencyMedical Technician (EMT). Rob is currently the Database Team Lead for Stockamp, a Huron Consulting Group practice. He has published six books on SQL Server development.

Introduction.

Chapter 1: Being Objective: Re-Examining Objects in SQL
Server.

Chapter 2: Tool Time.

Chapter 3: Asking a Better Question: Advanced Queries.

Chapter 4: XML Integration.

Chapter 5: Daring to Design.

Chapter 6: Core Storage and Index Structure.

Chapter 7: More Advanced Index Structures.

Chapter 8: Views.

Chapter 9: Scripts and Batches.

Chapter 10: Advanced Programmability.

Chapter 11: Transactions and Locks.

Chapter 12: Triggers.

Chapter 13: SQL Cursors.

Chapter 14: Reporting Services.

Chapter 15: Buying in Bulk: The Bulk Copy Program (BCP) and
Other BasicBulkOperations.

Chapter 16: Getting Integrated.

Chapter 17: Replication.

Chapter 18: Looking at Things in Full: Full-Text Search.

Chapter 19: Feeling Security.

Chapter 20: A Grand Performance: Designing a Database That
Performs Well.

Chapter 21: What Comes After: Forensic Performance Tuning.

Chapter 22: Administration.

Chapter 23: SMO: SQLManagement Objects.

Chapter 24: Data Warehousing.

Chapter 25: BeingWell Connected.

Appendix A: System Functions.

Appendix B: Going Meta: Getting Data About Your Data.

Appendix C: The Basics.

Index.

Erscheint lt. Verlag 4.10.2010
Sprache englisch
Themenwelt Mathematik / Informatik Informatik Datenbanken
Mathematik / Informatik Informatik Netzwerke
Informatik Office Programme Outlook
Schlagworte Computer Science • Database & Data Warehousing Technologies • Datenbanken u. Data Warehousing • Informatik • Microsoft SQL Server 2008 • SQL Server • SQL Server 2008 • SQL Server development • SQL Server for developers • SQL Server for programmers • SQL Server programmer • SQL Server Programming • writing complex queries in SQL Server • XML query support
ISBN-10 0-470-63209-7 / 0470632097
ISBN-13 978-0-470-63209-3 / 9780470632093
Haben Sie eine Frage zum Produkt?
EPUBEPUB (Ohne DRM)

Digital Rights Management: ohne DRM
Dieses eBook enthält kein DRM oder Kopier­schutz. Eine Weiter­gabe an Dritte ist jedoch rechtlich nicht zulässig, weil Sie beim Kauf nur die Rechte an der persön­lichen Nutzung erwerben.

Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belle­tristik und Sach­büchern. Der Fließ­text wird dynamisch an die Display- und Schrift­größe ange­passt. Auch für mobile Lese­geräte ist EPUB daher gut geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür die kostenlose Software Adobe Digital Editions.
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 dafür eine kostenlose App.
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.

Mehr entdecken
aus dem Bereich