Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images
Have one to sell? Sell on Amazon

SQL: 1999: Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems) Paperback – June 1, 2001

ISBN-13: 978-1558604568 ISBN-10: 1558604561 Edition: 1st
Buy used
$72.71
Buy new
$83.67
Used & new from other sellers Delivery options vary per offer
65 used & new from $25.10
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$17.68
Paperback, June 1, 2001
"Please retry"
$83.67
$29.68 $25.10
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$83.67 FREE Shipping. Only 1 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

SQL: 1999: Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems) + Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems)
Price for both: $156.63

Buy the selected items together

Special Offers and Product Promotions

  • Save Big On Open-Box & Used Products: Buy "SQL: 1999: Understanding Relational Language Compo...” from Amazon Open-Box & Used and save 27% off the $99.95 list price. Product is eligible for Amazon's 30-day returns policy and Prime or FREE Shipping. See all offers from Amazon Open-Box & Used.

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.

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.

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Paperback: 893 pages
  • Publisher: Morgan Kaufmann; 1 edition (June 1, 2001)
  • Language: English
  • ISBN-10: 1558604561
  • ISBN-13: 978-1558604568
  • Product Dimensions: 6.7 x 1.8 x 9.6 inches
  • Shipping Weight: 3.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #2,318,999 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.5 out of 5 stars
5 star
3
4 star
0
3 star
1
2 star
0
1 star
0
See all 4 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

21 of 21 people found the following review helpful By Bryan J. Higgs on August 30, 2001
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Jonathan W. Robie on February 10, 2004
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 2 people found the following review helpful By Galileo2010 on January 24, 2007
Format: Paperback 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".
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
0 of 2 people found the following review helpful By Adhoniran S. Gomes on August 10, 2006
Format: Paperback
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
SQL: 1999: Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems)
This item: SQL: 1999: Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems)
Price: $83.67
Ships from and sold by Amazon.com