IT programming books related reviews
Title: The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
This book is essential for those building solutions with Sql Svr. It is really a developer's take on how to create applications based on the world's best database. There are chapters on database design, source code control, design patterns, testing, and many, many others. The SqlXml info is the deepest and best of any of the SQl books I have found. I highly recommend this book.
Title: Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes (Sams Teach Yourself)
Publisher: Sams
Authors: William Robison, William Robinson
Rating: 5/5
Surprisingly, this is a very good book. I'm about halfway through it, and I've already gotten more than my money's worth. Think of this book as a primer to learning SQL Server. Instead of covering every topic in full depth, listing every possible option no matter how obscure, it covers the most useful ones with concise examples and explanations of what's happening each step of the way. A good example is the chapter on Active Server Pages. I had never created an Active Server Page. Yet, about 2 or 3 hours after starting the book, I had created my first one. And with the explanations given, it was easy for me to change some of the code and understand why it did, or didn't, work. If you've never used SQL Server before, want a good intro to it, and often start off your thoughts with the phrase, "I wonder what would happen if I change this...", then this will be a good book for you.
Title: Sams Teach Yourself SQL in 21 Days (4th Edition)
Publisher: Sams
Authors: Ron Plew, Ryan Stephens
Rating: 4/5
This is a good book for beginners but also gets you on the path to more advanced SQL programming. However, beginners beware: I think I found a programming typo in nearly every chapter of the book. The most glaring to me was in Day 14 (p. 340) when a column named "NEW_TOTAL" was referenced in view LATE_PAYMENT (created from table BILLS). BILLS has an AMOUNT field but no NEW_TOTAL field. I have over 20 years programming experience and I had to disregard this entire example. I fear beginners will miss these types of mistakes. If this is one of the better books available (as stated by a previous reviewer), then I'm not sure what book to buy. No typos should exist in a book designed to teach programming.
Title: MCDBA SQL Server 7 Database Design, Study Guide (Exam 70-29)
Publisher: McGraw-Hill Companies Rating: 1/5
I bought this book to help prepare for 70-029. The test questions that come with the book are nothing like the real thing. The test questions on the exam are long and complex. They pose many life like situations that might be encounted as a DBA. This book does nothing to prepare you for those types of questions.I think this book would be helpful for someone trying to understand some of the basics behind SQL Server but having taken the test and used this book as one of my study guides, I will not buy another book from this company that is a "study guide".
Title: SQL-99 Complete, Really
Publisher: CMP Books
Authors: Peter Gulutzan, Trudy Pelzer
Rating: 3/5
the book is huge and has much useful information in it. However, I was somewhat disappointed in regard to the completeness claim the title (and the size) suggests. Especially the more advanced features (the book marks most of them them as "obscure") are not covered well at all. In particular, the new features for handling inheritance with UDTs are hardly ever mentioned, let alone illustrated with examples.It seems that in places where they lack experience of their own, the authors copy the reference manuals at best, sometimes not even that.
Title: SQL Clearly Explained (The Morgan Kaufmann Series in Data Management Systems)
Publisher: Morgan Kaufmann
Authors: Jan L. Harrington
Rating: 5/5
I am more of a user than an IT person, and I found this book very useful and easy to follow. The author has filled this book with examples of queries, and taken the time to discuss some of the more technical aspects of SQL such as data modification, database structure and indexes. So from basic data extraction tecnhiques to an overview of the inner-workings of SQL, this book is a success.
Title: Professional Apache (Professional)
Publisher: Wrox Press
Authors: Peter Wainwright
Rating: 5/5
I bought this book in August 2001 and I still keep it close at hand. It has paid for itself over and over again. Most times I wonder how can I do "?" in apace? And this book has delivered everytime.Now I think I'll buy his book on Apache 2.0
Title: Understanding Relational Databases with Examples in SQL-92
Publisher: John Wiley & Sons
Authors: Fabian Pascal
Rating: 1/5
This book simply does not adequately explain relational databases. Look for something better
Title: Web Database Applications with PHP & MySQL, 2nd Edition
Publisher: O'Reilly
Authors: Hugh E. Williams
Rating: 5/5
This is an EXCELLENT book for an intermediate programmer, likely the best PHP/MYSQL combo book out there. Intermediate programmers have programmed successfully before, but now want to write code and use techniques that are more fundamentally sound. This requires that someone share with them the various OPTIONS, explain their strengths and weaknesses, and then recommend a good way. That's what this book does (more often than not) on subjects ranging from sessions to MySQL locking to regular expressions.This book provides an EDUCATION as opposed to mere instructional advice as to one way something can be done (without context).From another angle, it has been my observation that the inability to understand a programming explanation in a book normally results from the author simply omitting one or two explicit references to minor elements in the causal link that comprises understanding. (think about that one a bit)The authors of this book tend NOT to make this error in their explanations/tutorials which makes for easy, informative reading. They are much better educators than the average techie author.
Title: A Visual Introduction to SQL
Publisher: Wiley
Authors: David Chappell, J. Harvey Trimble
Rating: 5/5
I saw this book in a bookstore and it did not look very impressive based on price to number of pages ratio but I had a look at it, and after trying to learn SQL from some other books, this was a breath of fresh air. This is a book you can blow though quickly, doesn't require access to a computer or even much knowledge of any particular relational database system. I read thorough half of it in a few hours, but by that time I had developed a working knowledge of SQL. (Without ever sitting at a computer). They use a visual technique and repetition to show exactly what the SQL commands are used for, and how to use them to get what you need from the database. It covers your plain vanilla SQL and so may be 'slightly' different in syntax from the SQL your database uses (but in my experience, the changes are very very minor (eg, Transact SQL does not require a semicolon at the end of a statement)). This is an awesome book for anyone trying to 'figure out' SQL. Really lets you s! ee what the commands do and lets you understand it. I reccomended this book to a friend trying to learn SQL and he feels the same way about the book. SQL is really a pretty simple language, and this book makes the simplicity clear. Covers all major parts of SQL queries. Select, Update, making tables, altering tables, granting permissions, etc. Everything you need to get you started. IF you are trying to understand SQL, this book belongs on your desk. It was published in 1989 I think, but dont let that deter you. It is the best intro book on SQL I have ever seen!!!

