Programming Books C Java PHP Python Learn more Browse Programming Books
Qty:1
  • List Price: $44.95
  • Save: $10.18 (23%)
FREE Shipping on orders over $35.
Only 15 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
FREE Shipping on orders over $35.
Condition: Used: Good
Comment: Minor cosmetic damage on the front of the item. Minor cosmetic damage to the back of the item. Minor cosmetic damage to the bottom of the item. Minor cosmetic damage to the sides of the item. Minor cosmetic damage to the top of the item.
Access codes and supplements are not guaranteed with used items.
Sell yours for a Gift Card
We'll buy it for $12.50
Learn More
Trade in now
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: $34.77
27 New from $25.35 13 Used from $25.57
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$10.88
Paperback
"Please retry"
$34.77
$25.35 $25.57
Free Two-Day Shipping for College Students with Amazon Student 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: $93.99

Buy the selected items together
NO_CONTENT_IN_FEATURE
Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. 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.5 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #338,597 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.5 out of 5 stars
5 star
10
4 star
6
3 star
0
2 star
1
1 star
0
See all 17 customer reviews
It's laid out well and progresses in a logical manner.
ILoveGadgets
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.
Kurt G. Schumacher
Joe Celko writes well about SQL, and his earlier "SQL for Smarties" is a good book.
Dave

Most Helpful Customer Reviews

4 of 4 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
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
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 Vine Customer Review of Free Product ( What's this? )
Well, I mean to speed up your software that has any attachment to databases and if there is any kind of hierarchy in your data structure that's slowing it down. And that's probably exactly what's slowing down your software at this point, so get this book for your developers and DBAs. If you have any kind of bill of materials, complex recipe, any kind of genealogy, multi-level-marketing information, organization chart, sales data, or anything even remotely like this, then this book will be extremely helpful.

This book covers a ton of different methods for better speed and data access of hierarchical databases. It covers graph theory, how to write recursive queries, how to change your data structure to better traverse hierarchies, and much more.

The only drawback is that you really have to be pretty smart to implement anything in this book.

**Full disclosure** I received a complimentary copy of this product, and then I liked it so much that I got two more for friends and coworkers.

Pros:
+Extremely useful
+Awesome book
+Covers a ton of theory, with a ton of application
+Uses standard SQL, so the samples here work on almost any database
+Even though it's complex and about a complex topic, it's very readable and accessible

Cons:
-You need to be pretty smart to implement much of this
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

Most Recent Customer Reviews