Description |
1 online resource (xxviii, 808 pages) : illustrations |
Series |
Morgan Kaufmann series in data management systems |
|
Morgan Kaufmann series in data management systems.
|
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 |
Summary |
"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 |
Bibliography |
Includes bibliographical references (pages 761-771) and index |
Notes |
Print version record |
Subject |
SQL (Computer program language)
|
|
SQL (Computer program language)
|
|
SQL (Computer program language)
|
Form |
Electronic book
|
ISBN |
9780123693792 |
|
0123693799 |
|