BN.com Gift Guide

Beginning Microsoft SQL Server 2008 Programming

Overview

  • 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 ...
See more details below
Paperback (Original)
$29.14
BN.com price
(Save 27%)$39.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (18) from $4.82   
  • New (9) from $7.09   
  • Used (9) from $4.82   

Overview

  • 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
Read More Show Less

Product Details

  • ISBN-13: 9780470257012
  • Publisher: Wiley
  • Publication date: 9/16/2008
  • Edition description: Original
  • Edition number: 1
  • Pages: 720
  • Sales rank: 430,987
  • Product dimensions: 7.30 (w) x 9.20 (h) x 1.60 (d)

Meet the Author

Experiencing his first infection with computing fever in 1978, Rob Vieira knew right away that this was something “really cool.” In 1980 he began immersing himself in the computing world more fully — splitting time between building and repairing computer kits, and programming in Basic as well as Z80 and 6502 assembly. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes, and dropped out in 1985 to pursue other interests. Later that year, he caught the “PC bug” and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in Business Administration in 1990, and since has typically worked in roles that allow him to combine his knowledge of business and computing. Beyond his Bachelor’s degree, he has been certified as a Certified Management Accountant as well as Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA). Rob is currently the DBA Team Lead for the Stockamp practice of The Huron Consulting Group in Portland, Oregon, and makes occasional speaking appearances on database development, business intelligence, and other topics. He resides with his youngest daughter Adrianna (aka Addy, aka Trillian, aka “T”) in Vancouver, WA.

Read More Show Less

Table of 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-.

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)