SQL: 1999: Understanding Relational Language Components

by Jim Melton, Alan R. Simon

1999 is the best way to make the leap from SQL-92 to but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, 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, 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. Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and standards. Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages. Explains 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 example, the standardization process, and more.

893 pages, Kindle Edition

First published May 18, 2001

Reviews

[Omar Gamal · Rating 2 out of 5]

The book is really important and cover the basic concepts and standards of SQL but the problem with lack of focus on the subject of the book and referring many times to different book chapters inside one paragraph as well as keep demonstrating comparison between SQL1999 and old versions which cause some distractions while reading