| SQL Pocket Guide (Pocket References) | 
| Author: Jonathan Gennick
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $14.99
Buy New: $8.00
You Save: $6.99 (47%)
Buy New/Used from $2.23
Avg. Customer Rating:   (19 reviews)
Sales Rank: 20679
Format: Illustrated
Languages: English (Original Language), English (Unknown), English (Published)
Media: Paperback
Edition: 2
Number Of Items: 1
Pages: 192
Shipping Weight (lbs): 0.2
Dimensions (in): 6.8 x 4.1 x 0.3
ISBN: 0596526881
Dewey Decimal Number: 005.7565
EAN: 9780596526887
ASIN: 0596526881
Publication Date: August 5, 2008
Availability: Usually ships in 1-2 business days
|
| Similar Items:
|
| Editorial Reviews:
Product Description
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular "SQL Pocket Guide" is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The "SQL Pocket Guide" is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database
|
| Customer Reviews: Read 14 more reviews...
 Handy handbook November 23, 2008
This is very useful. I keep it where I can reach it on a moment's notice!
As the title indicates... a "Pocket Guide" November 19, 2008
"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! The new edition still has a very good Index, if you can't find what you're looking for on a flip-through pass.
Also new in the 2nd ed. is an extensive listing of datatypes, datatype conversions, and syntax variation for table creation and modification. This was a complaint in other reviews specific to the 1st ed., as missing. NOT SO in the new 2nd edition! PLEASE CHECK THE DATE OF THE REVIEW YOU'RE READING to ensure it pertains to the 2nd edition.
I was so impressed with this book... I actually bought TWO copies of the 2nd edition -- one for me and one for a co-worker -- AND passed my 1st edition on to another co-worker. For those "Now, how do I write that..." moments, this book can save you HOURS! I also like seeing the different examples and sample result sets for the different platforms. If the book doesn't cover what I'm looking for, I can always go to a more extensive reference book.
SQL April 2, 2008
A comprehensive and detailed SQL reference with sample code and result sets to make the content clear. An excellent pocket guide to take anywhere.
sq reference February 23, 2008
this pocket book is useful in that it touches on command sets from mysql, sql server, and also oracle. this cross platform approach is helpful when learning sql, or if one was to switch from one enterprise level system to the next. this mini book was shipped out in a timely fashion. i can say that the reference available in this book was well worth the moderate expense, as well as the shipping time.
Great reference November 12, 2007
1 out of 1 found this review helpful
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.
|
|
|
