SQL Server 2008 Books

 Location:  Home » All SQL Server 2008 Books » Murach's SQL Server 2008 for Developers (Murach: Training & Reference)  
List by Topic
All SQL Server 2008 Books
Integration Services (SSIS)
Reporting Services
Analysis Services
Data Warehouse
Spatial Data
SQL Server Software
Subcategories
Paperback
Mass Market
Trade
Related Categories
• Textbooks Trade-In
Specialty Stores
Books
• Database Management Systems
Databases
Computers & Internet
Subjects
Books
• General
SQL
Databases
Computers & Internet
Subjects
• General
Databases
Computers & Internet
Subjects
Books
• General
Languages & Tools
Programming
Computers & Internet
Subjects
• General
Programming
Computers & Internet
Subjects
Books
• General
Computers & Internet
Subjects
Books
• Paperback
Binding (binding)
Refinements
Books
• Printed Books
Format (feature_browse-bin)
Refinements
Books

Murach's SQL Server 2008 for Developers (Murach: Training & Reference)

Murach's SQL Server 2008 for Developers (Murach: Training & Reference)Authors: Bryan Syverson, Joel Murach
Publisher: Mike Murach & Associates
Category: Book

List Price: $52.50
Buy New: $33.04
as of 3/10/2010 01:53 CST details
You Save: $19.46 (37%)



New (16) Used (12) from $30.00

Seller: ---superbookdeals
Rating: 4.5 out of 5 stars 12 reviews
Sales Rank: 15708

Media: Paperback
Edition: 3rd
Pages: 748
Number Of Items: 1
Shipping Weight (lbs): 3.5
Dimensions (in): 9.8 x 8 x 1.7

ISBN: 1890774510
Dewey Decimal Number: 005
EAN: 9781890774516
ASIN: 1890774510

Publication Date: November 24, 2008
Availability: Usually ships in 1-2 business days

Similar Items:


Editorial Reviews:

Product Description
This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it's also a great first book for developers who are on the path to becoming a DBA.

Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that's what every application developer needs to know first. Then, it shows how to design and implement a database, how to use powerful backend database features like views, stored procedures, functions, triggers, cursors, transactions, locking, security, and how to work with BLOB and XML data. Finally, it shows how to use the CLR integration feature to create database objects using a .NET language such as C# or Visual Basic.

From the publisher


The SQL book that most developers don't even know they need that's how I think of this book.

To be an effective application developer, you need to master SQL for the database you re going to be using. But many developers get by with the SQL they know, never realizing how much they're missing out on.

So this is first of all a book for developers who use Microsoft SQL Server as their DBMS (though it can help you if you want to master standard SQL, too). No matter how much SQL experience you have, you'll find new features that you haven't been taking advantage of.

In section 1, you ll learn the concepts and terms you need for working with any database. You ll also learn how to use the Microsoft SQL Server 2008 Management Studio to work with queries and databases. At that point, you ll be prepared for rapid progress as you learn SQL.

In section 2, you ll learn all the skills for retrieving data from a database and for adding, updating, merging, and deleting that data. These skills move from the simple to the complex so you won t have any trouble if you re a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you do have SQL experience.

In section 3, you ll learn how to design a database and how to implement that design using either SQL DDL (Data Definition Language) statements or the Management Studio. When you re done, you ll be able to design and implement your own databases. But even if you re never called upon to do that, this section will give you perspective that will make you a better SQL developer.

Section 4 presents the skills for working with database features like views, stored procedures, functions, triggers, cursors, transactions, and security. It teaches you how to use SQL features to work with XML data. And it shows you how to use the 2008 FILESTREAM storage feature to work with binary large objects (BLOBs) such as image, sound, and video files. These are the features that give a DBMS much of its power and that give you an extra edge in your SQL skills.

To complete your SQL Server skills, section 5 shows you how to use the CLR integration feature. This feature allows you to create database objects like stored procedures and user-defined types using a .NET language like C# or Visual Basic.


Customer Reviews:
Showing reviews 1-5 of 12



3 out of 5 stars Great book, bad e-book   March 10, 2010
M. Wassmer (Boulder, CO USA)
WHY I WANT TO GIVE IT 5 STARS:
I learn better when I understand the "why," in addition to the "how." Even if the additional explanations of the "why" add to the total page count, they are well worth it, in my opinion. The explanations of the practical uses of various features are extremely helpful to someone like me because it makes things "stick." The "paired pages" approach is very effective. The book is down-to-business without any stupid attempts at humor, which I appreciate.

WHY I WANT TO GIVE IT 1 STAR:
As someone who went paperless several years ago and appreciates the excellent commenting (i.e., highlighting, notetaking, etc) and navigation features of PDFs and Safari Books Online, I am extremely disappointed that such a terrific book is relegated to such an awful e-book format. The "LockLizard" viewer is a far cry from Adobe Reader, Acrobat, or Safari Books Online. The publisher claims that the LockLizard format is used because it is more user-friendly than other viewers, but I don't buy it. I assume the real reason for the LockLizard format is copy protection. I think copy protection is a good idea, but only if the ebook experience isn't severely degraded as a result of it.

WHY I GAVE IT 3 STARS:
I'll happily raise my rating to 5 stars when the book is published in PDF format or added to Safari Books Online. Until then, I'm giving it 3 stars. I plan on purchasing many more of these Murach books because the content and style is excellent, but I'll remain frustrated with the ebook interface unless the move to PDF or Safari Books Online is made for the whole Murach catalog.



5 out of 5 stars Excellent, in-depth reference   March 6, 2010
David Edge (Charlotte, NC)
This book is a lot more than just a collection of information. It presents topics in a very easy-to-understand format and progression. If you want to learn about SQL server in-depth, this is the choice for you.


5 out of 5 stars Excellent Text and Reference   December 1, 2009
M. Almond (Spokane, WA USA)
2 out of 2 found this review helpful

This is one of the best technical books I have seen in a long time. Like a lot of people who have been around software development for awhile, there are areas where I am an expert and other areas that I have picked up enough on the way to just be "a little bit dangerous". SQL Server was one of the latter areas and I wanted to round out my knowledge and this book proved to be the perfect tool. Its unique "facing page" design means you can easily grasp the topic being discussed, and if it is one you are already comfortable with, just scan the code to make sure and move on quickly, or stop and read the details if needed.

I also recommend that you stop and do the exercises at the end of each major chapter -- they are worth spending the time on. They are well thought out and you may very well pick something up even in those areas where you may "think you know it" (I know I did).

Finally, the layout of the book and a detailed index means that this will be a valuable reference in the future -- I still don't aim to be a SQL guru, but I know that with what I learned and this book as a reference I will be much more capable than before.



5 out of 5 stars Awesome   August 31, 2009
Sean R. Mclean (Las Vegas, NV United States)
1 out of 2 found this review helpful

I don't know if the magazine is still published, but "Mac Addict" had a product category for "Freaking Awesome". This deserves this ranking. There is a solid effort towards basic SQL usage that is focused on SQL Server 2008, but applies well to 2005 and even other RDBMs like MySQL if you want to stretch it some. My only problem was the actual construction of the book -- I went through two bindings. This may be an indicator of how heavily I've relied on this book too. The good folks at Murach's were good sports about it and sent replacements but they have some quality control issues to work out with that particular vendor. They probably already have this sorted out by now.


5 out of 5 stars it was really helpful to learn sql.server   August 16, 2009
Murat Cabuk
1 out of 2 found this review helpful

you don't have to know anything about SQL or SQL Server. this book covers standart sql and T-SQL. I thing the best begining to learn SQL Server.

Showing reviews 1-5 of 12


CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com