IT programming books related reviews
Title: The Guru's Guide to Transact-SQL
Publisher: Addison-Wesley Professional
Authors: Ken Henderson
Rating: 5/5
I buy just about every book published on SQL Server. This is by far the best of them all. The clarity of the text, the goodies in the code (600 samples!), and the overall quality make this a must have for any serious SQL Server DBA, programmer, or architect.
Title:
Publisher: Rating: 1/5
I've found this book an invaluable aid to learning PL/SQL. I recommend you buy this book in conjunction with George Koch's Oracle 8 The Complete Reference because Urman covers PL/SQL in more detail and Koch's book has a very good Alphabetical Reference but lacks detail in the PL/SQL stuff.
Title: Oracle PL/SQL: The Complete Video Course
Publisher: Prentice Hall PTR
Authors: Elena Silvestrova, Benjamin Rosenzweig, Ben Rosenzweig
Rating: 4/5
Both this book and the similiar Oracle DBA book are magnificent. Each in their subject area is the most effective training books I've ever used, and I've had to read WAY too many in my career. The PL/SQL book gives superb examples- each example is a complete runnable block, not an excerpted fragment. So you don't have to flip all over the place to understand how the statements work together ot to test it out yourself. The book's diagrams are also very good. The explanation text is lucid and well organized. I really dont see how the books could be much better unless they could do a Vulcan Mind Meld!
The video on the other hand is quite disappointing, really almost useless. I had real difficulty understanding the instructor. The pronunciation and mangling of english constructs results in a presentation that is very difficult to follow - especially considering you are trying to learn a difficult and complex technical subject. Buy the book (seperately), and you will have the best tool for learning PL/SQL short of a personal tutor. Makes the Complete Reference series seem like random monkey typing!
Title: Oracle 9i : SQL Exam Cram 2 (Exam Cram 1Z0-007)
Publisher: Que
Authors: Gavin Powell
Rating: 5/5
As an experienced DBA, I found this book clear and concise. I especially like the accompanying CD with a PDF version of the entire book. I prefer to use an electronic search to find a page in a book, so this really is a bonus to me. The tests in the book and on the CD provide useful, informative explanations for all test questions -- one of the best ways I know to get prepared for the Oracle exams. I have taken the Intro to SQL exam for Oracle9i certification, and this book really does cover the contents of that exam thoroughly. It is an excellent study companion.
Title: The Practical SQL Handbook: Using Structured Query Language (3rd Edition)
Publisher: Pearson Education
Authors: Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Rating: 5/5
I've been using different dialects of SQL for about 6 years now and I've found this book to be a very good resource. If you use SQL enough, you will probably eventually want to get a more advanced book (such as one by Celko), but this book will take you far. It starts off with basic information on relational databases, ER diagrams, and normalization, and, maybe best of all, throughout the book are numerous and clear examples. It pretty much uses one example database for most examples, and it explains the layout of that database at the start. Also, the book is very good about showing where certain details differ between SQL-92 and popular SQL implementations, such as SQL Server (Sybase and Microsoft), SQL Anywhere, Informix, and Oracle PL/SQL. The examples very carefully and very clearly step through potentially confusing areas such as subqueries and existence checking. The emphasis throughout is on - as stated in the title - practical SQL. In summary, I think this book is an excellent learning tool and a good desktop reference.
Title: The Essence of SQL : A Guide to Learning Most of SQL in the Least Amount of Time
Publisher: Coriolis Group Books
Authors: David Rozenshtein
Rating: 5/5
The book is good. It teaches essential and good SQL skill, and provides a good understanding.
Title: OCA/OCP: Introduction to Oracle9i SQL Study Guide
Publisher: Sybex
Authors: Chip Dawes, Biju Thomas, Chip Dawes, Biju Thomas
Rating: 5/5
Just passed the 1Z0-007 on my first attempt with flying colors. This book is really great at showing the concepts addressed in the exam. Make sure to do all the practice tests.I also bought the online exam from www.selftestsoftware.com which
is much harder than the real test and helps show you where your weaknesses are.
Title: Macromedia Dreamweaver MX 2004 with ASP, ColdFusion, and PHP : Training from the Source
Publisher: Macromedia Press
Authors: Jeffrey Bardzell
Rating: 5/5
If you use Dreamweaver, & want to know "exactly" what to do to set up a database on your website, and ASP, buy this book!!!
Title: Sams Teach Yourself SQL Server 7 in 24 Hours (Teach Yourself -- Hours)
Publisher: Sams
Authors: Matthew Shepker
Rating: 2/5
My favorite error is, referring to IF...ELSE statements on p329, "If you do not include an ELSE statement, SQL Server will simply skip the code after the ELSE statement and continue on". Hmmm?, I thought the ELSE statement wasn't included?Of course I also liked the authors fine use of COPY/PASTE; the 1 page+ long list of Stored Procedure Options/Description which are duplicated exactly within the same chapter [on Stored Procedures] a few pages apart (p311 & p319). Once for creating a new SP, and again for modifying one. THE TEXT IS AN EXACT COPY. Geeze, what a waste of paper! Next time try "See figure 123".But once I got beyond the poor logic, poor editing, poor proof reading, and typos, to the authors credit, I did find the book useful. It's certainly for beginners, and as such it reads at that level. Very easy. I also found the examples to be very useful. Something IMHO I find lacking in other "beginner" books.Would I recommend it? Well, I'd have a hard time doing so considering all the blunders. Would I recommend the Second Edition (if it ever came out)? Yes. I think it would be very helpful.Tim <><
Title: Professional Oracle 8i Application Programming with Java, PL/SQL and XML
Publisher: Wrox Press
Authors: Michael Awai, Matthew Bortniker, John Carnell, Kelly Cox, Daniel O'Connor, Mario Zucca, Sean Dillon, Thomas Kyte, Ann Horton, Frank Hubeny, Glenn E. Mitchell II, Kevin Mukhar, Gary Nicol, Guy Ruth Hammond
Rating: 5/5
There has never been a Oracle book like this one that demostrates so much detail about Oracle 8i internet development feature with Java and XML. If you want to stay ahead of your peer, you can't afford to miss this book.

