Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

SQL Pocket Guide (Pocket Reference (O'Reilly)) 2nd Edition

4.7 out of 5 stars 25 customer reviews
ISBN-13: 978-0596526887
ISBN-10: 0596526881
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
More Buying Choices
10 New from $3.65 40 Used from $0.01

There is a newer edition of this item:

SQL Pocket Guide
$8.69
(39)
In Stock.
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
click to open popover

Editorial Reviews

About the Author

Jonathan Gennick is an O'Reilly Media, Inc. editor specializing in database and programming titles. He writes extensively on database topics, and is the author of such successful books as: Oracle SQLPlus: The Definitive Guide, Oracle SQLPlus Pocket Reference, and Oracle SQLLoader: The Definitive Guide. Jonathan contributes regularly to Oracle Magazine, and frequently explores interesting SQL topics on his own website, http://gennick.com. Jonathan is also a member of The Oak Table Network (http://www.oaktable.net), a group of Oracle experts known for their scientific approach to administering and developing Oracle based systems.Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities.In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly Media, Inc., 2001); Oracle SQLPlus Pocket Reference (O'Reilly Media, Inc., 2000); Oracle SQLPlus: The Definitive Guide (O'Reilly Media, Inc., 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly Media, Inc., 2002) and editing Practical PostgreSQL (O'Reilly Media, Inc., 2002).

NO_CONTENT_IN_FEATURE

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Series: Pocket Reference (O'Reilly)
  • Paperback: 192 pages
  • Publisher: O'Reilly Media; 2 edition (April 27, 2006)
  • Language: English
  • ISBN-10: 0596526881
  • ISBN-13: 978-0596526887
  • Product Dimensions: 4.2 x 0.5 x 7 inches
  • Shipping Weight: 6.4 ounces
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (25 customer reviews)
  • Amazon Best Sellers Rank: #1,185,040 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Jim Anderton on May 7, 2006
Format: Paperback
The SQL Pocket Guide: 2nd Edition "is an attempt to cram the most useful information about SQL into a pocket-size guide." That's the first sentence of the introduction and is the best description I can imagine for this helpful little book. 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.
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
"SQL Pocket Guide - 2nd Edition" is a short reference book for SQL DML (Data Manipulation Language), transaction control statements, datatypes, datatype conversion, table creation, and table modification. As the title indicates, this book is a "Pocket Guide" for the 4 major database platforms (Oracle, MS SQL Server, MySQL, and DB2). DO NOT EXPECT this book to be a complete reference or learning guide. Like most pocket guides, only people that already know the topic will find this text most useful. I own BOTH the 1st & 2nd editions. Due to my extensive use of the 1st edition, I purchased the 2nd edition released in 2006. This is the single most used book in my library! In fact, it is never on the book shelf! It's on my desk, in my bag, and travels with me on location. I work on a variety of database platforms with the 2 biggies being MS SQL Server & Oracle. I know the language, but at times can forget the exact syntax needed for the platform I'm working with. This book provides me with an extremely efficient way to "refresh" my memory and because it covers the 4 major platforms, I'm usually covered with this ONE small book.

The layout of the 2nd edition has been reorganized alphabetically by keyword and now covers: Oracle 10g including Oracle Express Ed, Microsoft SQL Server 2005, IBM DB2 release 8.2, MySQL 5.0, and PostgreSQL 8.1. As the layout of the 2nd edition has dramatically changed since the 1st edition and is now organized alphabetically by keyword (the keyword represented on each page is listed at the bottom of the page), you can quickly find the page you're looking for by flipping through the book and looking at the bottom right corner of the page. This is MUCH MUCH easier and faster!
Read more ›
Comment 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Quick and concise, this book never left my side for years while maintaining multiple SQL servers and their databases containing millions of records. I came in completely ignorant of what SQL was and how to use it and O'Reilly's books put me on the path to success in a new (to me) industry for YEARS. Highly recommend the O'Reilly series; They are the best.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
This is a must have for anybody who writes SQL scripts. It is extremely helpful for quickly finding those statements you don't use everyday. It has great examples, references for multiple databases, and is just an all-around great reference!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I'm writing a review because of how impressed I've become with this over time. I have several SQL references and this gets used by far the most. I'm a big O'Reilly fan and I think I bought this title in addition to the Nutshell book because it was cheap and I also wanted multiple SQL reference books so I could have some at home as well as the office.

I at first assumed that the Pocket guide would be inferior to the Nutshell book but I've found the reverse to be true for me. The strengths of this book are passages are always straight to the point, with tons of examples, and ALWAYS is very clear on relevant differences between different flavors of SQL (DB2, Oracle, SQL Server, & MySQL) without any blah blah blah.

For knuckleheads who have worked in so many languages that they can't remember any syntax anymore, and who prefer a good terse example to a big syntax tree, this reference is highly recommended.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews