عنوان

Joe Celko's SQL for smarties

(Number (ISBN

0123693799

(Number (ISBN

9780123693792

Number

b409976

Title Proper

Joe Celko's SQL for smarties

General Material Designation

[Book]

Other Title Information

advanced SQL programming /

First Statement of Responsibility

Joe Celko

Edition Statement

3rd ed

Place of Publication, Distribution, etc.

San Francisco, Calif. :

Name of Publisher, Distributor, etc.

Morgan Kaufmann,

Date of Publication, Distribution, etc.

c2005

Specific Material Designation and Extent of Item

xxviii, 808 p. :

Other Physical Details

ill.

Dimensions

24 cm

Series Title

Morgan Kaufmann series in data management systems

Text of Note

Includes bibliographical references (p. 761-771) and index

Text of Note

Available to subscribing institutions.

Text of Note

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

0

Source for Acquisition/Subscription Address

Safari Books Online

Stock Number

CL0500000038

General Material Designation

SQL for smarties

Parallel Title

SQL for smarties

SQL (Computer program language)

Class number

Book number

Celko, Joe

Ohio Library and Information Network

Date of Transaction

20090427103502.0

Electronic name

[Book]

Y