Microsoft SQL Server 2005 Programming For Dummies (eBook)
416 Seiten
John Wiley & Sons (Verlag)
978-0-470-12859-6 (ISBN)
Get up to speed on using T-SQL to store and manipulate data
SQL Server 2005 improves an already great database management
system. This book shows you how to put it to work in a hurry.
You'll find out how to use the SQL Server Management Studio and the
SQLCMD utility to write T-SQL code, retrieve data from single or
multiple SQL Server tables, add data using the INSERT statement,
and much more.
* Create queries to retrieve data
* Ensure SQL Server security
* Use Visual Studio(r) 2005 with SQL Server
* Create tables, views, and indexes
* Work with Common Language Runtime
* Query XML data
Andrew Watt wrote his first computer programs back in 1985. He is an independent consultant, experienced author, and Microsoft MVP (Most Valuable Professional) for SQL Server. His areas of interest and expertise include SQL Server 2005, Windows PowerShell, XML, and Microsoft InfoPath. Andrew first used SQL Server in version 7.0 and was an active participant in the SQL Server 2005 beta program from August 2003. Among the books Andrew has written, or co-written, are SQL Server 2005 For Dummies, Beginning Regular Expressions, Beginning XML (3rd edition), Beginning RSS & Atom Programming, Professional XML (2nd edition), and Designing SVG Web Graphics. Andrew is often seen answering questions in Microsoft's SQL Server and other newsgroups. Feel free to get involved in the community there. He can be contacted direct at SVGDeveloper@aol.com. Due to the volume of e-mail he receives, he can't guarantee to respond to every e-mail.
Introduction.
Part I: Get Started Using the SQL Server 2005 Development
Environment.
Chapter 1: The Joy of SQL Server 2005 Programming.
Chapter 2: Understanding Database Fundamentals.
Chapter 3: Getting to Know the SQL Server Toolset.
Part II: Retrieving Data Using Transact-SQL.
Chapter 4: Retrieving Data Using the SELECT Statement.
Chapter 5: Creating Joins.
Chapter 6: Creating Advanced Queries.
Chapter 7: Manipulating Data.
Part III: Creating Databases and Database Objects with
Transact-SQL.
Chapter 8: Designing, Creating, and Altering Database
Objects.
Chapter 9: Designing, Creating, and Changing Tables.
Chapter 10: Applying Constraints.
Chapter 11: Creating Views.
Chapter 12: Using Stored Procedures.
Chapter 13: Using Triggers.
Chapter 14: Creating Functions.
Chapter 15: Creating Indexes.
Chapter 16: Handling Errors Using TRY . . . CATCH.
Part IV: Programming SQL Server Security.
Chapter 17: Adding Logins and Users.
Chapter 18: Creating Database-Level Security.
Chapter 19: Securing Data Using Encryption.
Part V: Beyond Transact-SQL Programming.
Chapter 20: Working with XML.
Chapter 21: Working with the Common Language Runtime.
Chapter 22: Using Visual Studio 2005.
Chapter 23: Working with SQL Server Management Objects.
Part VI: The Part of Tens.
Chapter 24: Ten Tips to Program Like a Pro.
Chapter 25: Ten Sources for More Information on SQL Server
2005.
Index.
| Erscheint lt. Verlag | 5.7.2007 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Informatik ► Office Programme ► Outlook | |
| Schlagworte | Computer-Ratgeber • End-User Computing • Microsoft Other Software • Microsoft Sonstige Software • SQL Server 2005 |
| ISBN-10 | 0-470-12859-3 / 0470128593 |
| ISBN-13 | 978-0-470-12859-6 / 9780470128596 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Größe: 5,5 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
