Conceptos SQL
Interview a few of your colleagues and write down their answers. You can create a different mind map for each of them.
At the end of your small group discussion, share with the whole class what you learned about your colleagues.
5. CROSS JOIN
Producto cartesiano entre tablas
4. FULL JOIN
Todos los registros de ambas tablas
3. RIGHT JOIN
Todos los registros de tabla derecha
2. LEFT JOIN
Todos los registros de tabla izquierda
1. INNER JOIN
Registros con coincidencias en ambas tablas
Consultas múltiples tablas
5. MINUS
Similar a EXCEPT en algunos sistemas
4. EXCEPT
Type in the name of your colleague's favorite town.
Registros presentes en primera consulta pero no en segunda
3. INTERSECT
Registros comunes entre consultas
Type in your colleague's favorite season.
2. UNION ALL
Combina resultados manteniendo duplicados
1. UNION
Type in your colleague's favorite subject.
Combina resultados eliminando duplicados
Operaciones sobre conjuntos
5. Lógicos
AND, OR, NOT, IN, BETWEEN
4. Numéricos
Type in your colleague's favorite actor.
ROUND, CEIL, FLOOR
3. Fecha
Type in your colleague's favorite TV show.
DATE_FORMAT, DATEADD, DATEDIFF
2. Cadenas
CONCAT, SUBSTRING, UPPER, LOWER
1. Agregación
COUNT, SUM, AVG, MAX, MIN
Funciones y operadores
Type in your colleague's favorite game.
Subconsultas correlacionadas
5. ORDER BY
Ordenamiento basado en subconsultas
4. HAVING
Filtros sobre grupos usando consulta externa
3. FROM
Derivación de tablas relacionadas
2. SELECT
Cálculos por fila usando consulta externa
1. WHERE
Filtros usando valores de consulta externa
5. EXISTS
Type in the name of your colleague's favorite country.
Verifica existencia de registros
4. Tabla
Retorna conjunto de filas y columnas
Type in your colleague's favorite place to eat out.
3. Fila
Type in your colleague's favorite celebration.
Retorna una fila de valores
2. Columna
Type in your colleague's favorite superhero.
Retorna una columna de valores
1. Escalar
Type in your colleague's favorite singer.
Retorna un único valor
Subconsultas
Type in your colleague's favorite song.
10. TRUNCATE
Type in the name of your colleague's favorite movie.
Elimina todos los registros de una tabla manteniendo su estructura
9. REVOKE
Remueve permisos previamente otorgados
Type in what is the sport he/she likes to watch the most.
8. GRANT
Asigna permisos a usuarios sobre objetos
Type in your colleague's favorite received gift.
7. DROP TABLE
Elimina una tabla y todos sus datos
Type in or tell your colleagues what is the favorite quality that they see in others.
6. ALTER TABLE
Type in your colleague's favorite scent.
Modifica la estructura de una tabla existente
5. CREATE TABLE
Type in your colleague's favorite color.
Define una nueva tabla con sus columnas y restricciones
4. DELETE
Type in your colleague's favorite drink.
Elimina registros que cumplan condiciones específicas
3. UPDATE
Type in your colleague's favorite activity.
Modifica registros existentes según criterios definidos
2. INSERT
Agrega nuevos registros en una tabla
Type in your colleague's favorite fruit.
1. SELECT
Recupera datos de una o más tablas especificando columnas y condiciones
Type in your colleague's favorite pet.
Sentencias SQL principales
Type in the name of your colleague's favorite person.
