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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 40 Ratings

This is a great reference for DB admins, especially if they use DBs from multiple vendors - 2009-05-30
Reviewer Rating:
I am reviewing the third edition.

This book is intended as a reference, not an instructional text. It serves this purpose well with pages and pages of great examples. The book is not focused on databases and SQL from a specific vendor, but gives great data and comparisons of commands and queries using ANSI SQL and then adjusting as needed for MySQL, Oracle, PostgreSQL, and SQL Server. If you are responsible for moving data from one vendor's product to another, or if you are responsible for databases from multiple vendors, this book could be a Godsend. Really, if you only use one of these products, the book is still a great value.

Keep in mind, this is not an instruction manual. This is a compilation of commands with examples. The goal is not to lead gently, but to get directly to the meat of using SQL, to give clear and detailed information about each command, its syntax and options, and several examples of usage. If that is what you are looking for, and especially a book with comparisons across platforms, this book will serve you very well.

SQL dummy! - 2009-05-21
Reviewer Rating:
SQL seems like a pretty simple and straightforward language and for the most part it is, until you get into complex queries. This book is great about explaining the hows and whys including performance costs of various approaches.

Interleaved reference manual for MySQL, Oracle, PostgreSQL, MS SQL Server - 2009-04-24
Reviewer Rating:
For me, the value of this book is in its comparison/contrasts of different flavors of SQL syntax.

The third edition covers and compares ANSI (SQL2003), MySQL 5.1, Oracle 11g, PostgreSQL 8.3, and Microsoft SQL Server 2008. (No mention of DB2, which other reviewers have found in the second edition.) "Because XML and XQuery are disciplines in their own right, they are considered beyond the scope of this book." As other reviewers have said, this is great as a cross-platform command reference; but somewhat redundant if you are already committed to a particular implementation.

I learned Sybase and SQL Server (and am picking up PostgreSQL) by reading the vendor-supplied manuals. This book doesn't really go beyond collating all the commands (and descriptions of their options) from those manuals, except by providing tables of commands, datatypes, identifier naming rules, operators showing whether a certain incantation is supported in which of the four database implementations. I don't mean this to be as negative as it sounds --- this juxtaposition is the entire point of this book, and can be very helpful if you want to write platform-independent SQL. Context-switching by flipping pages can still be much faster than having two web browser windows open to the vendors' online manuals.

Unfortunately, certain areas of databases are platform-dependent, such as index implementation. If you don't know what kind of index will be best for your application, this book's description of the CREATE INDEX command is not going to help you and you should instead review your vendor's database tuning notes. Come to think of it, this book makes almost no mention of performance tuning --- but that's probably appropriate.

The book index is OK if you know the exact command you are looking for --- but since the reference section is in alphabetical order already, you could have just flipped through the book to it. At least 80% of the words in the index are commands (in ALL CAPS), and a large fraction of the others are concepts in the introduction section. This is not a "recipes" book, and if you know what you want to do but don't know the name of the command, you are better off using an internet search engine.

A key acquisition for any library catering to professional database administrators and developers - 2009-03-15
Reviewer Rating:
SQL IN A NUTSHELL references the SQL language used in modern database products, and this new edition documents every SQL command according to the latest ANSI standard. From how commands are implemented in MS SQL Server 2008 to an alphabetical reference of the ANSI SQL2003 functions, this reference picks up where vender documentation ends and is a key acquisition for any library catering to professional database administrators and developers.

Very Good, Sucky index! - 2009-01-08
Reviewer Rating:
While this is a very good reference book and deserves the 4 stars, I continually get frustrated with 1 thing: The index is poor. I don't know how many times after not finding something in the index I've had to skim through the table of contents and then search a bit through the pages. This can be very frustrating for a reference book.

Again, though, the content has been very helpful for months of Oracle & MySQL reference.

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > SQL
Databases > SQL Server
SQL Server > Reference