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

19 used & new from £1.23

Have one to sell? Sell yours here
 
   
SQL in a Nutshell: A Desktop Quick Reference (In a Nutshell (O'Reilly))
 
 

SQL in a Nutshell: A Desktop Quick Reference (In a Nutshell (O'Reilly)) (Paperback)

by Kevin Kline (Author), Daniel Kline (Author)
3.5 out of 5 stars See all reviews (6 customer reviews)

Available from these sellers.


4 new from £19.98 13 used from £1.23 2 collectible from £900.00
Other Editions: RRP: Our Price: Other Offers:
Hardcover Order it used
Paperback (3) £31.99 £22.43 35 used & new from £17.85

Customers Who Bought This Item Also Bought

SQL Cookbook (Cookbooks (O'Reilly))

SQL Cookbook (Cookbooks (O'Reilly))

by Anthony Molinaro
5.0 out of 5 stars (1)  £20.14
Learning SQL

Learning SQL

by Alan Beaulieu
5.0 out of 5 stars (2)  £24.29
Unix in a Nutshell (In a Nutshell (O'Reilly))

Unix in a Nutshell (In a Nutshell (O'Reilly))

by Arnold Robbins
4.9 out of 5 stars (14)  £20.49
Sams Teach Yourself SQL in 10 Minutes

Sams Teach Yourself SQL in 10 Minutes

by Ben Forta
4.2 out of 5 stars (34)  £7.14
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
Explore similar items

Product details

  • Paperback: 224 pages
  • Publisher: O'Reilly Media, Inc, USA (9 Jan 2001)
  • Language English
  • ISBN-10: 1565927443
  • ISBN-13: 978-1565927445
  • Product Dimensions: 22.7 x 15.2 x 1.4 cm
  • Average Customer Review: 3.5 out of 5 stars See all reviews (6 customer reviews)
  • Amazon.co.uk Sales Rank: 593,497 in Books (See Bestsellers in Books)

    Popular in this category:

    #54 in  Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
  • See Complete Table of Contents

Product Description

Amazon.co.uk Review
SQL in a Nutshell applies the classic O'Reilly Nutshell format to Structured Query Language (SQL), the elegant descriptive language that's used to create and manipulate stores of data. This book explains the purpose and proper syntax of hundreds of SQL statements as defined in four major SQL implementations, detailing each entry with explanatory text and illustrative examples. Perhaps best of all, authors Kevin and Daniel Kline feature MySQL in their coverage, giving it billing equal to that of Oracle, Microsoft SQL Server, and PostgreSQL. Their inclusion of open-source MySQL, which carries no license fee in most situations, is recognition of its growing popularity and suitability for serious database applications. It also improves this book's appeal to Unix and Linux developers.

The majority of this slender book comprises eminently useful syntax documentation (which is in the style of Unix man pages, with bracketed options and monospace arguments) and the other information that's specific to individual statements and functions. Additionally, it includes a relatively small amount of conceptual information, such as a section on the proper use of NULL values. The material that's not statement-specific also contrasts the four covered platforms' implementations of datatypes--readers learn that a PostgreSQL int2 value is known as a "smallint" in ANSI standard SQL, for example. This is a handy reference book, particularly if you use one of the emphasised SQL implementations. --David Wall

Topics covered: Structured Query Language (SQL) as it is implemented in Oracle, Microsoft SQL Server, MySQL and PostgreSQL, as well as in ANSI standard SQL (SQL92 and SQL99). After an introduction to datatypes and relational database fundamentals (the latter is not emphasised), the authors document SQL statements and functions one by one, alphabetically. They take care to point out differences among the four implementations.

Major Keary, PC Update March 2002
An invaluable desktop reference for those who deal with SQL at a professional level. Compact and well designed.

See all Product Description


Inside This Book (Learn More)
Browse and search another edition of this book.
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
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
database
sql

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

SQL in a Nutshell: A Desktop Quick Reference (In a Nutshell (O'Reilly))
37% buy the item featured on this page:
SQL in a Nutshell: A Desktop Quick Reference (In a Nutshell (O'Reilly)) 3.5 out of 5 stars (6)
Learning SQL
29% buy
Learning SQL 5.0 out of 5 stars (2)
£24.29
SQL Cookbook (Cookbooks (O'Reilly))
19% buy
SQL Cookbook (Cookbooks (O'Reilly)) 5.0 out of 5 stars (1)
£20.14
Sams Teach Yourself SQL in 10 Minutes
10% buy
Sams Teach Yourself SQL in 10 Minutes 4.2 out of 5 stars (34)
£7.14

 

Customer Reviews

6 Reviews
5 star:
 (2)
4 star:
 (1)
3 star:
 (1)
2 star:
 (2)
1 star:    (0)
 
 
 
 
 
Average Customer Review
3.5 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
7 of 7 people found the following review helpful:
2.0 out of 5 stars Disappointing, but still a useful book, 19 Jul 2001
By A Customer
I had hoped that this would be a concise but complete reference on building SQL statements, but it lacks some of the most basic explanations (try looking up UNION queries in the index - it's not there!!!). Disappointing, considering the many other 'In A Nutshell' series books I have are indespensible. This one reads more like a 'white paper' than a user reference book. Expensive too, considering how thin it is.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
6 of 6 people found the following review helpful:
4.0 out of 5 stars Good SQL reference book., 29 Aug 2002
By Mr. C. J. Lee "cjlee23" (London, UK) - See all my reviews
(REAL NAME)      
It is definitely not a book to learn SQL, however I found it useful as a reference point to translate a particular flavour of SQL into another flavour of SQL.

Let's face it, just from the size of the book, we can quickly establish that it won't get into too much detail, but it is great for quickly looking up syntax if you can't quite pin point it in your mind.

Not ideal for beginners.

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



 
5 of 6 people found the following review helpful:
3.0 out of 5 stars Too much detail on too few subjects, 10 Jun 2001
By Mr. G. P. Nottage "eylant" (Surrey, UK) - See all my reviews
(REAL NAME)   
I was looking for a refernce book to tell me how to do things with SQL (in particular MySQL). Something I could turn to to find the right command or structure. Mostly it fails to help me with that. It seems to lack simple administration techniques, which is one thing I really wanted...

It's good to compare main features of the covered SQL languages - MS, MySQL, Oracle, Postgre - but for the intermedate user there's too much detail on too few subjects.

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


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Does exactly what it says on the tin
As with most O'Reilly books, this is meant to be a useful reference and not really a tutorial. As such it succeeds magnificantly and is good value for money. Read more
Published on 29 Mar 2001

2.0 out of 5 stars Not a good reference
This book is good if you want to see the differences between the different SQL products mentioned. As an 'In a Nutshell' reference however I thought it fell far short on... Read more
Published on 10 Mar 2001

5.0 out of 5 stars One book for many dialects
I was looking for a book that could tell me the diffrences between Sql server(Access), MySql, postgres and Oracle. Read more
Published on 10 Feb 2001

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!


Look for similar items by category


Feedback


Oracle 8i: A Beginner's Guide

Oracle 8i: A...

More than just a database server, Oracle8i offers a complete... Read more

Find similar items

 

More From Kevin E. Kline

Transact-SQL Programming: Covers...

Transact-SQL Programming: Covers...

Lee Gould is a principal consultant with Sybase Professional Services... Read more

 

Boys Smell

Lynx Africa Body Spray and After Shave Gift set
But we make sure they smell good...

Discover male grooming at Amazon.co.uk

 

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

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