CSS Pocket Reference (Pocket Reference (O'Reilly))

HTML Pocket Reference (2nd Edition)

Mysql And Msql

SQL Pocket Guide

Format: Paperback
Author: Jonathan Gennick
ReleaseDate: 17 April, 2006
Publisher: O'Reilly Media
Rating:

This one deserves a spot in your bag
" That's the first sentence of the introduction and is the best description I can imagine for this helpful little book. The SQL Pocket Guide: 2nd Edition "is an attempt to cram the most useful information about SQL into a pocket-size guide. The following platforms are included in this 2nd edition: Oracle Database 10g Release 2 (including Oracle Express Edition,) IBM DB2 Universal Database Release 8. 2, Microsoft SQL Server 2005, MySQL 5. 0, and PostgreSQL 8. 1.

I'm not a full-time DBA. I'm an application developer and I frequently interact with various flavors of relational databases. I confess, I don't have all the syntax memorized. That's why this little book is so helpful. The book has good coverage of DML, common SQL functions and other related topics (e. g. NULLs, CASE expressions, datatype conversions, etc. ) And, each topic is covered for each of the platforms mentioned above. It makes for an interesting comparison. The table of contents is organized nicely to allow the reader to quickly locate content by subject and there is also a detailed index in the back.

The 2nd edition of this book was published in April 2006. When you read reviews of the SQL Pocket Guide, make sure you are reading a review of the current edition. The 2nd edition has been updated for more current database releases. And, CREATE TABLE coverage and window functions have been added. Many of the changes were in direct response to feedback from the first edition.

As mentioned in other reviews, this book is not going to teach you SQL. It wasn't intended to. However, if you find that you're frequently (or even occasionally) looking up SQL syntax and if you need to create SQL statements that work with one or more of the platforms covered in this book, I highly recommend that you give this little helper a place in your bag.

SQL Pocket Guide (Paperback)
It was worth the money that I paid for it. I have used this book often since I purchased it. Very useful book because we can not keep every bit of SQL syntax on our heads. Especially for those of us that deal with different databases. I would recommend this book to my fellow Programmers/Developers. Thank you.

One flaw though
It doesn't tell you how to create tables but only how to use them. I must warn those who plan to get this little book. And a list of datatypes would have been nice. But it's ok.