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.
Prior Knowledge: PL/SQL
My rating :[rating=3.0]
Author: Jonathan Gennick
Publisher: O'Reilly Media
Year: November 2010