Save Big On Open-Box & Pre-owned: Buy "SQL: 1999: Understanding Relational Language Compo...” from Amazon Warehouse Deals and save 40% off the $99.95 list price. Product is eligible for Amazon's 30-day returns policy and Prime or FREE Shipping. See all Open-Box & Pre-owned offers from Amazon Warehouse Deals.
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL: 1999: Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Special Offers and Product Promotions
From the Back Cover
- 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
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.
Top Customer Reviews
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.
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.
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!
This book sound like a update to the book "Understanding The New SQL"
A good stuff, really!