See buying choices for this item to see if it's one of the millions that are eligible for Amazon Prime.

Ready to Buy?
woodys-uk
Price: £35.68
In stock
7 used & new from £5.00
See All Buying Options
Have one to sell? Sell yours here
 
   
SQL Pocket Guide (Pocket Reference)
 
 
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 £6.95 2 used from £5.00
Other Editions: RRP: Our Price: Other Offers:
Paperback (2) 12 used & new from £4.81

Customers Who Bought This Item Also Bought

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

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

by Jennifer Niederst Robbins
4.5 out of 5 stars (2)  £6.49
Linux Pocket Guide (Pocket Guide: Essential Commands)

Linux Pocket Guide (Pocket Guide: Essential Commands)

by Daniel Barrett
5.0 out of 5 stars (8)  £5.99
JavaScript Pocket Reference (Pocket Reference (O'Reilly))

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

by David Flanagan
3.8 out of 5 stars (10)  £5.63
Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O'Reilly))

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)  £7.48
CSS Pocket Reference: Visual Presentation for the Web (Pocket Reference (O'Reilly))

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

by Eric Meyer
3.0 out of 5 stars (1)  £5.39
› Explore similar items

Product details

  • Paperback: 160 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: 302,971 in Books (See Bestsellers in Books)

    Popular in these categories:

    #35 in  Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
    #63 in  Books > Computing & Internet > Databases > SQL

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

  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Open Source DBMS
   www.EnterpriseDB.com    Free white paper comparing the leading open source databases. 
SQL CE Database Viewer
   www.FlyHoward.com    Create, Edit, Query, Script on a PC SQLCE version 3.1 and 3.5 
Download My SQL GUI tool
   www.Navicat.com/MySQL    Develop and manage your My SQL Free. Easy to use. Download Now! 
  
 

Product Description

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.
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside 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)
Check a corresponding box or enter your own tags in the field below
sql
pocket reference - oreilly
database
book - computer - database

Your tags: Add your first tag
 
See most popular tags
 

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:
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
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
 
 
 
Only search this product's reviews


Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   

Listmania!

Create a Listmania! list

Look for similar items by category

Feedback

The Body Shop

The Body Shop - Vitamin C Skin Boost
Protect and boost your glow with The Body Shop Vitamin C Skin Boost.

›Shop The Body Shop

  

More From Jonathan Gennick

Oracle SQL*Plus...

Oracle SQL*Plus Pocket Reference

This small slim volume is a concise guide to using Oracle's SQL*Plus... Read more
£7.50 £5.63

 

A Close Shave

Philips Nivea Coolskin HS8060 Moisturizing Rotary Shaving System
For all types of hair removal, stay smooth with Amazon.co.uk.

›Discover Shaving & Hair Removal

  

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

  
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue Shopping: Top Sellers
The Girl Who Played with Fire
The Girl Who Played with Fire by Stieg Larsson
4.5 out of 5 stars (75)£3.86
 Breaking Dawn (Twilight Saga)
Breaking Dawn (Twilight Saga) by Stephenie Meyer
4.1 out of 5 stars (464)£6.49
 The Girl with the Dragon Tattoo
The Girl with the Dragon Tattoo by Stieg Larsson
4.1 out of 5 stars (165)£3.99
 The Host
The Host by Stephenie Meyer
4.2 out of 5 stars (84)£3.86

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates