Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.
Interactive Course
In this online course, you will master PostgreSQL recursive queries, also known as WITH clauses, and common table expressions (CTEs).
This online course is intended for intermediate users and will benefit beginner data analysts, IT students, business developers, and more. The prerequisite is understanding the basics of SQL presented in our SQL Basics in PostgreSQL course followed by some practice.
Recursive queries are often called WITH clauses and are essentially just named subqueries. It is a fairly new feature of SQL that allows you to manage a long query and break it into smaller, more readable chunks. Unlike SQL subqueries, recursive queries allow the traversal of hierarchical models with enormous depth. Using recursive queries, you can process hierarchical structures, such as graphs and trees; for example, you can find the shortest path between two cities using a railway network or the length of the "chain of command" from a regular employee to the CEO.
In this online course, you will learn simple, common table expressions (CTEs), nested CTEs, and recursive CTEs. You will also discover how to manage a PostgreSQL query with a CTE, when to nest CTEs, and how to use recursive CTEs to move through hierarchical data models.
Course progress
Exercises completed
Test your knowledge of PostgreSQL
Exercises completed
Introduction
Quiz
Congratulations
Your first encounter with Common Table Expressions
Exercises completed
Introduction
Basic CTE
Summary
You'll get to know how to use nested CTEs
Exercises completed
Introduction
Nested CTEs
Summary
You'll find out what recursion is and how to use it in SQL queries
Exercises completed
The very basics
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive CTEs
You'll learn how to use INSERT, DELETE, and UPDATE statements with CTEs.
Exercises completed
Using CTEs with data-modifying statements
Test your knowledge in this final quiz.
Exercises completed