SQL in a Nutshell: A Desktop Quick Reference [NOOK Book]

Overview

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 ...

See more details below
SQL in a Nutshell: A Desktop Quick Reference

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$19.99
BN.com price
(Save 44%)$35.99 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9781449378936
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 9/24/2004
  • Series: In a Nutshell (O'Reilly)
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 720
  • File size: 8 MB

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 4 Customer Reviews
  • Anonymous

    Posted October 28, 2004

    maintaining several SQL implementations?

    [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.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 20, 2002

    A quick-reference should be quick and reasonably complete.

    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?

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 3, 2002

    Best Buy for a General SQL Title

    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.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 16, 2001

    Well Suited to its Purpose

    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.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 4 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)