Consultas eficientes

Aprendé a filtrar, ordenar y agrupar información para análisis precisos

Análisis de datos

Utilizá funciones y JOIN para obtener información útil para decisiones

Aplicación profesional

Incorporá buenas prácticas utilizadas en reporting, BI y gestión de datos

Sobre el Curso

Este curso está orientado a quienes buscan incorporar fundamentos de SQL para consultar, analizar y administrar información en bases de datos relacionales aplicadas a entornos de negocio.

Contenido del Curso

1 Chapter · 30 Lessons

    1. (Included in full purchase)

      Curso completo de SQL

    2. (Included in full purchase)

      ¿Qué es SQL?

    3. (Included in full purchase)

      Bases de datos relacionales

    4. (Included in full purchase)

      Tablas, columnas y registros

    5. (Included in full purchase)

      Tipos de datos

    6. (Included in full purchase)

      SELECT

    7. (Included in full purchase)

      WHERE

    8. (Included in full purchase)

      ORDER BY y LIMIT

    9. (Included in full purchase)

      Funciones agregadas

    10. (Included in full purchase)

      GROUP BY

    11. (Included in full purchase)

      HAVING

    12. (Included in full purchase)

      JOINs

    13. (Included in full purchase)

      Subqueries

    14. (Included in full purchase)

      INSERT, UPDATE y DELETE

    15. (Included in full purchase)

      NULL y valores vacíos

    16. (Included in full purchase)

      CASE WHEN

    17. (Included in full purchase)

      Funciones de texto y fecha

    18. (Included in full purchase)

      CTE  Common Table Expressions

    19. (Included in full purchase)

      Views

    20. (Included in full purchase)

      Índices y performance

    21. (Included in full purchase)

      Normalización

    22. (Included in full purchase)

      Errores comunes

    23. (Included in full purchase)

      Caso práctico: RRHH

    24. (Included in full purchase)

      Caso práctico: ventas

    25. (Included in full purchase)

      SQL y Business Intelligence

    26. (Included in full purchase)

      SQL y Data Engineering

    27. (Included in full purchase)

      Buenas prácticas

    28. (Included in full purchase)

      Conclusión

    29. (Included in full purchase)

      Gracias

    30. (Included in full purchase)

      SQL básico Quiz