The idea of storing a hierarchical data in a relational database is very simple, but effective work with such a data requires some knowledge of server-side programming using procedural
SQL (PSQL). So the hierarchical data structures are a good chance to get acquainted with PSQL. For demonstration ...
More...