kognosko
Price: �26.27
In stock

Add to Cart

woodys-uk
Price: �49.89
In stock

Add to Cart

11 used & new from �9.95

See All Buying Options

Have one to sell? Sell yours here

Share your own customer images

Search inside another edition of this book

SQL Pocket Guide (Pocket Reference) (Paperback)

by Jonathan Gennick (Author)

3.7 out of 5 stars See all reviews (3 customer reviews)

Available from these sellers.

5 new from �13.95 6 used from �9.95

Other Editions:	RRP:	Our Price:	Other Offers:
Paperback (2)			14 used & new from �6.77

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Mysql opens new browser window

www.mysql.com - See the demos on MySQL Workbench: MySQL Visual Modeling Tool

Download My SQL GUI tool opens new browser window

www.Navicat.com/MySQL - Develop and manage your My SQL Free. Easy to use. Download Now!

Tutorial Sqlserver opens new browser window

www.stylusstudio.com/SQL-Server/ - Edit & Debug SQL Server Programs Easy to Use, Download a Free Trial

Customers Who Bought This Item Also Bought

HTML and XHTML Pocket Reference (Pocket Reference (O'Reilly))

by Jennifer Niederst Robbins

4.7 out of 5 stars (3) �5.50

JavaScript Pocket Reference (Pocket Reference (O'Reilly))

by David Flanagan

3.8 out of 5 stars (10) �4.62

CSS Pocket Reference: Visual Presentation for the Web (Pocket Reference (O'Reilly))

by Eric Meyer

4.0 out of 5 stars (3) �4.79

Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O'Reilly))

by Tony Stubblebine

4.3 out of 5 stars (7) �6.48

VBScript Pocket Reference

by Paul Lomax

4.4 out of 5 stars (8) �4.58

› Explore similar items

Product details

Paperback: 154 pages
Publisher: O'Reilly Media, Inc. (29 Mar 2004)
Language English
ISBN-10: 0596005121
ISBN-13: 978-0596005122
Product Dimensions: 18.5 x 10.9 x 1.1 cm

Average Customer Review: 3.7 out of 5 stars See all reviews (3 customer reviews)

Amazon.co.uk Sales Rank: 377,634 in Books (See Bestsellers in Books)
Popular in these categories:
#30 in Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
#54 in Books > Computing & Internet > Databases > SQL

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include:

Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.
Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.

"If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book." --Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com

From the Publisher

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. --This text refers to an out of print or unavailable edition of this title.

See all Product Description

Inside This Book (Learn More)
Browse and search another edition of this book.

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

sql

pocket reference - oreilly

database

book - computer - database

What Do Customers Ultimately Buy After Viewing This Item?

	23% buy Sams Teach Yourself SQL in 10 Minutes 4.2 out of 5 stars (35) �5.47
	21% buy Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O'Reilly)) 4.3 out of 5 stars (7) �6.48
	20% buy SQL Cookbook (Cookbooks (O'Reilly)) 5.0 out of 5 stars (1) �18.08
	18% buy JavaScript Pocket Reference (Pocket Reference (O'Reilly)) 3.8 out of 5 stars (10) �4.62

Explore similar items

Customer Reviews

3 Reviews

5 star:		(1)
4 star:		(0)
3 star:		(2)
2 star:		(0)
1 star:		(0)

Average Customer Review

3.7 out of 5 stars (3 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

15 of 16 people found the following review helpful:

3.0 out of 5 stars Not quite there, 6 Jul 2004

By	Kelly P. Vincent (State College, PA USA) - See all my reviews (REAL NAME)

I expected a bit more from this book. Although naturally a small book "pocket guide" can't include everything you want, I think that this guide is a bit inconsistent in the things that it does include. I am still learning SQL, and basically needed something that would remind me of the syntax to use. I know what I need to do (like create a table, work with dates, and so on), and I just need help phrasing it right. Often this book does come through for me, but other times it does not. For instance, I found good information about updating and inserting rows. But the only explanation of creating a table is not very general - it specifically touches on how to handle field names with spaces and other unusual characters when creating tables. So it may be that this book is more useful for someone who already knows quite a bit about SQl, and just needs something to jog their mind. But if that is the case, it seems strange that so many very basic things really are included. I'm not sure who the intended audience really is, as this book is not successful in trying to be all things to all readers...

One of the nice things about the book is that it includes MySQL in this edition. Apparently, previous editions did not. It does seem to do a good job of addressing the different versions of SQL that people might be using. For instance, in an example where they were discussing the use of double quotes on field names, they mention that this doesn't work in MySQl. Some sections of the book are further broken down in subsections like "Oracle", "MySQL", and so on. The other two platforms that are dealt with are microsoft SQL Server and IBM DB2.

Clearly, this book is better than nothing. And in my case, since I didn't want to spend the money or have to lug around another heavy book, it is also better than some of the bigger, genuinely better books. It certainly is relatively inexpensive, so there's a good chance you still might find it useful. Just don't expect it to answer all your SQL needs, however basic they seem.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

2 of 2 people found the following review helpful:

3.0 out of 5 stars Quick reference for SQL data manipulation language, 22 Feb 2006

By	S. Cook (Berkshire, UK) - See all my reviews (REAL NAME)

This book is useful as far as it goes, which is to provide a summary of the "data manipulation language" part of SQL, with details of variations between the main RDBMS vendors. I expected that it would also cover the "data definition language" part of SQL, i.e. creating tables, indexes, etc. It doesn't and that's a disappointment (but it does keep the book pocket-sized).

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

0 of 1 people found the following review helpful:

5.0 out of 5 stars Wouldn't be without, 13 Aug 2005

By	S. Clements-hawes "psymonj" (Truro, UK) - See all my reviews (REAL NAME)

I can't praise this series enough.

They sit very comfortably into the pocket, backpack - everywhere I go.

I have started to build the range of relevant books to my encounters (HTML, SQL, PHP, Action Script, CSS - highly recommended and Linux).

A fantastic reference guid with general usage tips and hints.

If you work with this kind of thing on any level, using these books are a god-send!

O'Reilly reference guides really are worth their weight in gold.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 3 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }