Buy Used
£0.01
+ £2.80 UK delivery
Used: Good | Details
Sold by Greener_Books
Condition: Used: Good
Comment: **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence!
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Joe Celko's SQL for Smarties: Advanced SQL Programming Paperback – 1 Jul 1995

3.7 out of 5 stars 11 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£23.40 £0.01
click to open popover

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.



Product details

  • Paperback: 467 pages
  • Publisher: Morgan Kaufmann Publishers In (July 1995)
  • Language: English
  • ISBN-10: 1558603239
  • ISBN-13: 978-1558603233
  • Product Dimensions: 2.5 x 18.4 x 23.5 cm
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Bestsellers Rank: 1,666,760 in Books (See Top 100 in Books)
  • If you are a seller for this product, would you like to suggest updates through seller support?

  • See Complete Table of Contents

Product description

Amazon 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.

Customer Reviews

3.7 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Kindle Edition Verified Purchase
It does contain tons of knowledge and examples but it is only really useful if you're looking for a solution to a particular problem rather than just a book that goes beyond simple select and update
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: 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 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: 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.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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 reader actually learn the language.
Examples are scarce and many of them are C code rather than SQL.
I was very disappointed with this book and must continue my
search for an SQL textbook.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on 29 April 1997
Format: Paperback
Lots of examples of complicated/advanced SQL. Not for people who need to learn SQL.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse