Courses

Programming language

Explore courses by programming language.

Python

C++

JavaScript

Java

C#

HTML

C

SQL

GO

Course type

Learn, challenge or build your portfolio in a practice-driven way.

Project

Challenges

Educational

Level of knowledge

Choose courses tailored to your level of knowledge perfectly.

Beginner

Intermediate

Advanced

Or try to search for any course. Still can't find? let us know what are you missing!

Journey

Login

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

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