In this course we will dive deeper into how to run complicated queries such as sequential based queries, functions and more.
Prerequisites:
- SQL for intermediate
Overview
Syllabus
Introdcution
- 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
