Course overview
Embark on an exciting journey into the world of SQL Window Functions and amplify your data analysis skills. In this course, you’ll master aggregate, ranking, distribution, and offset window functions to streamline intricate queries and extract valuable information. Best of all, you’ll learn by doing – practice and receive feedback directly in the browser. You’ll apply your expertise to a captivating real-world project, fortify your portfolio, and stand out in the competitive data landscape.
Key skills
- Set up a frame for window functions
- Compute running aggregations with aggregate window functions
- Explore rank window functions
- Apply distribution window functions
- Use offset window functions
Course outline
Window Functions in SQL [7 lessons]
An Introduction to Window Functions 1h
Lesson Objectives- Describe what window functions are
- Understand different types of window functions
- Define a window with the OVER() clause
- Divide a window into partitions using PARTITION BY clause
Window Function Framing 1h
Lesson Objectives- Explain window framing
- Identify framing key terms
- Create frames using the ROWS BETWEEN and RANGE BETWEEN clauses
- Indicate frame bounds using the N PRECEDING and N FOLLOWING terms
- Understand the difference between the ROWS BETWEEN and RANGE BETWEEN clauses
Window Aggregate Functions 1h
Lesson Objectives- Define window aggregate functions
- Add window aggregate functions to non-aggregate queries
- Add window aggregate functions to aggregate queries
Ranking Window Functions 1h
Lesson Objectives- Explain the purpose and benefits of using ranking window functions in SQL
- Describe the syntax and parameters of each ranking function
- Understand the differences between ranking window functions to choose the appropriate ranking function
- Use ranking window functions to solve complex problems
Offset Window Functions 2h
Lesson Objectives- Perform multi-row operations using the LAG() and LEAD() functions
- Identify the first, last, or nth value within a window using offset window functions
- Apply offset window functions to solve real-world problems
Distribution Window Functions 1h
Lesson Objectives- Distinguish between CUME_DIST(), PERCENT_RANK(), PERCENTILE_DISC(), and PERCENTILE CONT()
- Apply rank distribution window functions for statistical analysis
- Utilize inverse distribution functions to determine the value at a particular percentile
- Implement the WINDOW clause to create concise and manageable queries
Guided Project: SQL Window Functions for Northwind Traders 1h
Lesson Objectives- Understand the logic behind window functions and CTEs, and their applications in real-world scenarios
- Construct SQL queries that use window functions and CTEs to solve complex data analysis tasks
- Analyze and interpret the results of queries to drive data-informed decisions
The Dataquest guarantee
Dataquest has helped thousands of people start new careers in data. If you put in the work and follow our path, you’ll master data skills and grow your career.
We believe so strongly in our paths that we offer a full satisfaction guarantee. If you complete a career path on Dataquest and aren’t satisfied with your outcome, we’ll give you a refund.
Master skills faster with Dataquest
Go from zero to job-ready
Learn exactly what you need to achieve your goal. Don’t waste time on unrelated lessons.
Build your project portfolio
Build confidence with our in-depth projects, and show off your data skills.
Challenge yourself with exercises
Work with real data from day one with interactive lessons and hands-on exercises.
Showcase your path certification
Impress employers by completing a capstone project and certifying it with an expert review.
Grow your career with
Dataquest.
98%
of learners recommend
Dataquest for career advancement
4.85
Dataquest rating
SwitchUp Best Bootcamps
$30k
Average salary boost
for learners who complete a path
Join 1M+ data learners on
Dataquest.
1
Create a free account
2
Choose a learning path
3
Complete exercises and projects
4