SQL in a Nutshell, 3rd Edition
A Desktop Quick Reference Guide
Publisher: O'Reilly Media
Final Release Date: November 2008
Pages: 594

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

  • Background on the Relational Database Model, including current and previous SQL standards
  • Fundamental concepts necessary for understanding relational databases and SQL commands
  • An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
  • The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
  • An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
  • Platform-specific functions unique to each implementation

Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillySQL in a Nutshell, 3rd Edition
 
4.3

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (3)
  • Helpful examples (3)

Cons

No Cons

Best Uses

  • Intermediate (3)

Reviewed by 3 customers

Displaying reviews 1-3

Back to top

 
5.0

good reference book

By Tom

from Nacka, Sweden

About Me Developer

Verified Reviewer

Pros

  • Accurate
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Expert
    • Intermediate
    • Student

    Comments about oreilly SQL in a Nutshell, 3rd Edition:

    A very good and well written reference.

    The book is actually so well written that it can be read as a text book.

    The only small negative thing is that the index and table of contents are bad in the epub version (at least when reading in ibooks). For the epub version you have to rely on the search function in the reader app. The PDF version has a much better index.

     
    4.0

    Excellent Resource

    By Kaldran

    from Atlanta

    About Me Designer, Sys Admin

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

    • None

    Best Uses

    • Expert
    • Intermediate

    Comments about oreilly SQL in a Nutshell, 3rd Edition:

    I use this book on a regular basis since I have to switch back and forth from SQLServer and MySQL. I'm looking forward to the next version that will hopefully be updated for SQLServer 2012 and the latest version of MySQL

    (1 of 1 customers found this review helpful)

     
    4.0

    Great little book

    By Eddie

    from Surrey, UK

    About Me Developer

    Verified Reviewer

    Pros

    • Concise
    • Easy to understand
    • Helpful examples

    Cons

      Best Uses

      • Intermediate

      Comments about oreilly SQL in a Nutshell, 3rd Edition:

      I won the first edition of this book in an online magazine raffle, and am very pleased with it. As it is quite worn, I am going to get the latest edition.

      Displaying reviews 1-3

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook:  $35.99
      Formats:  APK, DAISY, ePub, Mobi, PDF
      Print & Ebook:  $49.49
      Print:  $44.99