If you want to learn SQL, you've picked the right book. Unlike most SQL 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 server-side features like views, stored procedures, cursors, and transactions, and how to use the CLR integration feature (new in SQL Server 2005) to create database objects in a .NET language like C# or Visual Basic.
With this breadth of material, this book works well for application developers and SQL programmers, but it's also a great first book for DBAs-in-training.
Customer Reviews
Average Rating:
Rating: - Excellent for beginning SQL developers
I'm a junior web developer, and I've found this book to be very useful. The explanations are concise and very clear. Great book for beginning-to-intermediate SQL Server 2005 development.
Rating: - Good
The only thing I can find wrong with it is that it didn't come with sql server cd. Other than that it's just fine.
Rating: - Great format and book for beginners to SQL Server
If you're new to SQL Server, the format of this book could not be better or reading it cover to cover. It's designed (as Murach's other books) in a style to indroduce a small concept per page and give you an excercise to try it yourself. I recommend this book to all beginners to the technology but not necessarily if you have a lot of experience in the field already.
Rating: - A book for teaching how to write SQL for SQL Server 2005
I read Murach's SQL Server 2005 for Developers while looking for a book for teaching a class on SQL. Since the course is going to use SQL Server it seemed like an obvious fit. It is. This is a targeted book for the professional course on writing SQL for SQL Server 2005.
I suppose it could be used for learning SQL for other databases but it does a pretty good job of hitting all the SQL Server specific variations in SQL that make up T-SQL. I also suppose that it could be used for ... Read More
Rating: - Great book, great price
I am using "Murach's SQL Server 2005 for Developers" for a community college entry-level SQL class. It is a great book with nice prose and good examples.
One drawback is that instead of identifying, say, Figure 8.3 above-or-below the image, the identification is listed at the bottom of the page with the image. That takes awhile to get used to and makes it harder than it needs to be to make sure I am looking at the correct code snippet.