SQL bible /

"Combining theory with everyday practicality, this definitive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to th...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Kriegel, Alex
Otros Autores: Trukhnov, Boris M.
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Wiley, Ã2008.
Edición:2nd ed.
Temas:
SQL (Computer program language)
SQL (Langage de programmation)
COMPUTERS > Programming Languages > SQL.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • pt. I. SQL basic concepts and principles
  • SQL and relational database management systems
  • Fundamental SQL concepts and principles
  • SQL data types
  • pt. II. Creating and modifying database objects
  • Creating RDBMS objects
  • Altering and destroying RDBMS objects
  • pt. III. Data manipulation and transaction control
  • Data manipulation language (DML)
  • Sessions, transactions, and locks
  • pt. IV. Retrieving and transferring data
  • Understanding the select statement
  • Multitable queries
  • SQL functions
  • SQL operators
  • pt. V. Implementing security using the system catalog
  • SQL and RDBMS security
  • The system catalog and information schema
  • pt. VI. Beyond SQL: procedural programming and database access mechanisms / Stored procedures, triggers, and user-defined functions
  • SQL and XML
  • SQL and procedural programming
  • The future of SQL.

Ejemplares similares