Jonathan Gennick is an SQL aficionado who writes extensively on the SQL language and other database topics. He is the author of several books, and also a number of articles in Oracle Magazine. He is currently a book editor focusing on database titles, primarily involving Oracle and SQL Server.
SQL Pocket Guideby 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. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008
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. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.
SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.
All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:
- Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
- Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
- PostgreSQL’s support of recursive WITH and some window functions
- DB2 syntax and datatypes, some compatible with Oracle
- MySQL features such as the TIMESTAMP type and the TO_SECONDS function
- O'Reilly Media, Incorporated
- Publication date:
- Edition description:
- Third Edition
- Sales rank:
- Product dimensions:
- 4.30(w) x 6.90(h) x 0.60(d)
Meet the Author
Most Helpful Customer Reviews
See all customer reviews
Jonathan Gennick's SQL Pocket Guide is a seamless guide any Database Admin or developer, expert or beginner alike, should have in their IT toolbox. I recall when I was in the university; I picked up a "learn SQL in 24 hours" book as a supplementary to our curriculum book. Had I had this pocket guide then, I would have most certainly struggled less. Most recently I been developing .Net applications to a Pervasive SQL Database, and even with years of Microsoft SQL Server experience, this reference book has been on my side. SQL is a platform independent database language, this guide will provide guidance and examples for Oracle, DB2, SQL Server, MySQL and PostgreSQL. You can also download code sample for all the mentioned platforms. Moreover, the organization of the book will indicate platform specifics, for instance, Data types spans several pages to distinguish between the various database platforms. The book is structured in alphabetical order by commands, this makes it easier for when you know you want to write a UNION but don't remember the syntax, you're sure to find it towards the end of the book. At times it may seem there are superfluous references to databases you don't work with, nonetheless, it is a Pocket Book primarily for reference and I won't hesitate in recommending it.
This is a great quick reference. I like that it distinguishes which platform the various sql will work with. The book does not bog down with extreme examples. This book is not a training book. This does a nice job of covering common basic sql.