Murach's SQL for SQL Server [With CDROM]

by Bryan Syverson

Unlike most SQL books, this one starts by showing how to use SQL queries to get the data from an existing database because that is what every reader needs to know. Once that is established, the book... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1890774162
• ISBN13: 9781890774165
• Release Date: January 2002
• Publisher: Mike Murach & Associates
• Length: 576 Pages
• Weight: 2.90 lbs.
• Dimensions: 1.6" x 8.0" x 10.0"

Customer Reviews

A good survey of SQL for Microsoft SQL Server 2000

This is a good book. However, if you are just beginning to learn SQL, then you should really slug through "SQL Queries for Mere Mortals" first. Having done that, I found Murach's 2 page presentation style on each topic a very good way to reinforce what I had learned in "SQL Queries for Mere Mortals". The Murach text also teaches you the SQL extensions specific to Microsoft SQL Server 2000, and covers the UPDATE, DELETE & INSERT keywords, plus Data Definition Language and the other advanced features of SQL Server.

Almost as good as hands on

The most important feature of this book is that it provides good coverage of SQL Server topics with good comprehension.I was skeptical when I heard of the 2 page format: explain a concept on the left page and show an example emphasizing important points on the right page. It turned out to be an excellent approach to teaching a subject area. Each concept is bite sized. Each example demonstrates the concept. The important points reinforce the key items and introduce subtleties you might not encounter until you've used SQL Server for a while.I read the book as background to the 70-229 SQL Server Design exam. This book's scope provides only a subset of the exam's topics. It is a great SQL Server introduction book.

The Best Book Ever!!!

I picked up this book last week and I have to saywhat an excellent book it is! I have been using SQLsyntax for ten years but have always been intimidated by SQL Server. Notanymore! This book is the best book I have ever read on ANY computer topic.The two-page format makes it easy to learn a new skill. The examples areclear and easy to follow. I was especially impressed with the writers ability tostart with simple examples and expand on them from there. The CD that comes with he book includes an evaluaton copy of SQL Server so you have everything you need to start right away.If you don't learn SQL Server from this book, then there is little hope you ever will!

A comprehensive reference and professional training manual

Murach's SQL For SQL Server is a comprehensive reference and professional training manual for computer programmers which offers both basic and advanced tutorials in such things as how to write SQL queries that retrieve and update the stored contents of a Microsoft SQL Server database; designing databases; and using features embraced by professions such as triggers, locking and security, stored procedures; and much, much more. A solid guide packed with examples, tips, tricks, and techniques, Murach's SQL For SQL Server also includes a CD-ROM containing the Microsoft SQL Server Desktop Engine, Microsoft SQL Server Enterprise Evaluation Edition, Microsoft SQL Server 2000 Books Online, five databases that can be used in conjunction with the text, examples from the book, and a great deal more. Murach's SQL For SQL Server is an invaluable and highly recommended addition to SQL oriented reference collections.