Please Sign Up to Request This Product

SQL Pocket Guide

You need to be an approved reviewer to request a product. Please sign up to request access or login to your account.

If you've already signed up and you haven't heard from us yet please email reviewers\@oreilly.com and we will check on your request.

Description

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 Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax.

Reviews

On Jun 6 Thomas Harning wrote: Review of "SQL Pocket Guide" by Jonathan Gennick
The complexity of developing database queries with SQL is a challenge often requiring frequent documentation searches. The "SQL Pocket Guide" by Jonathan Gennick is a great converged reference for many common database implementation. The best feature of this guide is its breadth of detail offered. Full Review  >

Rating: StarStarStarStarStar4.0

On May 11 Susan Murphy wrote: SQL Pocket Guide
Is just as it states a pocket guide. The content of the book is setup in a way that it is easy to find what you are looking for. It gives you examples in Oracle, DB2, PostgreSQL, SQL Server and MySQL. It is a helpfull tool to give you the syntax you are looking for. The guide is a good tool to have handy for those times you just can’t remember how to do something. Full Review  >

Rating: StarStarStarStarStar3.0

On Mar 21 William Rouck wrote: Review of SQL Pocket Guide, authored by by Jonathan Gennick
SQL Pocket Guide is a very sensible deskside reference for developers and database administrators. If you are experienced in SQL and can use occasional refreshers on commands and syntax, this is the perfect helper book for you. Full Review  >

Rating: StarStarStarStarStar5.0

On Feb 21 Gabriel Villa wrote: SQL Pocket Guide by Jonathan Gennick
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… Full Review  >

Rating: StarStarStarStarStar4.0

On Feb 20 George Sawyer wrote: SQL Pocket Guide by Jonathan Gennick – Review
The SQL Pocket Guide (3rd edition) by Jonathan Gennick (O'Reilly, 2010) is a must have for the database butterfly. I move among several DBMS on an almost daily basis. Full Review  >

Rating: StarStarStarStarStar4.0

On Feb 18 John Brady wrote: SQL Pocket Guide 3rd Edition
The SQL Pocket Guide, 3rd Edition is a book that would be most useful to  SQL users who need to work in multiple database environments and do not have an internet connection available  when creating queries.  It’s well-organized by topic and provides working examples where relevant, but I don’t see… Full Review  >

Rating: StarStarStarStarStar3.0

On Feb 15 Joshua Hunter wrote: Review: SQL Pocket Guide by Jonathan Gennick
SQL Pocket Guide is exactly that, a small guide to most things SQL. You won’t find a lot of background or extraneous content. Instead you’ll get good examples of SQL syntax for nearly every SQL command supported by PostgreSQL, MySQL, Oracle, DB2 and Microsoft SQL Server. I’ve been using this… Full Review  >

Rating: StarStarStarStarStar4.0

On Feb 11 Marc 137 wrote: SQL Pocket Guide Third Ed. by Jonathan Gennick
As always, these books are not for learning SQL, just reminders of the syntax. If you are a guru of databases, this book can certainly be helpful to reach but almost certainly will be a bit corto.En But for people who program in other languages and only occasionally fight with databases, is fundamental. Full Review  >

Rating: StarStarStarStarStar5.0

On Feb 6 Doron Katz wrote: Excellent How-to-do Cookbook
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. Full Review  >

Rating: StarStarStarStarStar4.0

On Feb 6 Moshe Eshel wrote: Book Review: SQL Pocket Guide, Third Edition By Jonathan Gennick
This is my first book review for the O'reilly Blogger Review Program, I read this book on my Amazon Kindle 3 - a great experience in itself. A great resource for starting and experienced SQL programmers alike, this book is indeed what it claims to be - a pocket guide for SQL. It is highly informative and covers a lot of ground in a concise and readable manner. Full Review  >

Rating: StarStarStarStarStar4.0

Receive free ebooks and videos in exchange for your reviews.

Join the O'Reilly Reader Review Program

Learn more >

Returning?

Top Reviewers

Michal Konrad Owsiak, 82 Reviews

Shawn Day, 55 Reviews

Santosh Shanbhag, 52 Reviews

Doron Katz, 50 Reviews

Juan Jose de Leon, 49 Reviews

See More Reviewers >

Featured Review

Functional Thinking

Jim Schubert wrote:
Functional Thinking is... functional
I especially enjoyed Neal's discussion about the paradigm shift from object-oriented programming to more functional… Full Review >

Rating: StarStarStarStarStar5.0