| SQL in a Nutshell (In a Nutshell (O'Reilly)) | 
| Authors: Kevin Kline, Daniel Kline, Brand Hunt
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $44.99
Buy New: $24.39
You Save: $20.60 (46%)
Buy New/Used from $24.39
Avg. Customer Rating:   (36 reviews)
Sales Rank: 91439
Languages: English (Original Language), English (Unknown), English (Published)
Media: Paperback
Edition: 3
Number Of Items: 1
Pages: 591
Shipping Weight (lbs): 1.4
Dimensions (in): 9 x 6.1 x 1.4
ISBN: 0596518846
Dewey Decimal Number: 005
EAN: 9780596518844
ASIN: 0596518846
Publication Date: December 2, 2008
Availability: Usually ships in 1-2 business days
|
| Similar Items:
|
| Editorial Reviews:
Product Description
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.
Amazon.com Review
SQL in a Nutshell applies the classic O'Reilly "Nutshell" format to Structured Query Language (SQL), the elegant descriptive language that's used to create and manipulate stores of data. This book explains the purpose and proper syntax of hundreds of SQL statements, as defined in four major SQL implementations, and details each entry with explanatory text and illustrative examples. Perhaps best of all, authors Kevin and Daniel Kline feature MySQL in their coverage, and give it billing that's equal to that of Oracle, Microsoft SQL Server, and PostgreSQL. Their inclusion of open-source MySQL, which in most situations carries no license fee, is recognition of its growing popularity and suitability for serious database applications; also, it improves this book's appeal to Unix and Linux developers. The majority of this slender book comprises eminently useful syntax documentation (which is in the style of Unix man pages, with bracketed options and monospace arguments) and the other information that's specific to individual statements and functions. Additionally, it includes a relatively small amount of conceptual information, such as a section on the proper use of NULL values. The material that's not statement-specific also contrasts data-type implementations of the four covered platforms--for example, readers learn that a PostgreSQL int2 value is known as a smallint in ANSI standard SQL. This is a particularly handy reference book, if you use one of the emphasized SQL implementations. --David Wall Topics covered: Structured Query Language (SQL), as implemented in Oracle, Microsoft SQL Server, MySQL, and PostgreSQL, as well as in ANSI standard SQL (SQL92 and SQL99). After an introduction to data types and relational database fundamentals (the latter is not emphasized), the authors document SQL statements and functions, one by one and alphabetically. They take care to point out differences among the four implementations.
|
| Customer Reviews: Read 31 more reviews...
Very Good, Sucky index! January 8, 2009
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.
An SQL Reference Book November 5, 2006
1 out of 2 found this review helpful
This book covers various "flavors" of SQL, but not all of them. This was a "recommended" reference book for a college-level Introduction to SQL course. I will keep the book around as a technical reference even though I discovered it was a lot easier to find PostgreSQL syntax information by typing a command into Google and scanning the results for examples.
Nice Pocket Reference For SQL June 10, 2005
7 out of 11 found this review helpful
This is a nice, quick guide for referencing SQL. This book is not a 900 page behemoth to teach you all the ins and outs of SQL setup and performance tweaking, nor is it a 30 page list of commands. Rather, it is a nice "tweener" guide (200+ pages) to get your feet wet and remind you of what commands are and how SQL can be used. 'SQL In A Nutshell' covers SQL Server, MySQL, Oracle, and PostgreSQL, going over the SQL standards that you can expect from these favorite flavors of SQL. Light on examples but heavy on syntax, I feel that this is a nice companion manual to have at your side when you need to remind yourself how a particular command should be written.
If you are a SQL developer could you live without this manual? Yes you probably could live without it, but it's handy to have at your side and I would recommend it.
**** RECOMMENDED
 Cross platform syntax reference November 7, 2004
16 out of 19 found this review helpful
This is a solid desk reference for SQL syntax which provides invaluable material on the portability of each type of statement. The heart of the book is the four hundred pages of statement reference. Each statement is described with it's syntax and options. Then the support for each database (DB2, MySQL, Oracle, PostgresSQL, and SQL Server) is described in detail. There is a similar 120 page reference on SQL functions.
This is classic O'Reilly. The text is well written, and the book is very dense and well organized. There is a little introductory material but the heart of the book is the statement and function reference. You will get the most out of this book if you already have a reasonable understanding of SQL. This is not a book for beginners.
This would make an ideal desktop reference, particularly for someone working in a cross-platform environment that goes directly to the SQL.
Maintaining several SQL implementations? October 28, 2004
9 out of 12 found this review helpful
[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.
|
|
|
