Joe Celko's SQL for smarties : advanced SQL programming /

Mostrar otras versiones (10)

"In the third edition, Joe Celko features new examples and update to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics."--Jacket

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Celko, Joe
Formato: Electrónico eBook
Idioma:Inglés
Publicado: San Francisco, Calif. : Morgan Kaufmann, Ã2005.
Edición:3rd ed.
Colección:Morgan Kaufmann series in data management systems.
Temas:
SQL (Computer program language)
SQL (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Database design
  • Normalization
  • Numeric data in SQL
  • Temporal data types in SQL
  • Character data types in SQL
  • NULLs : missing data in SQL
  • Multiple column data elements
  • Table operations
  • Comparison or theta operators
  • Valued predicates
  • CASE expressions
  • LIKE predicate
  • Between and overlaps predicates
  • The [NOT] IN() predicate
  • EXISTS() predicate
  • Quantified subquery predicates
  • The SELECT statement
  • VIEWs, derived tables, materialized tables, and temporary tables
  • Partitioning data in queries
  • Grouping operations
  • Aggregate functions
  • Auxiliary tables
  • Statistics in SQL
  • Regions, runs, gaps, sequences, and series
  • Arrays in SQL
  • Set operations
  • Subsets
  • Trees and hierarchies in SQL
  • Temporal queries
  • Graphs in SQL
  • OLAP in SQL
  • Transactions and concurrency control
  • Optimizing SQL.

Ejemplares similares