SQL in a Nutshell (In a Nutshell (O'Reilly))

3.66 avg rating
( 128 ratings by Goodreads )
 
9780596518844: SQL in a Nutshell (In a Nutshell (O'Reilly))
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

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, detailing each entry with explanatory text and illustrative examples. Perhaps best of all, authors Kevin and Daniel Kline feature MySQL in their coverage, giving it billing equal to that of Oracle, Microsoft SQL Server, and PostgreSQL. Their inclusion of open-source MySQL, which carries no license fee in most situations, is recognition of its growing popularity and suitability for serious database applications. It also 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 the four covered platforms' implementations of datatypes--readers learn that a PostgreSQL int2 value is known as a "smallint" in ANSI standard SQL, for example. This is a handy reference book, particularly if you use one of the emphasised SQL implementations. --David Wall

Topics covered: Structured Query Language (SQL) as it is implemented in Oracle, Microsoft SQL Server, MySQL and PostgreSQL, as well as in ANSI standard SQL (SQL92 and SQL99). After an introduction to datatypes and relational database fundamentals (the latter is not emphasised), the authors document SQL statements and functions one by one, alphabetically. They take care to point out differences among the four implementations.

Review:

An invaluable desktop reference for those who deal with SQL at a professional level. Compact and well designed. -- Major Keary, PC Update March 2002

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

Stock Image

1.

OREILLY
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Softcover Quantity Available: 1
Seller:
bookscollection
(Delhi, DELHI, India)

Book Description Condition: Brand New. PAPERBACK, Book Condition New, U.S. EDITION. We Do not Ship APO FPO AND PO BOX. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Seller Inventory # 9780596518844 SESSPK

More information about this seller | Contact this seller

Buy New
13.67
Convert currency

Add to Basket

Shipping: 1.94
From India to U.S.A.
Destination, rates & speeds
Stock Image

2.

OREILLY
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Softcover Quantity Available: 1
Seller:
TEXTBOOKS STORE
(Ghaziabad, UP, India)

Book Description Condition: Brand New. PAPERBACK, Book Condition New, U.S. EDITION. We Do not Ship APO FPO AND PO BOX. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Seller Inventory # KKSSP 9780596518844

More information about this seller | Contact this seller

Buy New
13.60
Convert currency

Add to Basket

Shipping: 3.16
From India to U.S.A.
Destination, rates & speeds
Seller Image

3.

Kline, Kevin
Published by O'Reilly Media 11/1/2008 (2008)
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Paperback or Softback Quantity Available: 5
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)

Book Description O'Reilly Media 11/1/2008, 2008. Paperback or Softback. Condition: New. SQL in a Nutshell. Book. Seller Inventory # BBS-9780596518844

More information about this seller | Contact this seller

Buy New
22.43
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

4.

Not Available (na), Not Available (na); Kline, Kevin; Kline, Daniel; Hunt, Brand; Brand Hunt , Brand Hunt ; Daniel Kline, Daniel Kline
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Quantity Available: 2
Seller:
GreatBookPrices
(Columbia, MD, U.S.A.)

Book Description Condition: New. Seller Inventory # 5678246-n

More information about this seller | Contact this seller

Buy New
22.97
Convert currency

Add to Basket

Shipping: 2.01
Within U.S.A.
Destination, rates & speeds
Stock Image

5.

Kevin Kline, Daniel Kline, Brand Hunt
Published by O'Reilly Media, Inc, USA, United States (2015)
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Paperback Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)

Book Description O'Reilly Media, Inc, USA, United States, 2015. Paperback. Condition: New. 3rd Revised edition. Language: English. Brand new Book. 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. Seller Inventory # AAH9780596518844

More information about this seller | Contact this seller

Buy New
26.71
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds
Stock Image

6.

Kline, Kevin; Hunt, Brand; Kline, Daniel
Published by O'Reilly Media
ISBN 10: 0596518846 ISBN 13: 9780596518844
New PAPERBACK Quantity Available: > 20
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)

Book Description O'Reilly Media. PAPERBACK. Condition: New. 0596518846 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|VCF. Seller Inventory # OTF-S-9780596518844

More information about this seller | Contact this seller

Buy New
23.79
Convert currency

Add to Basket

Shipping: 3.03
Within U.S.A.
Destination, rates & speeds
Stock Image

7.

Kevin Kline, Daniel Kline, Brand Hunt
Published by O'Reilly Media, Inc, USA, United States (2015)
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Paperback Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)

Book Description O'Reilly Media, Inc, USA, United States, 2015. Paperback. Condition: New. 3rd Revised edition. Language: English. Brand new Book. 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. Seller Inventory # AAH9780596518844

More information about this seller | Contact this seller

Buy New
27.40
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds
Stock Image

8.

Kevin Kline, Brand Hunt, Daniel Kline
Published by O'Reilly Media (2008)
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)

Book Description O'Reilly Media, 2008. Paperback. Condition: New. Third Edition. Seller Inventory # DADAX0596518846

More information about this seller | Contact this seller

Buy New
30.28
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

9.

Kevin Kline; Brand Hunt; Daniel Kline
Published by O'Reilly Media (2008)
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Softcover Quantity Available: > 20
Print on Demand
Seller:
California Books
(MIAMI, FL, U.S.A.)

Book Description O'Reilly Media, 2008. Condition: New. This book is printed on demand. Seller Inventory # I-9780596518844

More information about this seller | Contact this seller

Buy New
28.18
Convert currency

Add to Basket

Shipping: 2.28
Within U.S.A.
Destination, rates & speeds
Stock Image

10.

Kevin Kline
Published by O'Reilly Media, Inc, USA
ISBN 10: 0596518846 ISBN 13: 9780596518844
New Paperback / softback Quantity Available: 5
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)

Book Description O'Reilly Media, Inc, USA. Paperback / softback. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9780596518844

More information about this seller | Contact this seller

Buy New
23.61
Convert currency

Add to Basket

Shipping: 6.94
From United Kingdom to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book