SQL in a Nutshell
A Desktop Quick Reference
Publisher: O'Reilly Media
Final Release Date: September 2004
Pages: 720

SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.

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

REVIEW SNAPSHOT®

by PowerReviews
oreillySQL in a Nutshell
 
3.7

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

 
4.0

missing INFORMATION_SCHEMA

By frogola

from Undisclosed

Comments about oreilly SQL in a Nutshell:

It's useful when moving between different sql vendors to see the different syntax, and if a certain function is available. I was disappointed to see that there's still no documentation of the useful INFORMATION_SCHEMA views (which are included in the SQL standard, possibly as far back as 92). I was hoping this topic would have been added to the 2nd edition.

 
3.0

Good coverage of Oracle/SQL Server

By loquin

from Undisclosed

Comments about oreilly SQL in a Nutshell:

And, the coverage of PostgreSQL and MySQL was good for the versions listed, BUT, both the open source datbases have had MAJOR releases before this book was published.

PostgreSQL is now at version 8.1+, and MySQL is at version 5.

MySQL is now more ANSI compliant in its SQL implementation, and narrowed the feature gap between it and PostgreSQL. (it now supports limited stored procedures and trigger functionality.) PostgreSQL is now released in a native Win32 version, and has database roles, two-phase commits, savepoints, point-in-time recovery, ALTER TABLE supports column's data type, and CSV support in the COPY command.

So, if you want to compare proprietary databases, it's a great book. If you also need to work with open source databases, just be sure to run their older releases.

 
4.0

Struct Query Language Book very good!

By Eduardo Cesar Lunardelli

from Undisclosed

Comments about oreilly SQL in a Nutshell:

He pulls, this book was what he has of SQL for our group of studies, still I am revising it, because I am reading others, in the truth diverse workmanships at the same time, but he has covered many commands of language SQL and I am with base in this book making a course and preparing me for a MCP...

I advise to give one olhadinha in this book before going to make tests...:)

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:  DAISY, ePub, Mobi, PDF