skip to content
Joe Celko's SQL for smarties : advanced SQL programming Preview this item
ClosePreview this item
Checking...

Joe Celko's SQL for smarties : advanced SQL programming

Author: Joe Celko
Publisher: Amsterdam ; Boston : Morgan Kaufmann, ©2005.
Series: Morgan Kaufmann series in data management systems.
Edition/Format:   Print book : English : 3rd edView all editions and formats
Database:WorldCat
Summary:

Offers solutions to challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. This edition teaches various  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Joe Celko
ISBN: 0123693799 9780123693792
OCLC Number: 61513309
Description: xxviii, 808 pages : illustrations ; 24 cm.
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.
Series Title: Morgan Kaufmann series in data management systems.
Other Titles: SQL for smarties
SQL for smarties
Responsibility: Joe Celko.
More information:

Reviews

Editorial reviews

Publisher Synopsis

"This book is a classic, and this revision will merely solidify its position." --Rudy Limeback

 
User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/61513309> # Joe Celko's SQL for smarties : advanced SQL programming
    a schema:CreativeWork, schema:Book ;
   library:oclcnum "61513309" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/ne> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/588825#Place/amsterdam> ; # Amsterdam
   library:placeOfPublication <http://dbpedia.org/resource/Boston> ; # Boston
   schema:about <http://experiment.worldcat.org/entity/work/data/588825#Topic/sql> ; # SQL
   schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
   schema:about <http://dewey.info/class/005.133/e22/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/588825#Topic/programmeertalen> ; # Programmeertalen
   schema:alternateName "SQL for smarties" ;
   schema:bookEdition "3rd ed." ;
   schema:bookFormat bgn:PrintBook ;
   schema:copyrightYear "2005" ;
   schema:creator <http://viaf.org/viaf/50934021> ; # Joe Celko
   schema:datePublished "2005" ;
   schema:description "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."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/588825> ; # SQL for smarties
   schema:inLanguage "en" ;
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/588825#Series/the_morgan_kaufmann_series_in_data_management_systems> ; # The Morgan Kaufmann series in data management systems
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/588825#Series/morgan_kaufmann_series_in_data_management_systems> ; # Morgan Kaufmann series in data management systems.
   schema:name "Joe Celko's SQL for smarties : advanced SQL programming"@en ;
   schema:productID "61513309" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/61513309#PublicationEvent/amsterdam_boston_morgan_kaufmann_2005> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/588825#Agent/morgan_kaufmann> ; # Morgan Kaufmann
   schema:url <http://catdir.loc.gov/catdir/enhancements/fy0626/2005279919-t.html> ;
   schema:url <http://site.ebrary.com/id/10138250> ;
   schema:workExample <http://worldcat.org/isbn/9780123693792> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/61513309> ;
    .


Related Entities

<http://dbpedia.org/resource/Boston> # Boston
    a schema:Place ;
   schema:name "Boston" ;
    .

<http://experiment.worldcat.org/entity/work/data/588825#Agent/morgan_kaufmann> # Morgan Kaufmann
    a bgn:Agent ;
   schema:name "Morgan Kaufmann" ;
    .

<http://experiment.worldcat.org/entity/work/data/588825#Series/morgan_kaufmann_series_in_data_management_systems> # Morgan Kaufmann series in data management systems.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/61513309> ; # Joe Celko's SQL for smarties : advanced SQL programming
   schema:name "Morgan Kaufmann series in data management systems." ;
    .

<http://experiment.worldcat.org/entity/work/data/588825#Series/the_morgan_kaufmann_series_in_data_management_systems> # The Morgan Kaufmann series in data management systems
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/61513309> ; # Joe Celko's SQL for smarties : advanced SQL programming
   schema:name "The Morgan Kaufmann series in data management systems" ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
   schema:name "SQL (Computer program language)"@en ;
    .

<http://viaf.org/viaf/50934021> # Joe Celko
    a schema:Person ;
   schema:familyName "Celko" ;
   schema:givenName "Joe" ;
   schema:name "Joe Celko" ;
    .

<http://worldcat.org/entity/work/id/588825> # SQL for smarties
   schema:name "SQL for smarties" ;
    .

<http://worldcat.org/isbn/9780123693792>
    a schema:ProductModel ;
   schema:isbn "0123693799" ;
   schema:isbn "9780123693792" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.