.webp&w=3840&q=75)
Industry
sports
Skills
data-wrangling
Tools
sql
Learning Objectives
Apply filtering and sorting techniques to extract and present specific results
Implement window functions to calculate cumulative totals, percentages, and rankings.
Demonstrate the use of Common Table Expressions (CTEs) to structure and simplify queries for better readability and organization.
Overview
Prerequisites
- Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
- Knowledge of aggregations using functions like SUM, COUNT, and AVG.
- Knowledge of CTEs and subqueries for structuring and simplifying queries.
- Knowledge of window functions like RANK(), DENSE_RANK(), ROW_NUMBER(), and SUM() OVER().