Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

Beginning Microsoft SQL Server 2008 Programming [Kindle Edition]

Robert Vieira
5.0 out of 5 stars  See all reviews (3 customer reviews)

Print List Price: £26.99
Kindle Price: £25.64 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £1.35 (5%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £25.64  
Paperback £26.99  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book 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

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Product Description

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


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
3 of 4 people found the following review helpful
5.0 out of 5 stars An excellent SQL Server overview 20 July 2009
Format:Paperback|Verified Purchase
I bought this book as a reference for SQL Server, having programmed earlier versions over a number of years. Overall the book is well written, and full of useful information. Occasionally I was not sure what he was getting at, as the style is sometimes a bit too casual and wordy, and I had to 'Google' to find an explanation. The author covers SQL Server from the beginning to the intermediate level, including fairly recent topics such as XML integration. Some of the chapters are almost identical to ones in the author's advanced SQL Server book. He covers fundamental issues such as basic SQL queries, normalisation, indexes, constraints, locks, joins, correlated queries and so on. According to the author he has been working in the field for many years, and the content does appear to be more pragmatic than theoretical. I recommend that you do as I did and buy both this book and the authors advanced SQL Server book from the same publisher.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Amazing Book! 3 Dec. 2012
Format:Paperback|Verified Purchase
Got this book to brush up on my SQL knowledge and now I treat it almost like a bible. The exercises are so informative and very well laid out. If only all IT books were as good as this one.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Five Stars 4 Sept. 2014
Format:Paperback|Verified Purchase
Happy with purchase
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.9 out of 5 stars  16 reviews
6 of 7 people found the following review helpful
5.0 out of 5 stars A great beginner book 11 April 2009
By Amazon Customer - Published on Amazon.com
Format:Paperback|Verified Purchase
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
3.0 out of 5 stars 30% fluff + 40% insight + 30% ? 24 Jun. 2012
By Nikos - Published on Amazon.com
Format:Paperback|Verified Purchase
The author likes soapboxes and countless jokes and pithy sayings, that in my view, due to the sheer amount of such material, distracts from a quick read and a quick learn of the material. If you are looking for someone to cut to the chase, this is not your work.

Vieira knows his stuff, and absolutely, he shares a lot of gems. But many beginners (see title) are in the category of those who are in need of very quickly learning the material, of getting up to speed as fast as possible (and I don't mean cutting any of the meat out, just the fluff). I frequently had to set the book down and go elsewhere, because I got fed up with this style, which I felt was hard to follow, and did not allow me to just quickly pick up the core concepts. In one of those cases, I got fed up with his rambling and looked for other books, and found Murach's. Never had purchased his books before, but WOW, that was exactly the kind of no nonsense tutorial I was looking for.

I don't like giving bad reviews, so let me reiterate, there is still a lot of good material here, and Vieira is an expert in the content, just not in presenting it concisely and to the point.
1 of 1 people found the following review helpful
4.0 out of 5 stars Good Beginners' Book 16 Mar. 2011
By Queenie J - Published on Amazon.com
Format:Paperback|Verified Purchase
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 of 8 people found the following review helpful
4.0 out of 5 stars Big enough to stop a train, but filled with good bits... 9 Oct. 2010
By ewomack - Published on Amazon.com
Format:Paperback
No one will remember tech books as great literature. They're a vast linguistic junk yard, yes, but at least one with a purpose. Although most teachers would flinch until their undies imploded at the thought, one can learn something from even a poorly written book. And look no further for bad writing than tech books. Their rush to market eagerness and probable demographic presumptions likely explain their often appalling syntax and spelling. Of course no one wants to read sloppy prose in any genre, but who really reads tech books for their literary qualities? If such a person exists, a slobbering impresario with a reality show contract likely awaits. The ultimate test for tech books remains utility. Can one read a given book and then produce something decent? If yes, then something of value exists.

Wrox books possess enough bulk to function as doorstops or bridge struts, definitely. And often the author/programmers' grinning or deadpan faces glaring in not extremely appealing black, white and red contrast don't inspire aesthetic spasms. Nonetheless, what they lack in artistic merits they often make up for in technical knowledge. "Beginning Microsoft SQL Server 2008 Programming" stands as one Wrox book that, for the most part, delivers. Anyone who has found themselves thrown head first into database programming can easily osmose the basics from this tome. It takes a while to read, but the investment pays off in depth of knowledge. Working with databases on any professional level would prove difficult without mastering this book's first twelve chapters. Go ahead and try, but have your resume ready. And though some software developers, particularly of the .NET variety, may now rest content with LINQ, knowledge of SQL and database technology would only enhance their skill sets. This book provides just the right background for such people.

Though the book contains some rough spots, coverage of the main points of T-SQL remains more than adequate. From SELECT, JOIN, CREATE, ALTER, CONSTRAINT, to normalization, views, stored procedures, user defined functions and triggers, this book will help anyone whose boss suddenly orders them in front of SQL Management Studio. Though more coverage of cursors would help beginners who find themselves faced with these monstrosities. And the trigger chapter leaves those murky and dangerous objects, which lurk like methane bubbles beneath cracking ice, still mysterious. The book's final sections provide previews of the "SQL Stack," which includes Integration Services (SSIS), Reporting Services (SSRS) and a dabbling of Database Administration. These provide only a meager tease. Larger books than this one exist on SSIS alone. Once again, this book requires a time investment. An installation of the SQL Server 2008 client also helps (other books cover the server side). But, like any investment, it can pay off when study integrates with practice.
4.0 out of 5 stars Easy to understand 8 Feb. 2013
By OC mom - Published on Amazon.com
Format:Paperback|Verified Purchase
I like this book because it is written in a manner that is easy understand if you are not a programmer. The author gives a wealth of examples you can type write into SQL Server and see the results. The book is descriptive yet moves a fast past.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category