Back to catalog
DataIntermediate
SQL for Data Analysis
Take your SQL to the next level. This course is designed for analysts who already know the basics and now need CTEs, window functions, correlated subqueries, and performance optimization through realistic business datasets.
9 lessonsCertificate includedUSD 5 (~ARS 5.000)
Course syllabus
1Advanced CTEs and subqueries
4 lessons
Advanced CTEs and subqueries
- Common Table Expressions
- Correlated subqueries
- Recursive CTEs
- Advanced patterns
2Window functions
4 lessons
Window functions
- ROW_NUMBER and RANK
- LAG and LEAD
- Window aggregations
- Advanced PARTITION BY
3Optimization and performance
4 lessons
Optimization and performance
- EXPLAIN and query analysis
- Indexes
- Best practices
- Common anti-patterns
4Business analysis with SQL
4 lessons
Business analysis with SQL
- Cohort analysis
- Retention metrics
- Funnel analysis
- Final project
What you will learn
CTEsWindow functionsCorrelated subqueriesQuery optimizationBusiness analysis
Certificate
SQL for Data Analysis Certificate - CumbreAcademy
Ready to start?
Investment: USD 5 (~ARS 5.000)
Buy accessWant access to every course?
Total Access gives you this course and all the others for $20/month.
This course: USD 5 (~ARS 5.000) - Total Access: $20 USD/month (all courses)
See Total AccessWhat can you do after this course?
These are the recommended next steps for your learning path.