Summary of the course

1. Summary of the course

Congratulations! You have finished the course. In this video, we will quickly recap what we have learned.

2. Chapter 1: Recursion and CTEs

In this first chapter, two main concepts were presented. The first one is recursion, which is the use of a procedure that calls itself until a specified condition is met. The second one is the definition of a Common Table Expression, which is defined by the WITH AS syntax.

3. Chapter 2: Hierarchical and recursive queries

In the second chapter, the recursive CTE with its union of the anchor and the recursive query was presented, and you practiced this knowledge on some real-world examples such as mathematical problems, an organization, and a family tree.

4. Chapter 3: Creating data models on your own

In the third chapter, you learned how to manipulate data models by using operations such as creating a table or inserting data. Furthermore, you explored the differences between a relational and hierarchical data model and how you can create these data models yourself.

5. Chapter 4: Hierarchical queries of real world examples

To strengthen the principles you learned in the previous chapters, you performed three common tasks. You created a hierarchical data model, queried a hierarchy recursively, and got the level of a hierarchy. You practiced your knowledge on three real-world examples. You first planned flight routes, then you assembled a car, and finally, you modeled a power grid. And all of this by using recursive queries.

6. Congratulations!

Now that we are at the end of this course, I would like to congratulate you again. I hope you can use this knowledge in many different scenarios.

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.