9780470257012

Beginning Microsoft SQL Server 2008 Programming

by
  • ISBN13:

    9780470257012

  • ISBN10:

    0470257016

  • Edition: 1st
  • Format: Paperback
  • Copyright: 1/9/2009
  • Publisher: Wrox

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $39.99 Save up to $21.32
  • Rent Book $25.99
    Add to Cart Free Shipping

    TERM
    PRICE
    DUE

Supplemental Materials

What is included with this book?

  • The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

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

Author Biography

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.

Table of Contents

Introduction
RDBMS Basics: What Makes Up a SQL Server Database?
Tools of the Trade
The Foundation Statements of T-
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
System Functions
Very Simple Connectivity Examples
Index
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review