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
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