Beginning Microsoft Sql Server 2008 Programming

Presents an introduction to SQL Server. This title presents an overview of database design basics and the SQL query language along with a look at SQL Server itself. It explains how to implement fundamental concepts with the 2008 version of SQL Server.

Inhaltsverzeichnis

Introduction. Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database? Chapter 2: Tools of the Trade. Chapter 3: The Foundation Statements of T . Chapter 4: JOINs. Chapter 5: Creating and Altering Tables. Chapter 6: Constraints. Chapter 7: Adding More to Our Queries. Chapter 8: Being Normal: Normalization and Other Basic Design Issues. Chapter 9: SQL Server Storage and Index Structures. Chapter 10: Views. Chapter 11: Writing Scripts and Batches. Chapter 12: Stored Procedures. Chapter 13: User Defined Functions. Chapter 14: Transactions and Locks. Chapter 15: Triggers. Chapter 16: A Brief XML Primer. Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services. Chapter 18: Getting Integrated with Integration Services. Chapter 19: Playing Administrator. Appendix A: System Functions. Appendix B: Very Simple Connectivity Examples. Index.

Produktdetails

• Autoren: Robert Vieira
• Verlag: Wiley, John and Sons Ltd
• Sprache: Englisch
• Produktform: Taschenbuch
• Erschienen: 02.01.2009
• EAN: 9780470257012
• ISBN: 978-0-470-25701-2
• Seiten: 720
• Serien: Programmer to Programmer; Wrox Programmer to Programmer; Wrox Programmer to Programmer
• Thema: Naturwissenschaften, Medizin, Informatik, Technik > Informatik, EDV > Informatik