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.

List of contents

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.

Product details

• Authors: Robert Vieira
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 02.01.2009
• EAN: 9780470257012
• ISBN: 978-0-470-25701-2
• No. of pages: 720
• Series: Programmer to Programmer; Wrox Programmer to Programmer; Wrox Programmer to Programmer
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > IT