Skip to main content
DatabricksPySparkSnowflakeApache Airflow
← Code Keys Overview/SQL Mastery Track
🗄️ SQL ENGINEERING ACADEMY

Production SQL Mastery

Master query structure, window functions, and CTEs through hands-on touch typing.

▶
START FIRST LESSONLesson 01: SQL Basics
→
PROGRESS0 / 192 Lessons (0%)
EARNED XP0 / 210500 XP
CURRICULUM DEPTH28 Modules • 192 Lessons
TRACK COMPLETION0%

SQL Curriculum Roadmap

Select a module to view lessons. Practice touch typing on live SQL queries.

▼MODULE 01

SQL Fundamentals

Beginner
0 / 4
+470 XP🟢 In ProgressOverview ↗
LESSON 01+100 XP

SQL Basics

▶ Start Mission →
LESSON 02+100 XP

SELECT Columns

LESSON 03+120 XP

WHERE Clause

LESSON 04+150 XP

ORDER BY

▶MODULE 02

Filtering Data

Beginner
0 / 4
+550 XP🔒 LockedOverview ↗
▶MODULE 03

Aggregations & Grouping

Intermediate
0 / 4
+760 XP🔒 LockedOverview ↗
▶MODULE 04

Subqueries

Intermediate
0 / 4
+1000 XP🔒 LockedOverview ↗
▶MODULE 05

SQL Joins

Intermediate
0 / 4
+1300 XP🔒 LockedOverview ↗
▶MODULE 06

Advanced Joins & Sets

Advanced
0 / 4
+1600 XP🔒 LockedOverview ↗
▶MODULE 07

Window Functions

Advanced
0 / 4
+1850 XP🔒 LockedOverview ↗
▶MODULE 08

Conditional Logic & CTEs

Advanced
0 / 4
+1920 XP🔒 LockedOverview ↗
▶MODULE 09

Date & Time Analytics

Advanced
0 / 4
+2150 XP🔒 LockedOverview ↗
▶MODULE 10

SQL Fundamentals Reinforcement

Beginner
0 / 8
+4280 XP🔒 LockedOverview ↗
▶MODULE 11

SQL Filtering Mastery

Beginner
0 / 8
+4920 XP🔒 LockedOverview ↗
▶MODULE 12

SQL Sorting, Distinct & Limits

Beginner
0 / 8
+5560 XP🔒 LockedOverview ↗
▶MODULE 13

SQL Aggregation Mastery

Intermediate
0 / 8
+6200 XP🔒 LockedOverview ↗
▶MODULE 14

GROUP BY & HAVING

Intermediate
0 / 8
+6840 XP🔒 LockedOverview ↗
▶MODULE 15

SQL JOIN Fundamentals

Intermediate
0 / 8
+7480 XP🔒 LockedOverview ↗
▶MODULE 16

Advanced SQL JOINs

Advanced
0 / 8
+8120 XP🔒 LockedOverview ↗
▶MODULE 17

SQL Subqueries

Advanced
0 / 8
+8760 XP🔒 LockedOverview ↗
▶MODULE 18

Common Table Expressions

Advanced
0 / 8
+9400 XP🔒 LockedOverview ↗
▶MODULE 19

CASE Expressions & Conditional SQL

Advanced
0 / 8
+10040 XP🔒 LockedOverview ↗
▶MODULE 20

NULL Handling & Data Quality

Advanced
0 / 8
+10680 XP🔒 LockedOverview ↗
▶MODULE 21

SQL Date & Time Analytics

Advanced
0 / 8
+11320 XP🔒 LockedOverview ↗
▶MODULE 22

SQL String Functions

Advanced
0 / 8
+11960 XP🔒 LockedOverview ↗
▶MODULE 23

SQL Window Functions

Advanced
0 / 10
+15850 XP🔒 LockedOverview ↗
▶MODULE 24

Advanced Window Analytics

Advanced
0 / 10
+16850 XP🔒 LockedOverview ↗
▶MODULE 25

SQL Set Operations

Advanced
0 / 8
+14200 XP🔒 LockedOverview ↗
▶MODULE 26

Advanced SQL Patterns

Advanced
0 / 8
+14840 XP🔒 LockedOverview ↗
▶MODULE 27

SQL for Data Engineering

Advanced
0 / 8
+15480 XP🔒 LockedOverview ↗
▶MODULE 28

Production SQL Challenges

Advanced
0 / 8
+16120 XP🔒 LockedOverview ↗