SQL Pocket Guide by Jonathan Gennick is a small pocket sized guide published by O’Reilly. The book isn’t really meant to be a learning guide and more of a quick memory refresher for something not commonly used. There’s very little fluff in the this small tome on the different SQL implementations in DB2, MS SQL, MySQL and Oracle and PostgreSQL.
The amount of information in the book is very good compared to many other books of similar style. The author stays completely on task and doesn’t waste any time on cheesy jokes. CRUD, and all of the joins are well covered in the book.
The book suffers from the flaw of not usually having details on previous implementations of the different DBMS. For example, there’s a lot of legacy MS SQL stuff that isn’t always immediately deprecated in the next version which could still be useful.
Overall, the book is fairly well organized. There are some things missing that are really quite frustrating: DDL, User Permissions, etc. I use the book regularly (maybe once a week) to quickly refresh my memory on something I’ve forgotten or haven’t used regularly. I sincerely believe the book has helped me save hours of my time and be a much more efficient programmer.
- Converting Access to MySQL For a client, I took on some very old ASP code that desperately needed some TLC before […]
- Get List of Tables and Creation Date from SQL Server Getting information from the SQL Server system tables is relatively easy and can be a […]
- Book Review: Thinking in C++, Section Edition, Volume One "Thinking in C++, Section Edition, Volume One" (ISBN:978-0139798092) was written by […]
- Book Review: Magento Site Performance Optimization Magento Site Performance Optimization by Mathieu Nayrolles is a handy little primer on […]
- Book Review: Practical Salesforce.com Development Without Code
Practical Salesforce.com Development Without Code written by Phil Weinmeister has […]
- Book Review: jQuery in Action jQuery in Action, First Edition is written by Bear Bibeault and Yehuda Katz and is […]
- Book Review: Operating System Concepts Operating System Concepts, 7th Edition is written by Abraham Silberschatz, Peter Baer […]
- Book Review: Clean Code a Handbook of Software Craftsmanship I first heard of "Uncle" Bob Martin on twitter, a few of the people I was following were […]
- Book Review: Mastering Application Development with Force.com A few weeks ago, I saw a post on Twitter about Kevin Poorman releasing a new book about […]
- Book Review: Code Craft "Code Craft" (ISBN: 1-59327-119-0) was written by Pete Goodliffe. The book is relevant […]
- Book Review: Advanced Apex Programming It's no secret to those that know me that I read a lot and spend a lot of time gathering […]
- Professional PHP Design Patterns Professional PHP Design Patterns written by Aaron Saray, coming in at around 250 pages […]