Joe Celko's SQL for smarties : advanced SQL programming /: advanced SQL programming. (©2005)

• Record Type: Book
• Other Titles: SQL for smarties
• Uniform Title: SQL for smarties
• Further Information: Note: Joe Celko.
• Other Names: Celko, Joe
• 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.
• Edition: 3rd ed
• Publisher Details: Amsterdam Boston : Morgan Kaufmann
• Publication Date: 2005
• Copyright Date: 2005
• Extent: 1 online resource (xxviii, 808 pages), illustrations
• Subjects: 005.13/3; SQL (Computer program language); COMPUTERS -- Programming Languages -- C♯; COMPUTERS -- Programming Languages -- Java; COMPUTERS -- Programming Languages -- Pascal; SQL (Computer program language); Programmeertalen; SQL; Electronic books; Electronic books
• Languages: English
• ISBNs: 0080460046; 9780080460048
• Related ISBNs: 0123693799; 9780123693792
• Notes: Note: Includes bibliographical references and index.; Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.