Coddy logo

Explore

Categories

Programming language

Explore courses by programming language.

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!

Journey

Daily Challenge

search
Store
menu icon
Loading...Creator image

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

certification icon

With Certificate

Prerequisites

SQL for intermediate

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