Joe Celko's Trees and Hierarchies in SQL for Smarties
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £9.05
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) for an Amazon.co.uk gift card of up to £9.05, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
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. This title offers expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee. It teaches scores of advanced techniques that can be used with any product, in any SQL environment. It also offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges.
About the Author
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He has written over 900 columns in the computer trade and academic press, mostly dealing with data and databases. Joe has authored eight books on SQL for Morgan Kaufmann.
Inside This Book
(Learn More)
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
7 reviews
1 of 1 people found the following review helpful
If you need this, I don't know of any alternative
17 Mar 2012
Format:Paperback|Amazon Vine™ Review
(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.
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.
1 of 1 people found the following review helpful
Good book for people wanting to learn more about SQL trees and hierarchies
15 Mar 2012
Format:Paperback|Amazon Vine™ Review
(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.
Easy to read, accurate, lots of interesting solutions
30 April 2012
Format:Paperback|Amazon Vine™ Review
(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.
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
