Skip to content

Joe Celko's Trees and Hierarchies in SQL for Smarties

Spend $50 to get a free DVD!

ISBN-10: 0123877334

ISBN-13: 9780123877338

Edition: 2nd 2012

Authors: Joe Celko

List price: $44.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


SQL is the de facto standard for database retrieval and anybody needing to access, update, or utilize data in a modern database management system will need SQL to do it. Most every application being written today will need to incorporate SQL in order to access data, therefore, SQL will continue to grow and thrive. 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. There are tens of thousands of database professionals who could benefit from this book and their number is growing rapidly worldwide. There is no doubt that SQL is the most popular programming language designed for querying and modifying data, and managing relational database management systems. And relational database management systems are being utilized across the online landscape worldwide. Although the manner in which those who use SQL is fairly consistent, the ends to which it is employed are not. The market opportunity for this book lies in the explosive growth expected in the use of SQL and the variety of uses being made by those using SQL. As evidence of the high level of interest in and popularity of programming techniques for representing trees and hierarchies in SQL, the author continues to devote considerable time and energy to explaining these techniques in newsgroups and personal emails. And people who have been reading the book continue to send him their programming tricks.Joe Celko is one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his helpful presence on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Reader's Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko's SQL for Smarties: Advanced SQL Programming, Joe Celko's SQL Puzzles and Answers, Joe Celko's Trees and Hierarchies in SQL for Smarties, Joe Celko's Analytics and OLAP in SQL, Joe Celko's SQL Style, and Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL-all published by Morgan Kaufmann. As sales performance of past editions demonstrates, in addition to NA retail sales, this title has strong appeal in the UK.*Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee*Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92, or SQL 2008 environment*Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges
Customers also bought

Book details

List price: $44.95
Edition: 2nd
Copyright year: 2012
Publisher: Elsevier Science & Technology Books
Publication date: 2/22/2012
Binding: Paperback
Pages: 296
Size: 7.50" wide x 9.25" long x 0.50" tall
Weight: 1.276

Rob Shimonski ( is an experienced entrepreneur and an active participant in the business community. Rob is a best-selling author and editor with over 15 years experience developing, producing and distributing print media in the form of books, magazines and periodicals. To date, Rob has successfully created over 100 books that are currently in circulation. Rob has worked for countless companies to include CompTIA, Entrepreneur Magazine, Microsoft, McGraw Hill Education, Cisco, the National Security Agency and Digidesign. Rob has an extremely diverse background in the print media industry filling roles such as author, co-author, technical editor, copy editor and developmental editor. Since print media shifted to the digital domain, Rob has focused the past decade on developing all of the needed skills to produce professional audio and video media. An expert in Digital Audio Workstation (DAW) design and video production, Rob has created over 500 different media packages to include commercials for TV, online advertising clips, audio podcasts and much more. Rob started to train others while in the US Marine Corps. Since, Rob has held a NY State teaching certificate as well as multiple trainer roles in colleges and trade schools across the world.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.

Graphs, Trees and Hierarchies
Adjacency List Model
Path Enumeration Models
Nested Set Model of Hierarchies
Frequent Insertion Trees
The Linear Version of the Nested Sets model
Binary Trees
Other Models for Trees
Proprietary Extensions for Trees
Hierarchies in Data Modelling
Hierarchical Encoding Schemes
General Graphs (NEW)
Petri Nets (NEW)
State Transition Graphs (NEW)
Hierarchical Database Systems (IMS)