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

by Joe Celko (Author)

15 ratings

ISBN-13: 978-0123877338

ISBN-10: 0123877334

Why is ISBN important?

Added to

Unable to add item to List. Please try again.

Share <Embed>

eBook features:

Highlight, take notes, and search in the book
Length: 296 pages
Enhanced Typesetting: Enabled
Page Flip: Enabled
Similar books to Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems)

Read with the free Kindle apps (available on iOS, Android, PC & Mac), Kindle E-readers and on Fire Tablet devices. See all supported devices

Sold by: Amazon Digital Services LLC

includes VAT

Digital List Price: $44.95

Print List Price: $44.95 Save $15.81 (35%)‎

Deliver to your Kindle or other device

Enter a promotion code or Gift Card

eBook features:

Highlight, take notes, and search in the book
Length: 296 pages
Enhanced Typesetting: Enabled
Page Flip: Enabled
Similar books to Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems)

Read with the free Kindle apps (available on iOS, Android, PC & Mac), Kindle E-readers and on Fire Tablet devices. See all supported devices

Sold by: Amazon Digital Services LLC

includes VAT

Today through selected date:

Rental price is determined by end date.

Deliver to your Kindle or other device

Enter a promotion code or Gift Card

See all 3 formats and editions Hide other formats and editions

Price

New from

Used from

Kindle

"Please retry"

$29.14

—

Paperback

"Please retry"

$34.22

$26.56

$24.60

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to do it. The Second Edition of Joe Celko's Trees and Hierarchies in SQL for Smarties covers two new sets of extensions over three entirely new chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's publication. Benefit from mastering the challenging aspects of these database applications in SQL as taught by Joe Celko, one of the most-read SQL authors in the world.

Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee
Teaches scores of advanced techniques that can be used with any product, in any SQL environment
Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items when the Enter key is pressed. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Joe Celko

3

Kindle Edition
$43.20
Joe Celko

11

Kindle Edition
$17.25
Bill Karwin

52

Kindle Edition
$23.13
Joe Celko

15

Kindle Edition
$36.99
Tim Roughgarden

8

Kindle Edition
$9.99
Joe Celko

13

Kindle Edition
$31.15

Product details

File Size: 1919 KB
Print Length: 296 pages
Publisher: Morgan Kaufmann; 2 edition (January 25, 2012)
Publication Date: January 25, 2012
Sold by: Amazon Digital Services LLC
Language: English
ASIN: B006Y8MKUU
Text-to-Speech: Enabled

X-Ray:

Not Enabled

Word Wise: Not Enabled
Lending: Not Enabled
Enhanced Typesetting: Enabled

Amazon Best Sellers Rank: #385,573 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #369 in Computer Databases
- #75 in SQL Databases
- #217 in SQL

Would you like to tell us about a lower price?

Be the first video

Your name here

Customer reviews

5 star		58%
4 star		30%
3 star 0% (0%)		0%
2 star		13%
1 star 0% (0%)		0%

Review this product

Write a customer review

15 customer reviews

There was a problem filtering reviews right now. Please try again later.

Joseph Dewey

The best was to drastically speed up your software, but it is for smarties

December 6, 2014

Format: PaperbackVine Customer Review of Free Product( What's this? )Verified Purchase

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

2 people found this helpful

Helpful

Comment

Jean S Blaha

Good book. Joe Celko wrote this book for advanced ...

August 6, 2016

Format: PaperbackVerified Purchase

Good book. Joe Celko wrote this book for advanced readers. I've read his SQL for Smarties previously and it was also excellent. Joe has interesting and thoughtful SQL techniques that are seldom mentioned in the literature.

One person found this helpful

Helpful

Comment

TechKnowMage

Complicated, as expected

June 11, 2014

Format: PaperbackVerified 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.

One person found this helpful

Helpful

Comment

Michael Häggblad

Lotts of small errors in code examples

November 25, 2013

Format: Kindle EditionVerified Purchase

Littered with small errors which decrease reading speed and poorly referenced sources of data (introduces several tables with similar data without propper distinction).

One person found this helpful

Helpful

Comment

Bjxrn Hxj Jakobsen

Will get you inspired!

January 10, 2014

Format: Kindle EditionVerified 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).

One person found this helpful

Helpful

Comment

Diego Moreira da Rosa

Pretty good

October 29, 2013

Format: Kindle EditionVerified Purchase

The book is pretty good and very complete regarding the subject of hierarchical data models. I just missed more comparisons between the discussed methods.

Helpful

Comment

This is for Smarties allright!

April 19, 2012

Format: PaperbackVine 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.

11 people found this helpful

Helpful

Comment

Interesting topic for real life SQL problems

June 1, 2012

Format: PaperbackVine 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.

3 people found this helpful

Helpful

Comment

What other items do customers buy after viewing this item?

Kindle Edition

Joe Celko

3

$43.20
Kindle Edition

Joe Celko

11

$17.25
Kindle Edition

Sylvia Moestl Vasilik

105

$9.99
Kindle Edition

Bill Karwin

52

$23.13

Customers who viewed this item also viewed

Page 1 of 1 Start overPage 1 of 1

Joe Celko

3

Kindle Edition
$43.20
Joe Celko

11

Kindle Edition
$17.25
Sylvia Moestl Vasilik

105

Kindle Edition
$9.99
Bill Karwin

52

Kindle Edition
$23.13
Joe Celko

22

Kindle Edition
$39.49
Joe Celko

15

Kindle Edition
$36.99

Feedback

If you need help or have a question for Customer Service, contact us.

Would you like to report poor quality or formatting in this book? Click here

Would you like to report this content as inappropriate? Click here

Do you believe that this item violates a copyright? Click here

Amazon Music Stream millions of songs	Amazon Advertising Find, attract, and engage customers	Amazon Drive Cloud storage from Amazon	6pm Score deals on fashion brands	AbeBooks Books, art & collectibles	ACX Audiobook Publishing Made Easy

Alexa Actionable Analytics for the Web	Sell on Amazon Start a Selling Account	Amazon Business Everything For Your Business	AmazonGlobal Ship Orders Internationally	Home Services Handpicked Pros Happiness Guarantee	Amazon Inspire Digital Educational Resources

Amazon Rapids Fun stories for kids on the go	Amazon Web Services Scalable Cloud Computing Services	Audible Listen to Books & Original Audio Performances	Book Depository Books With Free Delivery Worldwide	Box Office Mojo Find Movie Box Office Data	ComiXology Thousands of Digital Comics

CreateSpace Indie Print Publishing Made Easy	DPReview Digital Photography	East Dane Designer Men's Fashion	Fabric Sewing, Quilting & Knitting	Goodreads Book reviews & recommendations	IMDb Movies, TV & Celebrities

IMDbPro Get Info Entertainment Professionals Need	Kindle Direct Publishing Indie Digital Publishing Made Easy	Prime Video Direct Video Distribution Made Easy	Shopbop Designer Fashion Brands	Woot! Deals and Shenanigans	Zappos Shoes & Clothing

Ring Smart Home Security Systems	eero WiFi Stream 4K Video in Every Room	Neighbors App Real-Time Crime & Safety Alerts	Subscribe with Amazon Discover & try subscription services	PillPack Pharmacy Simplified	Amazon Second Chance Pass it on, trade it in, give it a second life

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

Customers who bought this item also bought

Product details