Pretty much a ‘cookbook’, is why I decided to review this book, being a big fan of other O’Reilly cookbooks. I am not one to want to read up on basics when you have to skip pages and chapters. With a reference book like SQL Pocket Guide, the author does a great job with this third-edition in dividing the chapters according to function and purpose of a task, from trying to remember how to do the different types of JOINS, to DateTime conversions working with Cubes.
Jonathan Gennick doesnt waffle on, he provides a brief introduction to the function, then gives you a usage example, and usually an expected results output. This reference text is great for students or part-time developers, as well as even the more intermediary-level ones, as it provides all the chapters and content for most of the tasks one would need to do on SQL, as far as PL/SQL goes, but perhaps one would need a more vendor-specific book for vendor-specific tasks, such as when working with Oracle or MySQL. Jonathan does provide some footnotes on specific quirks that certain vendor-databases do, such as Oracle supporing some proprietary CONNECT BY syntax if it means the reader would be able to tap into doing something thats more powerful, even if it’s not applicable across all the other databases.
Overall I am happy with this book and for me the generic SQL book suffices, as I don’t tend to do many SQL administration tasks, so having access to the neat and powerful SQL Querying is good enough for me. I would certainly recommend this book to anyone who would need to work with SQL, at a casual or more regular periods.
I Rate this book: 3.0 out of 5
SQL Pocket Guide, 3rd Edition
By Jonathan Gennick
If you’re a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language’s complexity, and covers key aspects of SQL used in …
Format: Print, Ebook, Safari Books Online
Publish Date: November 2010
Other Editions: 1st Edition, 2nd Edition
This entry was posted in Book Reviews
and tagged Book Review
. Bookmark the permalink