|
 |
|
 |
 |
SQL: 1999 - Understanding Relational Language Components (The Morgan Kaufmann Series in...
|
by Jim Melton and Alan R. Simon
Sales Rank: 771082
|
List Price: $80.95
$80.95
At Amazon
|
|
Paperback: 928 pages
Publisher: Morgan Kaufmann; 1st edition May 23, 2001
Language: English
ISBN-10: 1558604561
ISBN-13: 978-1558604568
Product Dimensions:
9.2 x 7.4 x 1.8 inches
Shipping Weight: 3.4 pounds
Product Description
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.
* 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.
Back Cover Copy
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.
Customer Reviews & Comments
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.
|
SQL: 1999 - Understanding Relational Language Components (The Morgan Kaufmann Series in...
List Price: $80.95
Available from Amazon
Price: $80.95
| |
|
|
|
|
