Explore
Journey
Daily Challenge
Categories
Course type
Learn, challenge or build your portfolio in a practice-driven way.
Level of knowledge
Choose courses tailored to your level of knowledge perfectly.
Or try to search for any course. Still can't find? let us know what are you missing!
Creator
Anonymous
SQL for advanced
In this course we will dive deeper into how to run complicated queries such as sequential based queries, functions and more.
13 Lessons
12 Challenges
With Certificate
Prerequisites
SQL for intermediate
Save for laterIntrodcution
Introduction
Simplify queries, WITH keyword
Window Functions part 1
ROW_NUMBER function
ORDER BY criterion
PARTITION BY criterion
LEAD & LAG functions
Recap challenge #1
Recap challenge #2
Window Functions part 2
RANK & DENSE_RANK functions
NTILE function
Aggregation functions
ROWS & RANGE criterion
Summary
Final challenge #1
Made with ❤️ © 2024 Coddy