A practical and useful command reference to the latest release of the structured Query Language (SQL). For experienced SQL programmers, analysts, and database administrators, this book offers a handy key to each of the SQL commands, telling how to use it in both commercial (Microsoft SQL Server 2000 and Oracle 8i), and how to open source implementations.

Seller Inventory # 9781565927445

Contact seller

Report this item

Bibliographic Details

Title: SQL n A Nutshell: A Desktop Quick Reference
Publisher: O'Reilly
Publication Date: 2000
Language: English
ISBN 10: 1565927443
ISBN 13: 9781565927445
Binding: Paperback
Condition: New

About this title

Synopsis

SQL in a Nutshell is a practical and useful command reference to the latest release of the Structured Query Language (SQL99), helping readers learn how their favorite database product supports any standard SQL command. This book presents each of the SQL commands and describes its use in both commercial (Microsoft SQL Server 2000 and Oracle 8i) and open source (MySQL, PostgreSQL 7.0) implementations. Each command reference includes the command syntax (by vendor, if the syntax differs across implementations), a description, and informative examples that illustrate important concepts and uses. SQL in a Nutshell is more than a convenient reference guide for experienced SQL programmers, analysts, and database administrators. It's also a great learning resource for novice and auxiliary SQL users.

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.

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

Store Description

At SZ Global, we specialize in sourcing and offering a diverse selection of books across a wide range of categories, including fiction, literature, business, religious works, and more. Our inventory includes both contemporary titles and hard to find editions, carefully selected to meet the needs of readers, collectors, and enthusiasts. We are committed to providing accurate listings, reliable service, and a smooth purchasing experience. All orders are shipped from our Kuwait warehouse, and we take great care in packaging to ensure books arrive in the condition described. Returns are accepted at our designated return address in Toronto, Canada, in accordance with AbeBooks policies. Whether you are expanding your personal collection, searching for a specific title, or simply exploring, SZ Global aims to be a dependable source for quality books.

Visit Seller's Storefront

Seller's business information

SZ Global
ON, Canada

Sale & Shipping Terms

Terms of Sale

These terms and conditions of sale (?Agreement?) are applicable to any order placed with and accepted by Us (referred to herein as ?Supplier?):

SCOPE OF AGREEMENT. Supplier, upon acceptance of an Order placed by Buyer, will supply the products and services specified in the Order (the ?Work?) to Buyer, pursuant to the terms and conditions of this Agreement and its exhibits and Supplier?s acceptance of such order submitted by Buyer is expressly limited to the terms and conditions of this Agreeme...

More Information

Shipping Terms

Returns Policy

You may return most new, unopened items within 15 days of the Estimated Delivery Date for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

Any customer wishing to return a book has 30 days to do so if they are not entirely satisfied.

You should expect to receive your refund within three weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, please Contact Us with your order number and details about the product you would like to return. We will respond quickly with instructions for how to return items from your order.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Shipping rates from Canada to U.S.A.

Shipping rates from Canada to U.S.A.
Order quantity	5 to 10 business days	3 to 5 business days
First item	US$ 37.21	US$ 40.21

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.