SQL Pocket Guide (Pocket Reference (O'Reilly))

SQL Pocket Guide (Pocket Reference (O'Reilly))
by Jonathan Gennick

SQL Pocket Guide (Pocket Reference (O'Reilly))
List Price: $14.99
Our Price: $8.00
You Save: $6.99 (47%)
Availability: Usually ships in 1-2 business days
Buy Used: from $1.34 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Jonathan Gennick
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2006-04-24
ISBN: 0596526881
Number of pages: 192
Publisher: O'Reilly Media

Book Reviews of SQL Pocket Guide (Pocket Reference (O'Reilly))

Book Review: As the title indicates... a "Pocket Guide"
Summary: 5 Stars

"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.

Summary of SQL Pocket Guide (Pocket Reference (O'Reilly))

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

Specific Databases Books

Book Subjects
Most talked about in Specific Databases Books
Navegar en Internet. Creación de un portal con PHP y MySQL. 3ª edición. ImageNavegar en Internet. Creación de un portal con PHP y MySQL. 3ª edición.
UNKNOWN; Perfect Paperback; Book
MySQL. Das Praxisbuch. ImageMySQL. Das Praxisbuch.
by Matthias Kannengiesser
Franzis; Published: 2003-06-01; Hardcover; Book
Best price: $32.33
PHP-MySQL avec Dreamweaver MX ImagePHP-MySQL avec Dreamweaver MX
by Jean-Marie Defrance
Eyrolles; Published: 2003-05-22; Paperback; Book
FileMaker Instant Web Publishing VTC Training CD ImageFileMaker Instant Web Publishing VTC Training CD
by David Wheelock
Virtual Training Company, Inc.; Published: 2007-04-04; CD-ROM; Book
Best price: $99.95
dBASE IV for Windows: A Developers Resource Book ImagedBASE IV for Windows: A Developers Resource Book
by Jack L. Hursch, Carolyn J. Hursch
Windcrest; Published: 1993-03; Paperback; Book
Price in other shops: $32.95
Head First SQL: Your Brain on SQL -- A Learner's Guide ImageHead First SQL: Your Brain on SQL -- A Learner's Guide
by Lynn Beighley
O'Reilly Media; Published: 2007-09-01; Paperback; Book
Best price: $21.99
Price in other shops: $44.99
Backup & Recovery: Inexpensive Backup Solutions for Open Systems ImageBackup & Recovery: Inexpensive Backup Solutions for Open Systems
by W. Curtis Preston
O'Reilly Media; Published: 2007-01-10; Paperback; Book
Best price: $25.55
Price in other shops: $49.99
Programming PHP ImageProgramming PHP
by Rasmus Lerdorf, Kevin Tatroe, Peter MacIntyre
O'Reilly Media; Published: 2006-05-05; Paperback; Book
Best price: $19.55
Price in other shops: $39.99
Inside the dBASE Professional Compiler ImageInside the dBASE Professional Compiler
by Tony Lima
John Wiley & Sons Inc (Computers); Published: 2000-12; Paperback; Book
Price in other shops: $32.95
dBASE IV Systems Development Handbook ImagedBASE IV Systems Development Handbook
by Beth Galdeiri
Prentice Hall Trade; Published: 1991-06; Hardcover; Book
Price in other shops: $49.95
Similar Books and other products
Python Pocket Reference: Python in Your Pocket (Pocket Reference (O'Reilly)) ImagePython Pocket Reference: Python in Your Pocket (Pocket Reference (O'Reilly))
by Mark Lutz
O'Reilly Media; Published: 2009-10-15; Paperback; Book
Best price: $8.24
Price in other shops: $14.99
C# 4.0 Pocket Reference (Pocket Reference (O'Reilly)) ImageC# 4.0 Pocket Reference (Pocket Reference (O'Reilly))
by Ben Albahari, Joseph Albahari
O'Reilly Media; Published: 2010-08-19; Paperback; Book
Best price: $8.29
Price in other shops: $14.99
Perl Pocket Reference ImagePerl Pocket Reference
by Johan Vromans
O'Reilly Media; Published: 2011-07-30; Paperback; Book
Best price: $6.75
Price in other shops: $12.99
Java Pocket Guide (Pocket Guides) ImageJava Pocket Guide (Pocket Guides)
by Robert Liguori, Patricia Liguori
O'Reilly Media; Published: 2008-03-12; Paperback; Book
Best price: $8.77
Price in other shops: $14.99
Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O'Reilly)) ImageRegular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O'Reilly))
by Tony Stubblebine
O'Reilly Media; Published: 2007-07-25; Paperback; Book
Best price: $8.49
Price in other shops: $14.99
SQL in a Nutshell (In a Nutshell (O'Reilly)) ImageSQL in a Nutshell (In a Nutshell (O'Reilly))
by Kevin Kline, Brand Hunt, Daniel Kline
O'Reilly Media; Published: 2008-12-02; Paperback; Book
Best price: $22.55
Price in other shops: $44.99
Sams Teach Yourself SQL in 10 Minutes (3rd Edition) ImageSams Teach Yourself SQL in 10 Minutes (3rd Edition)
by Ben Forta
Sams; Published: 2004-04-10; Paperback; Book
Best price: $12.58
Price in other shops: $24.99
Linux Pocket Guide ImageLinux Pocket Guide
by Daniel J. Barrett
O'Reilly Media; Published: 2004-03-01; Paperback; Book
Best price: $5.40
Price in other shops: $9.95
Learning SQL ImageLearning SQL
by Alan Beaulieu
O'Reilly Media; Published: 2009-04-27; Paperback; Book
Best price: $22.35
Price in other shops: $39.99
SQL Cookbook (Cookbooks (O'Reilly)) ImageSQL Cookbook (Cookbooks (O'Reilly))
by Anthony Molinaro
O'Reilly Media; Published: 2005-12-23; Paperback; Book
Best price: $21.99
Price in other shops: $39.95
Book store. Illustrated catalog of books on different categories