Most helpful positive review
28 of 28 people found the following review helpful
Complete, thorough, easily digestible
on March 3, 2011
Rockoff gives the lowdown on SQL slowly and patiently, but not too much so.
In little embedded sections, functionally like sidebars, he details the minor differences in the three SQL dialects: Microsoft SQL Server, Oracle SQL, and the free open-source MySQL. Each chapter begins with an explanation of the material to be presented, and ends with a summary of what was covered and a preview of the following chapter. (the classic "tell them what you're gonna tell them, tell them, and then tell them what you told them" !) Sounds tiresome but it isn't really, since he phrases it with a little different emphasis each time, which I find greatly aids comprehension.
He gives tips and pointers on what he believes are the best ways to accomplish things in SQL. To perform most tasks in SQL there are usually several methods available; Rockoff points out the pros and cons of each of them. He also delineates how the various SQL commands relate to and complement one another.
The book is written with plenty of specific coding examples; as in the book's description on Amazon, it is written so that it can be comprehended without having to practice SQL at a computer. Everything needed is between the covers, except for detailed descriptions of all the available functions. For that, Rockoff directs the reader to his website and other documentation on the web.
(postscript) Please note this is an introductory text. Some of the "advanced" SQL features are neglected, but the one covered are plenty enough to serve the book's purpose.