Database and technology foundations -- Introduction to SQL:1999 -- Basic table creation and data manipulation -- Basic Data Definition Language (DDL) -- Values, basic functions, and expressions -- 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 -- Active databases and triggers -- Accessing SQL from the real world -- Cursors -- Privileges, users, and security -- Transaction management -- Connections and remote database access -- Routines and routine invocation (functions and procedures) -- Dynamic SQL -- Call-level interface (CLI) -- Diagnostics and error management -- Internationalization aspects of SQL:1999 -- Information schema -- A look to the future -- Designing SQL:1999 databases -- An SQL:1999 application example -- The SQL:1999 annexes -- Relevant standards bodies -- Status codes -- The SQL standardization process.
0
SYSTEM REQUIREMENTS NOTE (ELECTRONIC RESOURCES)
Text of Note
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.