|
" Joe Celko's SQL for smarties "
Joe Celko
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
580757
|
| Doc. No
|
:
|
b409976
|
| Uniform Title
|
:
|
SQL for smarties
|
| Main Entry
|
:
|
Celko, Joe
|
| Title & Author
|
:
|
Joe Celko's SQL for smarties : advanced SQL programming /\ Joe Celko
|
| Edition Statement
|
:
|
3rd ed
|
| Publication Statement
|
:
|
San Francisco, Calif. :: Morgan Kaufmann,, c2005
|
| Series Statement
|
:
|
Morgan Kaufmann series in data management systems
|
| Page. NO
|
:
|
xxviii, 808 p. :: ill.; 24 cm
|
| ISBN
|
:
|
9780123693792
|
|
|
:
|
: 0123693799
|
| Bibliographies/Indexes
|
:
|
Includes bibliographical references (p. 761-771) and index
|
| Contents
|
:
|
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
|
| Subject
|
:
|
SQL (Computer program language)
|
| LC Classification
|
:
|
QA76.73.S67C44 2005
|
| Added Entry
|
:
|
Ohio Library and Information Network
|
| Parallel Title
|
:
|
SQL for smarties
|
| |