||Author: Alex Kriegel, Boris M. Trukhnov|
List Price: $49.99
Our Price: Click to see the latest and low price
Publisher: John Wiley & Sons (01 April, 2003)
Sales Rank: 14,652
Average Customer Rating: 4.5 out of 5
Customer ReviewsRating: 5 out of 5
Excellent book to learn SQL and RDBMS concepts
I was not interested in learning just SQL per se, I also wanted to get some RDBMS experience. This is what had drawn my attention to SQL Bible: it concentrates on three major RDBMS packages (with all due respect, I can't imagine making decent living with Open Source databases like MySQL : ) ), makes comparisons, explains THEIR implementations - just what I needed (do not believe anyone who tells you that ANSI SQL is all you need to know to work in the field!) I installed DB2 Personal Edition (included with the book), and the installation was a snap! All I had to do was to follow very detailed and clear instructions in Appendix D; again, following instructions I have created a database and installed all authors scripts. The scripts were in the place where the book says they should, and I have not encountered a single problem running them... I was pleasantly surprised because this is where the most books fail: missing files, confusing "best-case-scenario" instructions... Not here! It's a shame that Oracle 9i installation was not included; I had to download it separately following instructions in the book (p.638.) Oracle 9i takes over 1.5 GB of space - 3 (!) CDs. It took me awhile, even with my cable connection speed... The only glitch I found so far was that the CD claims to contain MS SQL Server, but has DB2 8.1 for Windows instead (just as it says on the book's back cover.)
Rating: 3 out of 5
I bought this book because it was cheaper than 'SQL: The Complete Reference' and I am using it mainly as a reference tool, syntax, structure, inner/outer joins (I always forget how it works), etc.
I needed to do an Update and wanted to find out the correct structure and looked it up in the Index, which had this listing:
'updating. See modifying'
I am being picky, but I would expect the index to have an actual page reference to the Update Statement, instead of having to go to another section. I am concerned about other short comings within the book.
Rating: 5 out of 5
Great SQL book!
I picked up this book because of unparalleled comparative coverage of SQL amongst RDBMS implementations (SQL Server / DB2 / ORACLE); and I am programming for all these, plus Access and FoxPro. If you need to get up to the speed working in heterogeneous database environments - get this book!
· Microsoft SQL Server 2000 Bible with CD-ROM
· SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
· SQL in a Nutshell: A Desktop Quick Reference
· Sams Teach Yourself SQL in 10 Minutes (2nd Edition)