Combinar tablas con JOINs en SQL

Later on

Combinar tablas con INNER, LEFT y FULL JOIN: el mecanismo con el que los datos relacionales cobran sentido.

1Courses that teach it

3Connected 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 combinar varias tablas con el tipo de JOIN correcto para cada pregunta de negocio
Al terminar sabrás detectar filas sin correspondencia (clientes sin pedidos, productos sin ventas) usando LEFT JOIN e IS NULL
Al terminar sabrás calcular métricas agregadas y filtrar grupos con GROUP BY y HAVING
Al terminar sabrás leer un diagrama entidad-relación e identificar claves primarias, foráneas y cardinalidades
Al terminar sabrás unir y agregar en una sola consulta para construir informes reales sin errores de conteo

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

Combinar tablas con JOINs en SQLsql · Beginner

After this

This is one of the most advanced skills.

Glossary terms and cheat sheets that already reference this skill.

Related skills from the same domain.