List Price: $99.95 Details

Save: $8.50 (9%)

FREE delivery August 9 - 15. Details

In stock.
Usually ships within 3 to 4 days.

As an alternative, the Kindle eBook is available now and can be read on any device with the free Kindle app.

[{"displayPrice":"$91.45","priceAmount":91.45,"currencySymbol":"$","integerValue":"91","decimalSeparator":".","fractionalValue":"45","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"4pO5xHrRfvGoka106j3FEbKS3K%2FWpRYbg0OzULzq3O1aHiVcHDQRk5roUAORXAUrE8SJSvRFGEM8OFNb4IXZdyvKhamYFvHPFtBvNlw%2FMkOZADaIgRjtoEuAdalzMWKr06SLuNVPjSbCWp8fXL1RZFra7MlEdx6DjA2XqvCSyz0%3D","locale":"en-US","buyingOptionType":"NEW"},{"displayPrice":"$10.09","priceAmount":10.09,"currencySymbol":"$","integerValue":"10","decimalSeparator":".","fractionalValue":"09","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"LlJxYFicuVWxm%2BDJcboQYwmVckpOXfOM%2BiDJoa%2FSQX788rEFsHRVgjcgwOFlsH8hgP3LCSityD0wDY3AiNgvIh0Oh4i3PT1h%2BzFnjnlHRuA76Kf8V%2Fo0m0WVrHMoUue47%2BPJm9HIPtMHxmxZbWPr0wB14CzjlC%2BNHliTsSgoRSvhYHDizDIgYA%3D%3D","locale":"en-US","buyingOptionType":"USED"}]

$$91.45 () Includes selected options. Includes initial monthly payment and selected options. Details

Secure transaction

Ships from

Book Depository US

Sold by

Book Depository US

Details

Ships from

Book Depository US

Sold by

Book Depository US

Return policy: Eligible for Return, Refund or Replacement within 30 days of receipt

FREE delivery August 5 - 11. Details

Or fastest delivery August 1 - 4. Details

Select delivery location

Used: Very Good | Details

Sold by ⚡The Wisdom Shop✈

Access codes and supplements are not guaranteed with used items.

Share

Have one to sell?

Sell on Amazon

Other Sellers on Amazon

Added

Not added

$99.95
& FREE Shipping. Details

Sold by: Amazon.com

Added

Not added

$117.64
& FREE Shipping

Sold by: Yellow Book Sales

Added

Not added

$120.52
+ $3.99 shipping

Sold by: ZiFiti

Flip to back Flip to front

Listen Playing... Paused You're listening to a sample of the Audible audio edition.
Learn more

See all 3 images

Follow the Author

Jim Melton

SQL: 1999: Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems) 1st Edition

by Jim Melton (Author), Alan R. Simon (Author)

6 ratings

Part of: The Morgan Kaufmann Series in Data Management Systems (70 books)

See all formats and editions

Price

New from

Used from

Kindle

"Please retry"

$86.88

—

Paperback

"Please retry"

$298.99

—

$298.99

Paperback

"Please retry"

$91.45

$36.84

$8.49

Enhance your purchase

SQL: 1999 is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database.

ISBN-10

9781558604568
ISBN-13

978-1558604568
Edition

1st
Publisher

Morgan Kaufmann
Publication date

June 1, 2001
Language

English
Dimensions

6.69 x 1.83 x 9.61 inches
Print length

893 pages
See all details

Frequently bought together

+

Total price:

To see our price, add these items to your cart.

One of these items ships sooner than the other.

Show details Hide details

Choose items to buy together.

by Jim Melton Paperback
$91.45
In stock.
Usually ships within 3 to 4 days.
Ships from and sold by Book Depository US.
Get it Aug 9 - 15
by Hector Garcia-Molina Hardcover
$181.32
Only 10 left in stock (more on the way).
Ships from and sold by Amazon.com.
Get it as soon as Wednesday, Aug 3

Editorial Reviews

From the Back Cover

This book is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database, which can be downloaded from the companion Web site.

Features

Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards.
Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages.
Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases.
Explores key issues for programmers linking applications to SQL databases.
Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL.
Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.|This book is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon,SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users,SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database, which can be downloaded from the companion Web site.

Features
- Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards.
- Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages.
- Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases.
- Explores key issues for programmers linking applications to SQL databases.
- Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL.
- Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.

About the Author

Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and is a representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI INCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTC1/SC32/WG3 (Database Languages). In addition, Jim has participated in the W3C's XML Query Working Group since 1998 and is currently co-Chair of that Working Group. He is also Chair of the WG's Full-Text Task Force, co-Chair of the Update Language Task Force, and co-editor of two XQuery-related specifications. He is the author of several SQL books.

Alan Simon is a leading authority on data warehousing and database technology. He is the author of 26 books, including the previous edition of this book and the forthcoming Data Warehousing and Business Intelligence for e-Commerce, available from Morgan Kaufmann Publishers in early 2001. He currently provides data warehousing-related consulting services to clients.

Start reading SQL instantly on your Kindle Fire or on the free Kindle apps for iPad, Android tablet, PC or Mac. Don't have a free Kindle app? Get yours here

Product details

ASIN ‏ : ‎ 1558604561
Publisher ‏ : ‎ Morgan Kaufmann; 1st edition (June 1, 2001)
Language ‏ : ‎ English
Paperback ‏ : ‎ 893 pages
ISBN-10 ‏ : ‎ 9781558604568
ISBN-13 ‏ : ‎ 978-1558604568
Item Weight ‏ : ‎ 3.35 pounds
Dimensions ‏ : ‎ 6.69 x 1.83 x 9.61 inches

Best Sellers Rank: #3,085,889 in Books (See Top 100 in Books)
- #113 in Relational Databases
- #780 in Network Storage & Retrieval Administration
- #826 in SQL

Customer Reviews:
6 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.

Jim Melton

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

5 star		27%
4 star 0% (0%)		0%
3 star		73%
2 star 0% (0%)		0%
1 star 0% (0%)		0%

How customer reviews and ratings work

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Galileo2010

Good,but.........

Reviewed in the United States on January 24, 2007

Verified Purchase

It is a very good coverage of SQL standard, but I didn't like the style of writing. Just like many SQL books you have to spend some time looking at the sample database in order to understand the concept.This to me is a waste of time and annoying.The difference is clear if you compare it to other books like Date's "Introduction to Database Systems".

One person found this helpful

Helpful

Jonathan W. Robie

A great introduction to the concepts of SQL:1999

Reviewed in the United States on February 10, 2004

The SQL:1999 standard was not written to teach people how to use the language. It is written in a precise, formal manner that is very useful for implementors, but makes it difficult for most people to read, and assumes extensive knowledge of many concepts. (I am an editor of several W3C XQuery specifications - you can't write a specification as a tutorial, that's not what it is for.)
Jim is the editor of SQL:1999, but in this book he provides the concepts and the examples that users need to understand the standard. Unlike many books on SQL, Jim describes the SQL standard, rather than the proprietary dialect of a given vendor. This book is readable and interesting, explaining not only what the standard says, but how the standard thinks.
I work for a company that makes JDBC and ODBC drivers, and this is the book that our development manager recommended to me when I was looking for this kind of information.

8 people found this helpful

Helpful

Bryan J. Higgs

An important book on SQL

Reviewed in the United States on August 30, 2001

This is an important book. Most books on SQL cover simple SQL statements, and/or focus on a particular vendor's SQL implementation. Very few books attempt to cover the SQL standard in any depth, if at all. This one does. Furthermore, because one of the authors (Jim Melton) is the editor of the ISO SQL Standards Committee, the book is extremely authoritative on the subject.
The SQL:1999 standard can be an overwhelming document, both because of its size (it surely must be the largest of the language standards?) and because of its formal language (not bedtime reading by any means!). This book provides a much more accessible description of the contents of that standard, and it is sorely needed.
While the authors' writing style is very readable, don't expect this book to be a beginner's guide to SQL; that's not its intent. The book goes into great detail about SQL statements, and their operations. If you already know something about the basics of SQL and wish to learn much more about the language (and indeed, some features in the standard not yet implemented in most database vendors' products), this is the book to get.
In the interests of full disclosure, I should say that I know Jim Melton personally. I have the highest respect for him; his knowledge on the subject of SQL is positively encyclopedic.

21 people found this helpful

Helpful

THOMAS Hartwig

The book is a decent introduction into the (not so ...

Reviewed in the United States on March 15, 2016

The book is a decent introduction into the (not so new any more) standard for developers who want to write SQL statements.
As a documentation it fails miserably. It has no "hard and precise" information about the syntax. (E.g. even for delimited identifiers the fact is not mentioned, that quotes need to be doubled).
As a guide to the standard it fails completely. The author is much too concerned with object-relational ideas, with programming languages, and considers it beneath him even to present a correct list of reserved keywords. (The list he gives, conatains some Oracle idiosyncrasies which are NOT part of the standard.)
The "companion website" mentioned does not exist anymore today - if it ever existed. There is no source for the "entire syntax of SQL:1999 in BNF form freely available today! (Of course, there is no free source available for SQL:2003 or SQL:2008 either.) The URL published leads to Elsevier, who try to punish honest buyers of the book by offering them very expensive subscriptions. There IS no free "companion website" (...) as mentioned in the product description on Amazon!

2 people found this helpful

Helpful

Adhoniran S. Gomes

SUPERB!!

Reviewed in the United States on August 11, 2006

So great! It's a good stuff to learn SQL and new SQL 99 features and resources, explaining all SQL concepts, with samples to understand the concepts and sintaxes.

This book sound like a update to the book "Understanding The New SQL"

A good stuff, really!

Helpful