Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Master data analysis, BI, ML.
·
Module 1
Intermediate SQL for Analytics
1
Handling Nulls and Type Conversions with COALESCE, NULLIF, and CAST
Use COALESCE, NULLIF, and CAST to handle null values and data type conversions.
2
Subqueries in SELECT, FROM, and WHERE
Write subqueries in SELECT, FROM, and WHERE clauses to answer multi-step analytical questions.
3
Mastering CTEs for Cleaner Queries
Apply common table expressions (CTEs) to improve the readability and structure of complex queries.
4
Ranking Data with Window Functions
Use window functions like ROW_NUMBER, RANK, and DENSE_RANK to partition and rank data.
5
Window Functions: Running Totals & Moving Averages with Frame Clauses
Calculate running totals and moving averages using window functions with frame clauses (ROWS/RANGE).
6
Combining Result Sets with UNION, INTERSECT, and EXCEPT
Combine result sets using UNION, INTERSECT, and EXCEPT operators.
Next module isn't ready yet,
Back to course
Previous module
Next module