Description |
xxiv, 536 pages : illustrations ; 24 cm |
Series |
The Morgan Kaufmann series in data management systems |
|
Morgan Kaufmann series in data management systems.
|
Contents |
Machine derived contents note: Table of contents for Understanding the new SQL : a complete guide / Jim Melton, Alan R. Simon. -- Bibliographic record and links to related information available from the Library of Congress catalog -- Information from electronic data provided by the publisher. May be incomplete or contain other coding. -- 1 Introduction to SQL-92 -- 2 Getting Started with SQL-92 -- 3 Basic Table Creation and Data Manipulation -- 4 Basic Data Definition Language (DDL) -- 5 Values, Basic Functions, and Expressions -- 6 Advanced Value Expressions: CASE, CAST, and Row Value Expressions -- 7 Predicates -- 8 Working with Multiple Tables: The Relational Operators -- 9 Advanced SQL Query Expressions -- 10 Constraints, Assertions, and Referential Integrity -- 11 Accessing SQL from the Real World -- 12 Cursors -- 13 Privileges, Users, and Security -- 14 Transaction Management -- 15 Connections and Remote Database Access -- 16 Dynamic Sql -- 17 Diagnostics and Error Management -- 18 Internationalization Aspects of SQL-92 -- 19 Information Schema -- 20 A Look to the Future -- A Designing SQL-92 Databases -- B A Complete SQL-92 Example -- C The SQL-92 Annexes: Differences, Implementation-Defined and Implementation-Dependent Features, Deprecated Features, and Leveling -- D Relevant Standards Bodies -- E Status Codes -- F The SQL Standardization Process -- G The Complete SQL-92 Language -- Library of Congress subject headings for this publication |
Summary |
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 implementation of SQL |
Notes |
Includes index |
Subject |
Database management.
|
|
Query languages (Computer science)
|
|
SQL (Computer program language)
|
Author |
Simon, Alan R.
|
LC no. |
92038385 |
ISBN |
1558602453 |
|