It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close

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.

What's in It for Me?

  • 114 interactive exercises. Learn at your own pace, from any location and at any time. Work through hands-on exercises to help you retain what you have learned so far.
  • Lifetime access to the course. When you purchase the online course, you'll get instant personal access to all of its content forever.
  • Certificate of completion. After you successfully finish all of the exercises in the online course, you'll receive a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you're not satisfied with the quality of the online course, you can get a refund within 30 days of your purchase.
  • Exercise hints. You can take advantage of ready-made hints for every exercise, or ask questions and share insights with other members of the Vertabelo Academy community through the Discuss tab. You can also drop us a line at academy@vertabelo.com, and we'll be more than happy to answer!

What do You Need to Take This Course?

Learn How to:

  • Understand and use basic recursive queries in PostgreSQL.
  • Split long SQL queries with simple and nested common table expressions (CTEs).
  • Deploy recursive CTEs.
  • Write recursive queries in PostgreSQL that traverse a hierarchical data model.

Who Should Take This Course?

  • Analysts who know SQL and need or want to improve their skills, such as by learning how to use a PostgreSQL recursive query
  • Business developers who wish to work with SQL
  • Beginner data scientists
  • Students taking classes in relational databases
  • Anyone who knows SQL and wants to refine it or keep track of current trends
  • Anyone interested in a database-related career
    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    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, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, 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

    Bundle price $199

    36 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 114 exercises done

    1. Intro Quiz

    Test your knowledge of PostgreSQL

    More details Less
    Start now

    0% completed 0 of 14 exercises done

    2. CTE syntax

    Your first encounter with Common Table Expressions

    More details Less
    Start now

    0% completed 0 of 17 exercises done

    3. Nested CTEs

    You'll get to know how to use nested CTEs

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    4. Recursive CTEs

    You'll find out what recursion is and how to use it in SQL queries

    More details Less
    Start now

    0% completed 0 of 36 exercises done

    5. Using CTEs with INSERT, DELETE, and UPDATE

    You'll learn how to use INSERT, DELETE, and UPDATE statements with CTEs.

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    6. Final Quiz

    Test your knowledge in this final quiz.

    More details Less
    Start now

    0% completed 0 of 14 exercises done

    Reviews

    Average rating

    5/5100.0 (1)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0