SQL:1999 : understanding relational language components /

Afficher d'autres versions (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...

Description complète

Détails bibliographiques
Cote:Libro Electrónico
Auteur principal: Melton, Jim, 1946-
Autres auteurs: Simon, Alan, 1958-
Format: Électronique eBook
Langue:Inglés
Publié: San Francisco, Calif. ; London : Morgan Kaufmann, ©2002.
Collection:Morgan Kaufmann series in data management systems.
Sujets:
SQL (Computer program language)
Database management.
Relational databases.
Bases de données relationnelles.
SQL (Langage de programmation)
Bases de données > Gestion.
Accès en ligne:Texto completo (Requiere registro previo con correo institucional)
Table des matières:
  • 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.

Documents similaires