SQL in a Nutshell

( 1 )

Overview

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

See more details below
Paperback (Third Edition)
$31.78
BN.com price
(Save 29%)$44.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (13) from $17.49   
  • New (5) from $25.17   
  • Used (8) from $17.49   
SQL in a Nutshell

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • 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 Study
  • NOOK for Web

Want a NOOK? Explore Now

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

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780596518844
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 11/1/2008
  • Series: In a Nutshell (O'Reilly) Series
  • Edition description: Third Edition
  • Edition number: 3
  • Pages: 594
  • Sales rank: 343,472
  • Product dimensions: 6.00 (w) x 8.90 (h) x 1.40 (d)

Meet the Author

Kevin Kline is the Director of SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring on the SQL Server platform. Kevin is also the President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin's most popular book is SQL in a Nutshell published by O'Reilly Media. Kevin is also the author of Transact-SQL Programming and three other books on database technologies. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections. When he's not working, Kevin likes to romance his wife, play to his four kids, write, and garden.

Daniel T. Kline (Ph.D., Indiana University, 1997) specializes Middle English literature and culture; Chaucer; literary and cultural theory; critical pedagogy; and digital medievalism. Among others, his publications include essays in Chaucer Review, College Literature, Comparative Drama, the Journal of English and Germanic Philology, Philological Quarterly, and Literary and Linguistic Computing, and recent chapters in the Cambridge Companion to Medieval Women (Cambridge, 2003), Translating Desire in Medieval and Early Modern Literature (MRTS, 2005), Mass Market Medievalism (McFarland, 2007), Essays on Medieval Childhood: Responses to Recent Debates (Shaun Tyas, 2007), and Cultural Studies of the Modern Middle Ages (Palgrave, 2007). He edited Medieval Children's Literature (Routledge, 2003) and is co-editing The Medieval in Motion, a volume on contemporary film, TV, and videogame neo-medievalism. His current research concerns children, violence, and sacrifice in late-medieval England, and he has essays forthcoming on Emmanuel Levinas and medieval drama and the apocryphal Infancy of Jesus Christ in MS Laud 108. Prof. Kline is an Associate Professor of English and Chair of the Graduate Program in English at the University of Alaska Anchorage. He is also the author/webmaster of The Electronic Canterbury Tales

Brand Hunt is a Project Manager and Software Developer at Systems Research and Development (http://srdsoftware.com). The team at SRD is a world leader in systems for privacy-friendly identity recognition and relationship awareness. Prior to SRD, Brand worked at Rogue Wave software. Beyond work, Brand enjoys playing board games, pinochle, and snowboarding with his family and friends.

Read More Show Less

Table of Contents

  • Preface
  • Chapter 1: SQL History and Implementations
  • Chapter 2: Foundational Concepts
  • Chapter 3: SQL Statement Command Reference
  • Chapter 4: SQL Functions
  • Shared and Platform-Specific Keywords
  • Colophon

Read More Show Less

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)