MTU Cork Library Catalogue

Understanding the new SQL : a complete guide /

Melton, Jim, 1946-

Understanding the new SQL : a complete guide / Jim Melton and Alan R. Simon. - San Mateo, Calif. : Morgan Kaufmann Publishers, 1993. - xxiv, 536 p. : ill. ; 24 cm. - Morgan Kaufmann series in data management systems. .

Includes index.

Part I: SQL-92 Basics -- Introduction to SQL-92 -- Getting started with SQL-92 -- Basic table creation and data manipulation -- Basic Data Definition Language (DDL) -- Values, Basic Functions and Expressions -- Part II: Advanced Features of SQL-92 -- Advanced Value Expressions: CASE, CAST and Row Value Expressions -- Predicates -- Working with Multiple Tables: The Relational Operators -- Advanced SQL Query Expressions -- Constraints, Assertions and Referential Integrity -- Part III: SQL and Applications -- Accessing SQL from the Real World -- Cursors -- Privileges, Users and Security -- Transaction Management -- Connections and Remote Database Access -- Dynamic SQL -- Part IV: The Finishing Touches -- Diagnostics and Error Management -- Internationalization Aspects of SQL-92 -- Information Schema -- A look to the future.

1558602453

92038385


Database management
SQL (Computer program language)

005.756

Powered by Koha