Joe Celko's SQL for Smarties, Third Edition and over 900,000 other books are available for Amazon Kindle . Learn more

Quantity:

More Buying Choices

Have one to sell? Sell yours here

Share your own customer images

Search inside this book

Start reading Joe Celko's SQL for Smarties, Third Edition on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Joe Celko (Author)

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

RRP:	�38.99
Price:	�37.04 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Deal Price:
You Save:	�1.95 (5%)
	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

Usually dispatched within 6 to 9 days.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

	Amazon Price	New from	Used from
Kindle Edition	�22.49	--	--
Show # more Kindle books
Show fewer Kindle books
Paperback	�29.99	--	--
Paperback, 23 Aug 2005	�37.04	--	--
Show # more paperbacks
Show fewer paperbacks

Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Amazon.co.uk Trade-In Store for more details.

› See more product promotions

There is a newer edition of this item:

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) 3.9 out of 5 stars (10)
�29.99

In stock.

Frequently Bought Together

Price For All Three: �80.59

Some of these items are dispatched sooner than the others. Show details

Buy the selected items together

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

Usually dispatched within 6 to 9 days.
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 Joe Celko Paperback �18.04

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 Paperback �25.51

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

SQL Cookbook (Cookbooks (O'Reilly)) by Anthony Molinaro
4.5 out of 5 stars (4)

�19.83
Joe Celko's SQL Puzzles and Answers, Second Edit... by Joe Celko

�34.31
Joe Celko's Thinking in Sets: Auxiliary, Tempora... by Joe Celko
3.0 out of 5 stars (2)

�18.04
Joe Celko's Trees and Hierarchies in SQL for Sma... by Joe Celko
3.7 out of 5 stars (3)

�25.51
Joe Celko's Analytics and OLAP in SQL (The Morga... by Joe Celko
4.0 out of 5 stars (1)

�29.44
Inside Microsoft SQL Server 2008: T-SQL Programm... by Itzik Ben-gan
5.0 out of 5 stars (1)

�25.27

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 (10 customer reviews)

Amazon Bestsellers Rank: 601,814 in Books (See Top 100 in Books)
- #75 in Books > Computers & Internet > Computer Science > Databases > SQL

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

See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

› Visit Amazon's Joe Celko Page

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)

Agree with these tags?

What Other Items Do Customers Buy After Viewing This Item?

SQL Cookbook (Cookbooks (O'Reilly)) by Anthony Molinaro Paperback
4.5 out of 5 stars (4)

�19.83

Oracle SQL by Example (Prentice Hall PTR Oracle) by Alice Rischert Paperback
4.5 out of 5 stars (2)

�38.71

Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko Paperback

�34.31

SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL by John L. Viescas Paperback

�36.15

› Explore similar items

Customer Reviews

10 Reviews

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

Average Customer Review

3.9 out of 5 stars (10 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

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

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

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

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.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse | Permalink

Comment Comment

4 of 4 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.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse | Permalink

Comment Comment

2 of 2 people found the following review helpful:

4.0 out of 5 stars Makes you think..., 19 Mar 2006

I. Lewis "Book Meme" (London United Kingdom) - See all my reviews
(REAL NAME)

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

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 provoking and very positive because some of the techniques outlined by Joe Celko are new to me. However it was very positive to see that some things I had already tried were in the book.

Well presented, logical in approach and quite an entertaining read considering SQL is such a dry subject.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse | Permalink

Comment Comment

Share your thoughts with other customers: Create your own review

› See all 10 customer reviews on Amazon.co.uk

Would you like to see more reviews about this item?

› Go to Amazon.com to see all 59 reviews 4.2 out of 5 stars

Were these reviews helpful? Let us know

Most Recent Customer Reviews

5.0 out of 5 stars Superb SQL Book one of the best
I highly recommend this excellent book - I've read over 50 database books and this is in my top 5.
Mr Celko writes in a highly opinionated, slightly arrogant style, I can... Read more

Published 3 months ago by Gary Clarke

3.0 out of 5 stars Good but many errors
I have always admired Joe Celko for bringing SQL smarts to SQL programming. This book is a very good step forward over the previous books. Read more

Published 13 months ago by S. Rafiq

4.0 out of 5 stars Celko: Top man!
OK, so 2nd Ed. is somewhat out of date, but more than adequate for my needs (as an all-round smarty-pants rather than a SQL expert), especially for the asking price... Read more

Published on 10 Dec 2009 by Prometheus

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

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

4.0 out of 5 stars Excellent book
Lots of examples of complicated/advanced SQL. Not for people who need to learn SQL.

Published on 29 April 1997

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 10 customer reviews on Amazon.co.uk

.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; }