SQL:1999 understanding relational language components
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...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
San Francisco, Calif. ; London :
Morgan Kaufmann
2002.
|
| Colección: | The Morgan Kaufmann series in data management systems.
|
| Acceso en línea: | Conectar con la versión electrónica |
| Ver en Universidad de Navarra: | https://innopac.unav.es/record=b37511786*spi |
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.
