Review of SQL Pocket Guide

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

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 Edition2nd Edition


Advertisements
This entry was posted in Book Reviews, General and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s