Beginning Microsoft SQL Server 2008 programming / Robert Vieira.

Format:

Book

Author/Creator:

Vieira, Robert.

Series:

Wrox beginning guides.

Language:

English

Subjects (All):

Database management.

Relational databases.

SQL server.

Physical Description:

1 online resource (724 p.)

Edition:

1st edition

Place of Publication:

Indianapolis, IN : Wiley Pub., 2008.

Language Note:

English

System Details:

text file

Summary:

This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itselfProgresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL ServerDiscusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and moreFeatures updated and new material, including new examples using Microsoft's AdventureWorks sample databas

Contents:

Beginning Microsoft SQL Server 2008 Programming; About the Author; Credits; Acknowledgments; 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-SQL; 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 FunctionsChapter 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

Notes:

Includes index.

ISBN:

9786612682964

9781118059609

1118059603

9781282682962

1282682962

9780470423943

0470423943

OCLC:

317470521