SQL:1999 : understanding relational language components /

Mostrar otras versiones (2)

This book is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Melton, Jim, 1946-
Otros Autores: Simon, Alan, 1958-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: San Francisco : Academic Press, ©2002.
Colección:Morgan Kaufmann Series in Data Management Systems.
Temas:
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données > Gestion.
COMPUTERS > Programming Languages > SQL.
Sql.
SQL (langage de programmation)
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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.

Ejemplares similares