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

Mostrar otras versiones (10)

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL m...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Celko, Joe
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Amsterdam ; Boston : 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)
COMPUTERS > Programming Languages > C♯
COMPUTERS > Programming Languages > Java.
COMPUTERS > Programming Languages > Pascal.
Programmeertalen.
SQL.
dissertations.
Academic theses
Academic theses.
Thèses et écrits académiques.
Acceso en línea:Texto completo
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