SQL intermedio con IA

Resumen

Build SQL skills by writing AI prompts that generate queries for sorting, grouping, filtering, and categorizing data. Learn SQL with an AI Assistant This comprehensive course helps you build your SQL skills using AI as your coding assistant.

Built for learners looking to develop their SQL and AI skills, this course will teach you to write clear prompts that generate useful queries that help you explore and analyze your data. You'll gain practical experience organizing information, implementing filters, and applying conditional logic to answer business questions.

Sort and Summarize Your Data You'll start by developing prompting strategies that guide AI assistants in implementing ORDER BY and GROUP BY operations to structure and categorize your data. You'll practice adding an analytical layer to your grouped results using aggregate functions like AVG, SUM, MIN, and MAX.

Filter and Refine Your Results Next, you'll learn filtering techniques with WHERE clauses through AI-generated queries and explore comparison operators, logical conditions, and pattern matching with wildcards. You'll also handle missing data scenarios and craft prompts that generate targeted queries to find exactly what you need.

By the end, you'll confidently combine AI assistance with your analytical thinking to tackle complex data challenges.

Programa

• Agrupar y Resumir Datos con IA
Organiza y analiza tus datos usando consultas de ORDER BY y GROUP BY impulsadas por IA. Aprende a ordenar resultados, segmentar datos y extraer métricas clave resumidas con funciones agregadas como AVG, SUM, MIN y MAX. Desarrollarás habilidades para transformar datos brutos en insights significativos.
• Filtrar Datos con IA
Filtra y refina tus datos con clausulas WHERE generadas por IA. Comenzando con operadores de comparación y condiciones lógicas, explorarás el emparejamiento de patrones con comodines y manejarás escenarios de datos faltantes. Desarrollarás habilidades para elaborar solicitudes que generen consultas dirigidas para encontrar los datos que necesitas.
• Lógica Condicional con IA
Mejora tus solicitudes y consultas con lógica condicional impulsada por IA y técnicas de filtrado refinadas. Aprende a filtrar datos agrupados aplicando condiciones después de la agregación con cláusulas HAVING, y crea nuevas categorías aplicando condiciones dentro de grupos usando expresiones CASE.

---

Impartido por

Jasmin Ludolf

---

Materias

Programming