Beginning SQL Server 2005 Programming

Covering all the fundamentals of SQL Server 2005, this developer–oriented guide begins with an exploration of the foundation objects of SQL. Each chapter builds on the previous one, gradually progressing to increasingly advanced topics. By the time you′ve completed this book, you will be prepared to perform as an efficient SQL Server 2005 programmer, and, when ready, move on to the more advanced Professional title.
What you will learn from this bookThe various user–defined functions and triggersHow to create and change tablesWays to manage keys, write scripts, and work with stored proceduresTechniques for programming with XMLHow to use Reporting Services and Integration ServicesThe different peripheral features of SQL
Who this book is for
This book is for Microsoft database developers of all levels who are looking for an authoritative resource for core syntax, systems, and strategies for the 2005 release of SQL Server.
Wrox Professional guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Spis treści:
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 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 Serv ices.
Chapter 18: Getting Integrated With Integration Services.
Chapter 19: Playing Administrator.
Appendix A: Exercise Solutions.
Appendix B: System Functions.
Appendix C: Finding the Right Tool.
Appendix D: Very Simple Connectivity Examples.
Appendix E: Installing and Using the Samples.
Index.

Nota biograficzna:
Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of the bestselling title from Wrox Press, Professional SQL Server 2000 Programming, with nearly 40,000 copies in print.  Vieira is currently a Software Architect for NetIQ Corporation in Portland, OR, where he performs design work and coaches other developers. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his light–hearted approach to teaching and writing.

Okładka tylna:
Covering all the fundamentals of SQL Server 2005, this developer–oriented guide begins with an exploration of the foundation objects of SQL. Each chapter builds on the previous one, gradually progressing to increasingly advanced topics. By the time you′ve completed this book, you will be prepared to perform as an efficient SQL Server 2005 programmer, and, when ready, move on to the more advanced Professional title.
What you will learn from this bookThe various user–defined functions and triggersHow to create and change tablesWays to manage keys, write scripts, and work with stored proceduresTechniques for programming with XMLHow to use Reporting Services and Integration ServicesThe different peripheral features of SQL
Who this book is for
This book is for Microsoft database developers of all levels who are looking for an authoritative resource for core syntax, systems, and strategies for the 2005 release of SQL Server.
Wrox Professional guides are crafted to make learning programming langua ges and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.