Paperback(Older Edition)

View All Available Formats & Editions

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

SQL in a Nutshell 3.8 out of 5 based on 0 ratings. 4 reviews.
Guest More than 1 year ago
[A review of the 2nd edition, 2004.] Perhaps the best virtue of this book is that it spans all the major variants of SQL - db2, Oracle, MySQL, PostgreSQL and Microsoft's SQL Server. The authors are not beholden to any particular vendor. Thus the book describes the common ground. That is, the commands and usage that are most likely to be the same or similar across these implementations. Because a major use of this book might be in migrating. To this end, the more code you can have in this common area, the less painful the migration. Another possible usage is if you are a DBA in charge of running 2 [or more] of these implementations. Perhaps due to some legacy issues, you have to support them. If you cannot merge SQL code into one common version, you can get problems. Being able to use this book to find quickly common commands and options to those commands might greatly help you maximise a common body of code.
Guest More than 1 year ago
Contrary to several reviewers, this book is *not* well-suited to its purpose, especially compared to O'Reilly's usual high standards. You can't find what you need quickly, basic information is often missing, and there are enough glaring typos to make everything in the book suspect. This is particularly true of the book's main claim to fame, the myriad of small differences between database products. Some examples: (1) The book explains that some databases use '!=' instead of the standard SQL not-equal operator, ''. Which databases? Do they support both operators, or just '!='? The book doesn't say. (2a) The book doesn't tell you that MySQL doesn't support subqueries in SELECT statements -- even though there's a subsection on 'MySQL Syntax and Variations' for SELECT statements. (2b) The index has no entries for subqueries under any conceivable heading: queries, nested queries, subqueries, or SELECT. So you can spend quite a long time *trying* to find out which databases support subqueries. (Most do.) (3) The table of contents has a glaring typo, that makes you wonder what else got past the proofreaders and fact-checkers. Chapter 3, 'SQL Statements Command Reference' doesn't have sub-headings for individual commands or groups of commands ... except for one: 'DROP Statements', which are supposedly discussed for 70 pages, a third of the book. If O'Reilly was in such a rush to get the book out that they didn't notice this, how can you have confidence in the book's accuracy?
Guest More than 1 year ago
If you are someone like me, someone who takes a broad brush approach to developing and thinks that there is an appropriate database vendor or open source solution for every scenario, you will really love having this book on your reference shelf. The cross-platform references are excellent and show every option and attribute in thorough and accurate detail for several major database solutions. On first glance, some may scoff at 'how easy SQL is' until they move to a new database. If you pointed out the cross platform references during their first mockery, they will be apologizing and begging you to borrow it because it has the value of five books in one thin, easy to read an navigate title.
Guest More than 1 year ago
SQL in a Nutshell is designed as a cross- platform reference guide for people like me who are not experts and have to move between RDMS implementations (including desktop apps). In fact, SQL in a Nutshell's great virtue is that it finally levels the playing field by putting PostgreSQL and MySQL, the popular open source RDMS, on the same level with MS SQL Server and Oracle, each of which easily has its own market for high-end manuals and guides, while open source apps are freely available online. So, if you need full documentation on your favorite RDMS, go ahead and spend a couple of hundred dollars somewhere else. If you want a handy reference, simple explanations and comparisons, and an easy to read introduction to the four most important RDMSs currently available, pick up SQL in a Nutshell. You won't be disappointed.