Joe Celko's Trees and Hierarchies in SQL for Smarties

ISBN-10: 0123877334

ISBN-13: 9780123877338

Edition: 2nd 2012

Authors: Joe Celko

List price: $44.95 Buy it from $33.32
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


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
New Starting from $33.32
eBooks Starting from $44.95
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Customers also bought

Book details

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

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)
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.