Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
29 used & new from £28.04
Have one to sell? Sell yours here
 
   
Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
 
 
Share your own customer images
Search inside this book

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: £38.00 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £2.00 (5%)
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 2 left in stock--order soon (more on the way).

Want guaranteed delivery by Tuesday, July 7? Choose Express delivery at checkout. See Details
22 new from £28.04 7 used from £41.01
Other Editions: RRP: Our Price: Other Offers:
Paperback (2nd Revised edition) £34.99 £29.74 11 used & new from £21.63

Frequently Bought Together

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)
Price For All Three: £76.32

Show availability and shipping details

Customers Who Bought This Item Also Bought

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

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

by Joe Celko
1.0 out of 5 stars (1)  £21.24
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

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

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

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

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

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

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

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: 134,790 in Books (See Bestsellers in Books)

    Popular in these categories:

    #35 in  Books > Computing & Internet > Databases > SQL
    #86 in  Books > Computing & Internet > Databases > Applications > 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
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below
(1)
(1)
(1)

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
76% 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)
£38.00
Learning SQL
8% buy
Learning SQL 5.0 out of 5 stars (2)
£24.29
Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)
6% buy
Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)
£24.99
SQL Hacks
5% buy
SQL Hacks 3.0 out of 5 stars (1)
£15.99
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:
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)



 
3 of 3 people found the following review helpful:
5.0 out of 5 stars Very good advice for advanced, standard compliant SQL , 10 Mar 2007
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
 
 
 
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 20 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

Only search this product's reviews


Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   

Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject

















i.e., each product must be in subject 1 AND subject 2 AND ...

Feedback

Health & Beauty at Amazon.co.uk

Elemis Resurface and Renew Skin Care Gift Set of 4 Products
From soap to shavers, massagers to mascara, stock up on your daily essentials or truly pamper yourself.

›Discover Health & Beauty

  

More From Joe Celko

Joe Celko's Thinking...

Joe Celko's Thinking in Sets...

Perfectly intelligent programmers often struggle when forced to work... Read more
£17.08

 

Up to 50% off Dental Care

Braun Oral-B Professional Care 6000 Rechargeable Toothbrush - Pack of 2
Put a sparkle in your smile with up to 50% off selected Oral-B and Philips rechargeable toothbrushes.

›Up to 50% off power toothbrushes

  

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

  
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates