Programming Books C Java PHP Python Learn more Browse Programming Books
Buy New
$31.06
Qty:1
  • List Price: $44.95
  • Save: $13.89 (31%)
FREE Shipping on orders over $35.
Only 8 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $10.51
Gift Card.
Have one to sell? Sell on Amazon
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 Trees and Hierarchies in SQL for Smarties, Second Edition (The Morgan Kaufmann Series in Data Management Systems) Paperback – February 3, 2012

ISBN-13: 978-0123877338 ISBN-10: 0123877334 Edition: 2nd

Buy New
Price: $31.06
28 New from $25.80 8 Used from $26.02
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$14.28
Paperback
"Please retry"
$31.06
$25.80 $26.02

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Joe Celko's Trees and Hierarchies in SQL for Smarties, Second Edition (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's SQL for Smarties, Fourth Edition: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) + SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)
Price for all three: $102.85

Buy the selected items together

NO_CONTENT_IN_FEATURE
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Paperback: 296 pages
  • Publisher: Morgan Kaufmann; 2 edition (February 3, 2012)
  • Language: English
  • ISBN-10: 0123877334
  • ISBN-13: 978-0123877338
  • Product Dimensions: 9.1 x 7.4 x 0.8 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon Best Sellers Rank: #133,009 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

More About the Author

I was a member of the ANSI X3H2 Database Standards Committee from 1987 to 1997 and helped write the ANSI/ISO SQL-89 and SQL-92 Standards. I have nine books and have written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

I live in Austin,TX. When I am not writing, I am consulting, speaking at conferences, teaching SQL training classes anywhere on Earth or beating up newbies in SQL Newsgroups.

The rumor that I own only one black suit that I have worn for 30 years is false; I own six identical black suits that I have worn for 30 years.

Customer Reviews

4.4 out of 5 stars
5 star
9
4 star
6
3 star
0
2 star
1
1 star
0
See all 16 customer reviews
It's laid out well and progresses in a logical manner.
ILoveGadgets
Joe Celko writes well about SQL, and his earlier "SQL for Smarties" is a good book.
Dave
This book is about the representation of hierarchical data in SQL.
Patrick Regan

Most Helpful Customer Reviews

4 of 4 people found the following review helpful By Dave on March 17, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
Joe Celko writes well about SQL, and his earlier "SQL for Smarties" is a good book. This one expands what he's done with trees and heirarchies, and does so in a straightforward manner.

There's a limited audience for this book, as many SQL developers just won't need to deal with these data types, or they'll deal with fixed, mixed-type trees (such as Customer->Account->Transactions) in which many of these techniques won't be needed.

Also, some database systems (such as Oracle) have very powerful proprietary SQL dialects that will do obviate the need for much of this - if you are willing to use a DBMS-specific solution. But this book is written in a dialect-agnostic way.

I think the nicest thing about this book is that I've seen really bad table designs created just to avoid having to deal with trees and hierarchies, and this wook should help people avoid that and yet still feel thay will be able to program effectively using those kinds of designs.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Kurt G. Schumacher VINE VOICE on April 19, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
I thought I knew my SQL, but this book showed me that I have a LOT to learn! SQL stands for Structured Query Language, and my use of the language has always been pretty much limited to "sentences". Select this, update that, delete something. I've even done a few simple procedures ("paragraphs"). And I've done some of the things described in this book ... trees and hierarchies ... in programming languages like PERL with occasional SQL statements.

This book shows how to do those things strictly in SQL. It made me realize that SQL itself can really be a programming language. You can write pretty heavy-duty programs just with SQL. That made my brain hurt!

A lot of the material covered in the book is way more advanced than I can handle right now, and more than I really need. But I've found over and over again that if I say, "I'll never need that," it's only a matter of time until I do need it. And even if I don't need anything as advanced as this, I've already learned a lot about what SQL can do.

I'm going to look up Joe Celko's other SQL books. I need to make my brain hurt some more.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Philosophically Yours VINE VOICE on June 1, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
I feel graphs and tree are the core set of data structures used in most of the applications today and historically we have always modeled such network type data in relational databases for storage & retrieval. Naturally, the relational database doesn't fit out of the box to meet all read/aggregated read requirements for such data sets and even seasoned developers struggle to find a good solution to the problem at hand with such data. Joe Celko has attacked this area and described it at length in this book.

The book has 15 chapters to discuss the problems and a few proposed solutions at length. I feel the chapters are simple, easy to read, to the point and are always illustrated with meaningful examples to educate & engage the readers. The book starts with an introduction to the data problems with graph, tree and hierarchies and then discusses common data models to store & read such data and the current problems with such solutions. Further down the line, it discusses about the common real world problems that many data engineers or architect face today and proposes solutions. Finally, there are discussions around graphs in SQL and some specific cases around this area, which are really nice.

I liked the way this book deals with such a specific topic and I liked various ideas proposed through the chapters. This book has a specific set of audience but has very good set of ideas that are very relevant in today's world of data engineering.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Gina Pera VINE VOICE on April 29, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
This review comes from my husband, who actually understands this book's contents:

Joe Celko is my favorite writer when it comes to SQL. He holds true to form
with this book. It's got everything you might want to know about handling
trees in SQL, written in a vendor-independent way. Easy to read, accurate,
lots of interesting solutions. It's so nice I have it in both Kindle *and*
hard-copy form.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Luckyclucker VINE VOICE on March 14, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
Joe Celko has written a very good book on the architecture of trees and hierarchies in sql. That should have gotten the attention of a very limited audience. Yes, this book is not for light reading, it is for people who really need to understand the differences between trees vs hierarchies and how they might be used in database applications. It probably won't leave anyone understanding the whole science but it will help them focus on what they need to build the type of queries and data structures to store.This book is a collection of his articles put together to make some sense for those who need to know this pretty specific information. Does it cover everything. No. Does it go off on tangents. Not really. It does a good job of going over some very deep stuff in a fairly engaging way.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
Wow, you have to work hard to keep up with this very advanced book. It's sitting on my shelf as an essential reference book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Kindle Edition Verified Purchase
I used the book to learn about graph modelling within an environment that I knew. The author explains things very well (from a programmer perspective).
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Kindle Edition Verified Purchase
Littered with small errors which decrease reading speed and poorly referenced sources of data (introduces several tables with similar data without propper distinction).
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search