Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) [Paperback]

Robert Vieira (Author)

Book Description

ISBN-10: 0470257016 | ISBN-13: 978-0470257012 | Publication Date: January 9, 2009 | Edition: 1

• 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

Editorial Reviews

From the Back Cover

Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment—SQL Server 2008, in particular—versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008.

You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS (relational database management system) and where it fits in the grand scheme of system development. Thorough coverage of the key additions and changes to the 2008 version of SQL Server include discussions on DATE and TIME datatypes, hierarchyID datatypes, MERGE and multiple inserts, recursive queries, and more. With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.

What you will learn from this book

• How RDBMSs store, manage, and retrieve data

• Ways to create and alter tables

• Various "forms" of database normalization

• Techniques for writing scripts and working with stored procedures

• The positives and negatives of indexes

• Myriad consequences that locks and deadlocks have on system performance

• An understanding of triggers and how they are used

Who this book is for
This book is for developers who are looking for a complete introduction to database design concepts and learning SQL. A basic understanding of development fundamentals is helpful.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

About 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.

Product Details

• Paperback: 720 pages
• Publisher: Wrox; 1 edition (January 9, 2009)
• Language: English
• ISBN-10: 0470257016
• ISBN-13: 978-0470257012
• Product Dimensions: 9.2 x 7.4 x 1.5 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #277,612 in Books (See Top 100 in Books)
  • #76 in Books > Computers & Technology > Microsoft > Development > SQL Server

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 6 people found the following review helpful:

5.0 out of 5 stars A great beginner book, April 10, 2009

By 

Mike Mirzamani "mikemir121" (Laguna Niguel, CA USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) (Paperback)

This is a great beginner's book on T-SQL programming. I like the Author's writing style and comprehensive coverage of all the topics including Reporting, XML, Integration Services, UDFs, and even some Administration tasks. The stored procedure chapter could have been made into two chapters. Also, I was surprised why more examples were not given for the Try/Catch error. Similarly, there was not much to go with the SSIS. Looks like most of the typos in the book were removed since the 2005 publication. Overall, a great book to get one started.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Good Beginners' Book, March 16, 2011

By 

Queenie J "Amazon Queen" (Amazon) - See all my reviews

Amazon Verified Purchase

This review is from: Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) (Paperback)

The author has a lot of great information and shows great restraint in not overwhelming the reader with his obviously advanced knowledge of the subject. He is able to convey the wisdom of his experience to the reader while giving them a great beginning foundation. Now that we have access to YouTube and the like this information should be repackaged and presented via video lessons as an alternative delivery method. Great content. Good Beginners' Book. Definitely recommend for beginning SQL developers.

5.0 out of 5 stars Just as expected, September 26, 2011

By 

Loral W. Godfrey "lwgodfrey" (Ut USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer) (Paperback)

I had to get this book for a college course and its a great step by step learning book. Its also nice that it isn't that expensive compared to some alternatives.