Publication announcement for new SQL92 book

          Morgan Kaufmann announces the publication of

                      UNDERSTANDING THE NEW
                              SQL:
                        A COMPLETE GUIDE

                           Jim Melton
                  Digital Equipment Corporation

                          Alan R. Simon

ISBN 1-55860-245-3 560 pages $34.95 U.S. $38.45 International

"This book will be a valuable reference for the programmer who wants to understand the why and how of SQL-92. It offers what most people need from the standard, plus much that is missing from the original document. UNDERSTANDING THE NEW SQL gives a narrative tour of the language from the basics of relational theory, to exotic features like left-outer-join. The authors give the design rationale for each feature, show the syntax as railroad diagrams, and then provide examples using the features in a running application. It also reflects the authors' deep understanding of the issues, and their talent for explaining them"

     From the forward by Jim Gray (Digital Equipment Corporation)

SQL is THE way to develop, program, and use database applications. SQL-92 is a major advance over earlier versions, offering the first complete SQL language. DB programmers will have the advantage of knowing that applications written in SQL-92 will be portable to all hardware platforms for many years to come.

As the editor of the new standard, Jim Melton is an authority on the language and its new features. Using a highly readable, conversational style, the authors clearly present the power of SQL. They describe practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. Beginning with a tutorial on basic relational database concepts, subsequent chapters develop SQL and clarify the differences between SQL-89 and SQL-92. Throughout, a retail video and music store is used as an example that develops with the SQL presentation. The book is enhanced by a complete dynamic SQL example, coverage of international character sets, and a look at future generations of SQL. Whether you're a newcomer to SQL or an experienced programmer using PCs, workstations, mini- or mainframes, UNDERSTANDING THE NEW SQL is an essential resource for current and future implementations of SQL.

                            CONTENTS

PART I SQL-92 Basics

      1   Introduction to SQL-92                              3
      2   Getting Started with SQL-92                        15
      3   Basic Table Creation an Data Manipulation          43
      4   Basic Data Definition Language (DDL)               61
      5   Values, Basic Functions, and Expressions           83

PART II Advanced Features of SQL-92

      6   Advanced Value Expressions: CASE, CAST,
          and Row Value Expressions                         115
      7   Predicates
      8   Working With Multiple Tables: The Relational
          Operators                                         149
      9   Advanced SQL Query Expressions                    175
     10   Contstraints, Assertions, and Referential
          Integrity                                         199

PART III SQL and Applications

     11   Accessing SQL From the Real World                 231
     12   Cursors                                           259
     13   Privileges, Users, and Security                   273
     14   Transaction Management                            293
     15   Connections and Remote Database Access            303
     16   DYNAMIC SQL                                       311

PART IV The Finishing Touches

     17   Diagnostics and Error Management                  349
     18   Internationalization Aspects of SQL-92            361
     19   Information Schema                                371
     20   A Look to the Future                              387

PART V    APPENDICES
     
     A    Designing SQL-92 Databases                        397
     B    A Complete SQL-92 Example                         413
     C    The SQL-92 Annexes: Differences, Implementation-
          Defined and Implementation-Dependent Features,
          Deprecated Features, and Leveling                 441
     D    Relevant Standards Bodies                         465
     E    Status Codes                                      469
     F    The SQL Standardization Process                   473
     G    The Complete SQL-92 Language                      481

Also of Interest from Morgan Kaufmann:

• A Guide to Developing Client Server/SQL Applications by Setrag Khoshafian, Arvola Chan, Anna Wong, and Harry K.T. Wong
• Database Modeling and Design by Toby J. Teorey

Ordering Information:

     Shipping: In the U.S. and Canada, please add $3.50 for the
     first book and $2.50 for each additional for surface shipping;
     for surface shipments to all other areas, please add $6.50 for
     the first book and $3.50 for each additional book.  Air
     shipment available outside North America for $35.00 on the
     first book, and $25.00 on each additional book.  

     American Express, Master Card, Visa and personal checks drawn
     on U.S. banks accepted.
     MORGAN KAUFMANN PUBLISHERS, INC.
     Department E16
     2929 Campus Drive, Suite 260
     San Mateo, CA 94403
     USA
     
     Phone: (800) 745-7323 (in North America)
          (415) 578-9911
     Fax: (415) 578-0672
     email: morgan_at_unix.sri.com