Beginning SQL Server 2005 Programming

Robert Vieira - Collection Programmer to Programmer

688 pages, parution le 02/03/2006

Ajouter à une liste

Indisponible

Résumé

This comprehensive introduction to SQL Server 2005 programming serves as a useful guide for the novice as well the advanced SQL Server user. With the extensive redesign of SQL Server for the 2005 release, it proves itself to be a solid review and reference book intended to be useful well beyond your days as a beginning programmer.

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 book

The various user-defined functions and triggers
How to create and change tables
Ways to manage keys, write scripts, and work with stored procedures
Techniques for programming with XML
How to use Reporting Services and Integration Services
The 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.

Sommaire

RDBMS Basics: What Makes Up a SQL Server Database?
Tools of the Trade
The Foundation Statements of T-SQL
JOINs
Creating and Altering Tables
Constraints
Adding More to Our Queries
Being Normal: Normalization and Other Basic Design Issues
SQL Server Storage and Index Structures
Views
Writing Scripts and Batches
Stored Procedures
User Defined Functions
Transactions and Locks
Triggers
A Brief XML Primer
Reporting for Duty, Sir!: A Look At Reporting Services
Getting Integrated With Integration Services
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

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Robert Vieira
Collection	Programmer to Programmer
Parution	02/03/2006
Nb. de pages	688
Format	18,5 x 23,5
Couverture	Broché
Poids	1047g
Intérieur	Noir et Blanc
EAN13	9780764584336
ISBN13	978-0-7645-8433-6