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.
86%
off
Reg. price
$1512
Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $199
37 hours left at this price!
72%
off
Reg. price
$324
Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS
Bundle price $89
37 hours left at this price!
Test your knowledge of PostgreSQL
0% completed 0 of 14 exercises done
Your first encounter with Common Table Expressions
0% completed 0 of 17 exercises done
You'll get to know how to use nested CTEs
0% completed 0 of 15 exercises done
You'll find out what recursion is and how to use it in SQL queries
0% completed 0 of 36 exercises done
You'll learn how to use INSERT, DELETE, and UPDATE statements with CTEs.
0% completed 0 of 18 exercises done
Test your knowledge in this final quiz.
0% completed 0 of 14 exercises done
