Beginning SQL Server 2005 Programming

Front Cover
John Wiley & Sons, Feb 2, 2006 - Computers - 688 pages
  • After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
  • Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
  • Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
  • The companion Web site provides all of the code found in the book
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter 1 RDBMS Basics What Makes Up a SQL Server Database?
1
Chapter 2 Tools of the Trade
19
Chapter 3 The Foundation Statements of TSQL
41
Chapter 4 JOINs
79
Chapter 5 Creating and Altering Tables
111
Chapter 6 Constraints
151
Chapter 7 Adding More to Our Queries
185
Chapter 8 Being Normal Normalization and Other Basic Design Issues
207
Chapter 14 Transactions and Locks
425
Chapter 15 Triggers
447
Chapter 16 A Brief XML Primer
469
Chapter 17 Reporting for Duty Sir A Look At Reporting Services
517
Chapter 18 Getting Integrated With Integration Services
539
Chapter 19 Playing Administrator
555
Appendix A Exercise Solutions
577
Appendix B System Functions
587

Chapter 9 SQL Server Storage and Index Structures
255
Chapter 10 Views
289
Chapter 11 Writing Scripts and Batches
315
Chapter 12 Stored Procedures
341
Chapter 13 User Defined Functions
409
Appendix C Finding the Right Tool
639
Appendix D Very Simple Connectivity Examples
647
Appendix E Installing and Using the Samples
651
Index
657
Copyright

Other editions - View all

Common terms and phrases

References to this book

About the author (2006)

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.

Bibliographic information