Quantity:

More Buying Choices

35 used & new from �20.59

Have one to sell? Sell yours here

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) (Paperback)

by Joe Celko (Author) "The major problem in learning SQL is that programmers are used to thinking in terms of files rather than tables ..." (more)

3.9 out of 5 stars See all reviews (7 customer reviews)

RRP:	�40.00
Price:	�37.00 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�3.00 (8%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Friday, November 13? Choose Express delivery at checkout. See Details

28 new from �21.97 7 used from �20.59

Other Editions:	RRP:	Our Price:	Other Offers:
Paperback (2nd Revised edition)	�34.99	�34.99	11 used & new from �19.33

Frequently Bought Together

Price For All Three: �68.14

Show availability and delivery details

This item: Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems) by Celko
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

by Celko

�13.46

Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko

3.0 out of 5 stars (2) �17.68

Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko

�22.94

Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko

�21.24

Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko

�25.50

› Explore similar items

Product details

Paperback: 840 pages
Publisher: Morgan Kaufmann; 3 edition (23 Aug 2005)
Language English
ISBN-10: 0123693799
ISBN-13: 978-0123693792
Product Dimensions: 23.1 x 18.8 x 4.8 cm

Average Customer Review: 3.9 out of 5 stars See all reviews (7 customer reviews)

Amazon.co.uk Sales Rank: 160,847 in Books (See Bestsellers in Books)
Popular in this category:
#25 in Books > Computing & Internet > Databases > SQL

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

Amazon.co.uk Review

In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques and explanations that help readers extend their capabilities to top-tier SQL programming.

Although Celko denies that the book is about database theory, he often alludes to theory to buttress his practical points. This title is not for novices, as the author points out. Instead its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of subjects.

The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. However, it does not focus on any commercial product but rather zeroes in on the SQL language. Celko covers all aspects of database design, optimisation and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalisation and how to optimise queries.

This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W.Plain

Topics covered:
Database design and normalisation, SQL data types, querying, grouping, set operations, optimisation, data scaling and encoding. --This text refers to an out of print or unavailable edition of this title.

Review

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

See all Product Description

Inside This Book (Learn More)

First Sentence
The major problem in learning SQL is that programmers are used to thinking in terms of files rather than tables. Read the first page

Explore More
Concordance

Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index

Tags Customers Associate with This Product

(What's this?)

Click on a tag to find related items, discussions, and people.

database(1)

programming(1)

sql(1)

What Do Customers Ultimately Buy After Viewing This Item?

	83% buy the item featured on this page: Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) 3.9 out of 5 stars (7) �37.00
	7% buy Learning SQL 5.0 out of 5 stars (2) �17.70
	4% buy Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) 3.0 out of 5 stars (2) �17.68
	3% buy Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems) �21.24

Explore similar items

Customer Reviews

7 Reviews

5 star:		(2)
4 star:		(3)
3 star:		(1)
2 star:		(1)
1 star:		(0)

Average Customer Review

3.9 out of 5 stars (7 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

5.0 out of 5 stars If you know some SQL and want to learn more, this is it!, 25 May 1998

By A Customer

This review is from: Joe Celko's SQL for Smarties: Advanced SQL Programming (Paperback)

This book is not his basic volume in SQL, but his advanced volume. It helps you along explaining different issues with an excellent explanation of NULLS, their pros and their cons. It gives examples of solving problems in different SQL ways. A great buy.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

5 of 5 people found the following review helpful:

4.0 out of 5 stars Excellent book, 29 April 1997

By A Customer

This review is from: Joe Celko's SQL for Smarties: Advanced SQL Programming (Paperback)

Lots of examples of complicated/advanced SQL. Not for people who need to learn SQL.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

4 of 4 people found the following review helpful:

5.0 out of 5 stars Very good advice for advanced, standard compliant SQL , 10 Mar 2007

By	Mr. Matthew P. Cooke "A Programmer" (London) - See all my reviews (REAL NAME)

If you like writing massive stored procedures, using cursors and other non-relational and non standard features of your database then this book probably won't appeal to you much.

Joe Celko puts a lot of effort into showing how you can write high performance and standard SQL without resorting to proprietary hacks. He clearly has a very strong understanding of the underlying theory behind relational databases and uses plenty of examples to explain his points.

I would recommend this book as a very good read to generally improve your overall knowledge of SQL and SQL best practices.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 7 customer reviews...

Most Recent Customer Reviews

4.0 out of 5 stars Useful yet opinionated.
Large parts of this book are undoubtedly excellent as the author is intelligent. However, there are many parts where the author expresses opinion without understanding that life... Read more

Published on 13 Nov 2006 by B. Prajapati

4.0 out of 5 stars Makes you think...
I bought this book as it was mentioned on a couple of SQL users' websites/mailing lists.

I am relatively new to SQL (2yrs experience) and I found the book quite thought... Read more

Published on 19 Mar 2006 by Ian Lewis

3.0 out of 5 stars Impractical, but interesting tricks.
These are interesting techniques in SQL, that can be fun in the office. The problem is that in the real world manufacturers don't implement standard SQL and if you want Advanced... Read more

Published on 26 Jan 1999

2.0 out of 5 stars A lot of ideas, but little instruction
This book gives many tips for how to structure your database and about the behavior of some SQL commands (much of which is common sense anyway), but does nothing to help the... Read more

Published on 1 Nov 1996

› See all 7 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }