Skip to main content

Beginning Microsoft SQL Server 2008 Programming

Beginning Microsoft SQL Server 2008 Programming

Robert Vieira

ISBN: 978-0-470-25701-2

Jan 2009

720 pages

Select type: Paperback

Product not available for purchase

Description

  • 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 itself
  • Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server
  • Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more
  • Features updated and new material, including new examples using Microsoft's AdventureWorks sample database

Related Resources

Instructor

Request an Evaluation Copy for this title

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.

Readme
Download
Code downloads for Beginning Microsoft SQL Server 2008 Programming
Download
ChapterPageDetailsDatePrint Run
12Error in Text
As of SQL Server 2008, full-text catalogs have been intergrated into the mail database engine...

Should be

As of SQL Server 2008, full-text catalogs have been intergrated into the main database engine...
4/8/09

16Error in Text
In the box on page 16:

Currently reads:
"SQL Server has no concept of unsigned numeric data types."

Should read:
"SQL Server has no concept of unsigned numeric data types, except for TinyInt."
10/21/2013

406Error in Text
"The first executable line of our sproc is a bit deceptive - it is the DELCARE statement for @WorkingIn."

should read:

"The first executable line of our sproc is a bit deceptive - it is the DECLARE statement for @WorkingIn."
12/17/08

581Error in Text
The sentence "You can feed it a list and say 'do all of these please!'" should read "You can't feed it a list and say 'do all of these please!" The 't is missing.
04/01/2011