Learn. Build. Iterate.

New courses and product improvements

What we publish and what changes in the product. Nothing else: no daily offers, no third-party courses.

Website

One click from any email unsubscribes you — no questions asked.

Made in Colombia

We use analytics cookies to understand how the platform is used and to improve it. You can accept or reject them. See our privacy policy.

Learn CTEs recursivas y consultas jerárquicas — courses, prerequisites & practice

sql

Intermediate

CTEs recursivas y consultas jerárquicas

Later on

CTEs recursivas: recorrer jerarquías (organigramas, categorías, grafos) con SQL puro.

1Courses that teach it

1Connected skills

What you'll be able to do

Once you finish the courses that teach this skill, you'll be able to do this.

Al terminar sabrás estructurar consultas complejas con CTEs encadenadas en lugar de subconsultas anidadas ilegibles.
Al terminar sabrás recorrer datos jerárquicos y generar series con CTEs recursivas.
Al terminar sabrás aplicar funciones de ventana (ROW_NUMBER, RANK, LAG/LEAD, acumulados y medias móviles) para análisis fila a fila.
Al terminar sabrás decidir entre una subconsulta correlacionada, un JOIN y una función de ventana según el caso.
Al terminar sabrás leer un plan de ejecución y reescribir consultas lentas siguiendo patrones de optimización.

Courses and projects that build this competency.

A suggested order, not a lock: you can start wherever you like, but this is what makes the path shortest.

Before this

You are here

CTEs recursivas y consultas jerárquicassql · Intermediate

After this

This is one of the most advanced skills.

Your next step

We recommend mastering Expresiones de tabla comunes (CTEs) first — it makes this one easier, not a requirement.