Joe Celko's SQL for smarties advanced SQL programming

"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

Bibliographic Details
Main Author: Celko, Joe
Format: eBook
Language:English
Published: San Francisco, Calif. Morgan Kaufmann 2005
Edition:3rd ed
Series:Morgan Kaufmann series in data management systems
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 02372nmm a2200361 u 4500
001 EB001928724
003 EBX01000000000000001091626
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9780123693792 
050 4 |a QA76.73.S67 
100 1 |a Celko, Joe 
130 0 |a SQL for smarties 
245 0 0 |a Joe Celko's SQL for smarties  |b advanced SQL programming  |c Joe Celko 
246 3 1 |a SQL for smarties 
250 |a 3rd ed 
260 |a San Francisco, Calif.  |b Morgan Kaufmann  |c 2005 
300 |a xxviii, 808 pages  |b illustrations 
505 0 |a Includes bibliographical references (pages 761-771) and index 
505 0 |a 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. 
653 |a SQL (Computer program language) / blmlsh 
653 |a SQL (Langage de programmation) 
653 |a SQL (Computer program language) / fast 
653 |a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a Morgan Kaufmann series in data management systems 
776 |z 0123693799 
776 |z 9780123693792 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780123693792/?ar  |x Verlag  |3 Volltext 
082 0 |a 005.13/3 
520 |a "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