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 [6 lessons]
An Introduction to Window Functions 2h
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 2h
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 2h
Lesson Objectives- Define window aggregate functions
- Add window aggregate functions to non-aggregate queries
- Add window aggregate functions to aggregate queries
Ranking Window Functions 2h
Lesson Objectives- Explain the purpose and benefits of using ranking window functions in SQL
- Describe the syntax and parameters of ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
- 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_VALUE(), LAST_VALUE(), or NTH_VALUE() within a window using offset window functions
- Apply offset window functions to solve real-world problems
Distribution Window Functions 2h
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
Projects in this course
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.
Learning resources
In this guide, you'll learn how to install PostgreSQL 1...
In this tutorial, you'll learn how to install PostgreSQ...
In this tutorial, you'll learn how to install PostgreSQ...
There are lots of great reasons to learn Microsoft Powe...
Grow your career with
Dataquest.
97%
of learners recommend
Dataquest for career advancement
4.9
Dataquest rating on
G2Crowd and SwitchUp
$30k
Average salary boost
for learners who complete a path
Join 1M+ data learners on
Dataquest.
1
Sign up for a free account
2
Choose a course or path
3
Learn with hands-on exercises
4