Introduction
Lesson 1 of 13 in Coddy's SQL for advanced course.
Welcome to SQL for advanced course. Last course we learned how to handle multiple tables and calculate all kinds of statistics to improve the way we present data. In this course, we will dive deeper into how to run even more complicated queries such as sequential-based queries, functions, and more.
- Disclaimer -
To succeed in this course you have to do the challenges by yourself and if you are struggling you can always check the hints and eventually the solution.
Let's get started!
Try it yourself
This lesson doesn't include a code challenge.
All lessons in SQL for advanced
4Summary
Final challenge #13Window Functions part 2
RANK & DENSE_RANK functionsNTILE functionAggregation functionsROWS & RANGE criterion