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
ISBN
1890774510
Published
24 Nov 2008
Purchase online
amazon.com

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.

Page 2 of 2
  1. Editorial Reviews
  2. Customer Reviews

Customer Reviews

Daniel A. Joseph said
I am an MIS professor at the Rochester Institute of Technology and I consult in the MIS area on a regular basis. My consulting has included work using SQL Server and writing/modifying SQL Server Scripts. This text is by far the best introductory text I have come across for SQL Server and I have reviewed and used many. It is not only good for use in class but it is an excellent reference for anyone who is writing or altering SQL Server Scripts.

N. Perez said
Its an absolutely great book, but THERE ARE NO ANSWERS TO THE EXERCISE QUESTIONS!!!! Grrrr!

James C. Lin said
This is my first Murach book, and I am very impressed by the "paired-pages" approach, which is very helpful for the reader to grasp key points. The "How-To" style makes it very practical for beginning to junior level SQL Server developers to find answers and examples. I like the typefaces and font sizes used, and these together with the line spacing used make it very comfortable to read.

Some IT books skip explaining certain fundamental details and terms, assuming that the reader already knows about them. This is not the case for this book, which makes it additionally easy and pleasant to read.

Not only does the book have good coverage of database design, normalization, and SQL query syntax, but it also covers cursors, transactions, locking, security, BLOBs, XML, and FILESTREAM all the way through SQL CLR integration. Some of the new features and data types in SQL Server 2008 are also covered.

My biggest disappointment in this book is its lack of coverage of the new spatial data types and their related functions introduced in SQL Server 2008. Perhaps that deserves a separate book.

Midwest Book Review said
The rapidity of advancements in computer technologies necessitates computer program developers to embark on a continuous study in order to stay current in the their field. In a newly updated and expanded edition, "Murach's SQL Server 2008 For Developers" is the collaborative work of Bryan Syverson and Joel Murach and includes coverage of 2008 SQL features including FILESTREAM storage, the MERGE statement, new date/time data types, 'user-defiended' table type, the SPARSE attribute, filtered indexes, and a great deal more. Specifically designed for application developers, "Murach's SQL Server 2008 For Developers" addresses how to query a database, then goes one to show developers how to design and create a database, advanced features developers will need including views, scripts, stored procedures, functions, triggers, cursors, transactions, locking and security, handling XML and BLOB values, employing CLR integration. Of special note are the coding examples in "Murach's SQL Server 2008 For Developers", providing models for a wide range of SQL jobs. Thoroughly user friendly, "Murach's SQL Server 2008 For Developers" is a 748-page compendium packed with useable and critically important instruction and insight, making it a very strongly recommended addition to personal, professional, and academic library Computer Science reference collections and SQL-based program developer supplemental reading lists.

John Matlock said
In this book, Murach has applied their unique, "paired-pages" layout style to teaching the SQL Server 2008 skills that developers need to create database applications. In this style, each subject is given two pages of description. One page is a technical description of what a particular function does; the facing page is an illustration of that feature being used. As such, this combines the tutorial and reference formats into a single book that I find to be the easiest way to learn how to use a software package.

As I said, the subject of this particular Murach title is the 2008 edition of Microsoft's SQL Server. It is a combination of a book on programming in SQL, which can be looked at as though it is a fully functional programming language in itself, and on using Microsoft tools like the Management Studio, which make Microsoft's SQL significantly easier to use than most other big time database systems.

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Computer science education cannot make anybody an expert programmer any more than studying brushes and pigment can make somebody an expert painter” - Eric Raymond