IT programming books related reviews
Title: SQL Server 7 Developer's Guide
Publisher: Osborne Publishing
Authors: Michael Otey, Paul Conte
Rating: 5/5
There are a number of good SQL Server 7 books around, but this is one of the best. The writing is very clear and does a good job of covering the range from basics to more advanced issues. There's lots of well-written VB and T-SQL code to illustrate "best practices". It's one of the few books for developers that doesn't ignore important administrative issues, especially the difficuly security questions.I would highly recommend this as one of the "standard references" for a SQL Server developer.
Title: The Guru's Guide to Transact-SQL
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
I read all the magazines and buy all the books. This is hands down the best of them all. It taught me advanced techniques that no one else did. The explanations and the narrative are par excellence. I really love this one: "The advice I usually give people thinking about using cursors is not to." Ha Ha! The book is loaded with little gems like this. It's not just a "how-to" book, but a "why" book as well. He doesn't just tell you how to do something, he shows you, then he explains why and how it works. Great stuff. A book every T SQL developer should have.
Title: MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228)
Publisher: McGraw-Hill Osborne Media
Authors: Joyjit Mukherjee
Rating: 3/5
Considering the limited availability of MCDBA certification guides on the market, this has to be one of the better ones. The material is well layed out, and for the most part, covered in appropriate detail. However, the chapter on Replication (Chapter 13), is excessively long and could be broken up into more concise and focused chapters. Some of the exercises aren't always explained very clearly, or have too many typos, i.e. (Exercise 12-1 "Using a DTS Package to Transform Data"). Several steps for this critical exercise are missing and one needs to refer to Books Online to get the correct result. In addition, there are too many references to SQL Server 7.0 that were obviously missed during editing (particularly in Chapter 13). More hands-on exercises are needed and perhaps a greater emphasis on using T-SQL statements for performing traditional DBA tasks. However, the "Two Minute Drills" are excellent. They help test your understanding and retention of subject matter, and are good review tools. Lastly, be sure to read and follow, "Some Pointers," in the PREFACE section of the book, as this is what one needs to do to master the material, and ultimiately be successful during the 70-228 exam.
Title: Ocp: Oracle8I Dba SQL and Pl/SQL Study Guide : Exam 1Z0-001 (OCP Study Guide)
Publisher: Sybex Inc
Authors: Chip Dawes, Biju Thomas
Rating: 5/5
I just completed the exam several hours ago and failed it with a 27/59. I am making this posting so that test takers can get a range of opinions and NOT get the perception that everybody passes the exam. First, I would like to say that I studied for this exam for three days. My recommendations are to: Study this book thoroughly and not to cram for the exam. Study each chapter thoroughly and each concept thoroughly. There are over 23 different concepts that the real exam tests. The test is very broad and doesn't concentrate on any specific area - that is what makes it so hard. However, I do recommend knowing all the information in the book thoroughly before taking the exam. If I would have done so I would have done alot better on the exam. Also, I would not recommend cramming for exam.
Title: PHP by Example
Publisher: Que
Authors: Toby Butzon
Rating: 2/5
I already know Perl and C++. Learning PHP was very easy for me using this book. That being said, I don't think I would have had such an easy experience without my previous knowledge. Butzon leaves out several important concepts such as file IO and advanced searching with regular expressions. He talks nothing of modules and libraries. He seemed to write the boook with the intention of getting readers hooked on MySQL for all their database needs.PHP By Example is fine for experienced programmers to learn the basics of PHP, but I wouldn't recommend this book for anyone else.
Title: Sams Teach Yourself SQL in 24 Hours (3rd Edition)
Publisher: Sams
Authors: Ryan Stephens, Ron Plew
Rating: 3/5
The best book I have found to explain SQL to someone with no experience.It is very easy to grasp SQL using this book. Plus the format allows one to invest a little bit of time each day and make recognizable progress. In addition, if you don't have access to database software, you can still do the exercises and check your results.
Title: SQL for eServer i5 and iSeries
Publisher: Mc Press
Authors: Kevin Forsythe
Rating: 5/5
This book has two aspects. Basically it's on the SQL programming language (Yes, Martha, it's a language).
On the one hand it is aimed at the IBM i5/iSeries developers the tools they need to effectively use SQL in their applications.
On the other hand it is equally aimed at the experienced SQL programmer that is now moving to the i5/iSeries who needs to know the particular twists and kinks in the implementation as well as the tools available on the system to support development.
It's clear the future of data base interaction lies in SQL. It's also clear that without a book on the specific dialect of SQL spoken by the particular version you are running you can't write effective code. The structure of each data base engine is just a bit different. I don't believe that any of them meet the full standard.
This is a novice to Intermediate level book. It starts with the simple SELECT statement and goes through JOINS, UNIONS, Sub-Selects, enough that the user can probably do what he wants. The book spends a good bit of time on converting from the older DDS/RPG based software.
This book is an excellent start. It's hand's on enough to make sense, detailed enough to get you through the first through months of work before you're ready to tie into the details of advanced SQL -- Let alone the always coming next version.
Title: Transact-SQL Programming
Publisher: O'Reilly
Authors: Lee Gould, Andrew Zanevsky, Kevin Kline
Rating: 1/5
This book concentrates on transact sql for MS-SQL and Sybase. The book is well written and I covers a lot of ground. I bought it to write distributed stored procs. Well it gave me great examples and it also fills in the what if questions. Worth while. I keep it next to my desk.
Title: Microsoft SQL Server 7 Data Warehousing Training Kit: McSe Training for Exam 70-019 (Training Kit)
Publisher: Microsoft Pr Rating: 3/5
I have been doing Data Warehousing for about 18 months on SQL Server, primary 2000, but 7.0 is pretty much the same.The toolkit, is not the best guide out there to prepare you for the exam, but there is nothing better than hands-on preparation for the Microsoft exams.This toolkit is good to give you some very basic overviews on what Microsoft's approach to Data Warehousing is and how to approach a Data Warehouse project.Remember, for the exam, this book alone will not give you a passing score.
Title: Professional SQL Server 2000 Programming
Publisher: Wrox
Authors: Robert Vieira
Rating: 5/5
If you need to understand the FUNDAMENTALS of SQL Server 2000 then read this book. Also if you are preparing for the MCP 70-229 exam, this book is a required read. Mr. Viera has done an excellent job.

