راهنمای استاندارد SQL: راهنمای کاربر برای زبان رابطه‌ای استاندارد SQL

A tutorial guide and a reference that describes the official standard version of the database language SQL. The five major parts include Introduction, Some preliminaries, Data definition and manipulation, Data control and Advanced topics. Paper. DLC: SQL (Computer program language)

The SQL language has established itself as the linqua franca database management; it provides the basis for systems interoperability, application portability, client/server operation, distributed database, and more, and is supported by just about every DBMS on the market today. SQL2 - or, to give it its official name, the International Standard Database language SQL (1992) - represents a major set of extensions to the earlier SQL standard. For a start, the new specification is well over 600 pages, compared with less than 100 for the original version. No database professional can afford to ignore it.

Features

• Thorough revision of the official ANSI standard for SQL.
• Covers all important new SQL2 features including extensive integrity support, powerful new operators, national and international character data support and comprehensive date and time support.
• Continues the tradition of careful, clear, and accurate explanations of complex technical material

Features New to this Edition

• Covers extensive integrity support, powerful new operators, national and international character data support, all features of SQL2; comprehensive date and time support and clear explanation of the complexitites of Dynamic SQL, all features of SQL2.
• Provides first tutorial treatment available anywhere of the brand new and dramatically extended version of SQL known informally as SQL2 or SQL/92.

The previous edition of this book established itself as the most complete and understandable treatment of the SQL standard generally available. Many changes have occurred in the SQL standards world since that edition was published, however: a major new component, the Call-Level Interface (SQL/CLI), was added in 1995. Another major new component, the Persistent Stored Modules feature (SQL/PSM), is nearing completion and is due to be added to the standard in late 1996 or early 1997. The original 1992 standard itself has been significantly changed and corrected through the publication of two extensive Technical Corrigenda, one in 1994 and one in 1996. All of these changes are reflected in this Fourth Edition. Earlier editions of this book established a tradition of careful, clear, and accurate explanation of complex technical material. This new edition continues that tradition A comprehensive treatment of SQL, this edition of the text is revised and updated to cover all current components and features of SQL since 1992.