SQL Pocket Guide, Second Edition 50
Graeme Williams writes "So many dimensions are folded into this compact book that it took me more than a few moments to see what I was looking at. In the space of 184 pages, SQL Pocket Guide, Second Edition documents, explains, illustrates and compares the most common SQL statements from Oracle (10g), DB2 (8.2), SQL Server (2005), MySQL (5.0) and PostgreSQL (8.1), with occasional notes on previous versions, and pointers to more material on the author's web site. The book bills itself as "A Guide to SQL Usage" and it has an ample amount of explanatory material in addition to syntax and examples." Read the rest of Graeme's review.
| SQL Pocket Guide, Second Edition | |
| author | Jonathan Gennick |
| pages | viii + 184 |
| publisher | O'Reilly Media |
| rating | 10 |
| reviewer | Graeme Williams |
| ISBN | 0-596-52688-1 |
| summary | A clear and compact overview of SQL for five different databases |
The second edition of SQL Pocket Guide has been updated for the latest versions of the four databases covered in the first edition, and PostgreSQL has been added. There are also new sections on datatypes and creating tables and indexes. O'Reilly has recently announced that all of their pocket guides and references will be available as PDFs. This review is based on the paper book.
In addition to the most common SQL statements, SQL Pocket Guide, Second Edition also describes many useful functions, including datatype conversions, date/time, math, trig and string functions, and handling nulls. The table of contents for the book provides an excellent idea of what is included. One note about the table of contents: sometimes differences in syntax between different databases are covered inline, and sometimes each database is covered in a separate subsection. The table of contents makes the two types of coverage clear, since a subsection for a particular database is indicated by the database name in parentheses, such as "Numeric Conversions (Oracle)".
Rather than give formal syntax specifications, Gennick gives examples for each statement and function that he explains. The neat thing is that all the examples run against a simple schema and data which you can download from the book's web page. And yes, the data comes in five flavors to match the five databases covered by the book. You shouldn't underestimate how much this buys you in maintaining the book's high information density. It means that the SQL examples can be presented, and make sense with, little or no lead in.
Gennick also includes some pointers to the material on his web site. If you regularly lose bar bets on the details of recursive queries, or you need more explanation than the book provides, this will be very useful.
SQL Pocket Guide is organized alphabetically by topic, such as "Selecting Data", "Subqueries" or "Tables, Creating". Each topic is divided into a number of sections, such as SELECT, FROM and WHERE and again into subsections, such as specifying a table alias in the FROM clause. I like the size of the book (4 1/4 in. by 7 in.). The fact that the pages are pretty small, however, means that two facing pages might only contain a few subsections without any indication of the section they belong to. This can make it hard to keep track of context while flipping through pages. It's needlessly hard to distinguish between topic, section and subsection headings because they're all in the same font, and only a point or two different in size. There ought to be some simple way to indicate the difference.
I don't mean to suggest that the book is impenetrable. The table of contents includes both topic and section headings, and it's easy to skim to find what you're looking for. The topic is given at the bottom of every right-hand page. It would be great if the section was given at the bottom of every left-hand page, which is presently wasted by repeating the book title.
SQL Pocket Guide is small and clear. If you're looking for a book that is small, clear and complete, I'm sorry, that book doesn't exist. I'm guessing that you can't even get clear and complete. As a comparison, I took a look at an Oracle 9i reference. The whole book is over 1200 pages – the reference section, the section that is comparable in style and content to SQL Pocket Guide, is over 350 pages. The syntax diagram for the SELECT statement is terrifying just on its own.
From this syntax diagram, I discovered that Oracle has a "flashback" feature, which under certain circumstances allows you to look at the database as it was at a time in the recent past: SELECT * from EMPLOYEES AS OF (some time in the past) The problem is that the chapter on flashback queries doesn't discuss this particular syntax – here, you're on your own. As you might expect, a 1200 page book isn't an ideal learning tool, but it's not a perfect reference either. On the other hand, SQL Pocket Guide doesn't cover flashback queries at all.
SQL Pocket Guide doesn't contain every single thing anyone will ever need to know about any of the five covered databases. Different people will find different gaps in what's included. The book doesn't include creating views, which I would have found useful. Also, I recently found myself with an SQL Server table so gnarly that I used two nested unpivot statements to unwind it, but unpivot, which is new in SQL Server 2005, isn't included in the book either. The book deserves its rating, however, because it's nearly perfect for its size.
In giving up completeness, Gennick hasn't just produced a book with fewer pages, he's produced a book that works either for learning or reference. Reading the book cover to cover is a rapid and effective way to get up to speed on a particular database. This is true if you are vaguely familiar with SQL and need specific details, or if you're intimately familiar with one database but moving to another. Unless or until you've committed the details of each SQL statement to memory, this book will be the best fifteen dollars you'll spend.
You can purchase SQL Pocket Guide, Second Edition from bn.com. Slashdot welcomes readers' book reviews -- to see your own review here, read the book review guidelines, then visit the submission page.
Update on the link (Score:2, Informative)
Re:Worth buying (Score:3, Informative)
SQLite? (Score:3, Informative)
Re:Why put it all in one book? (Score:3, Informative)
If you're going to carry it in your pocket, why not have points of perspective?
Like it or not, if you are supporting or developing for applications in an enterprise or corporate environment, it doesn't take more than two or three projects to span more than one RDMS - not to mention versions. Statements to Oracle 7 can have different results from Oracle 9, from MySQL, from Postgres...
--
Re:standards compliance? (Score:2, Informative)
The book isn't about the different database products as it is about SQL in general, so it's not really divided into sections by database (oracle vs db2, etc.). As you say, the majority of SQL is the same between various db's. The first edition documents SQL in general and only footnotes product differences when and where they exist. Most of its content is assumed to apply to all of the products and a lot of the actual differences are only noted parenthetically.
Re:Nerdbooks (Score:3, Informative)
They ship to the good ol USA only...
Re:Yep, it's a nice book. (Score:2, Informative)
I truly, truly, am trying to get all those URLs back in working order. Some articles I've gotten back up. Others not. I always seem to be behind the eight-ball when it comes to getting work done though. Even tonight I'm working late on my day-job.
Heh. Had I known I was going to get Slashdotted, I might have pulled a few all-nighters to get all my articles back up on my site
BTW, I didn't just change the structure of my site. I installed Drupal. It was clear to me that my own web development skills basically suck. Drupal, on the other hand, is a well-done content manager. In the end, I think my site will be better running on Drupal than on my own, hacked up HTML.
Re:If only there was a section on Error codes... (Score:4, Informative)
MySQL 4.1, 5.0, 5.1 & PostgreSQL 8.1.4 version (Score:3, Informative)
Enjoy, and let me know if there's anything else we can do.
(don't forget to check out the other things we've created for you over here [nyud.net])