Skip to main content
DatabricksPySparkSnowflakeApache Airflow
Code Keys/SQL Academy/Module 24
SQL ACADEMY • MODULE 24

Advanced Window Analytics

Use advanced window frames, ranking, comparisons, and analytical calculations used in production data analytics.

Advanced📚 10 Lessons⭐ 0 / 16850 XP⏳ In Progress
0 / 10 Lessons Completed (0%)
CHALLENGE CURRICULUM

Module Lessons

0 / 10 Complete
LESSON 151

🔓 Partitioned Running Total

⏱ 3 Mins • ⭐ 1640 XP • Advanced

Start Mission →
LESSON 152

🔒 Partitioned Average

⏱ 3 Mins • ⭐ 1650 XP • Advanced

LESSON 153

🔒 Salary Rank by Department

⏱ 3 Mins • ⭐ 1660 XP • Advanced

LESSON 154

🔒 Previous Salary

⏱ 3 Mins • ⭐ 1670 XP • Advanced

LESSON 155

🔒 Salary Change

⏱ 3 Mins • ⭐ 1680 XP • Advanced

LESSON 156

🔒 NTILE

⏱ 3 Mins • ⭐ 1690 XP • Advanced

LESSON 157

🔒 Cumulative Department Salary

⏱ 3 Mins • ⭐ 1700 XP • Advanced

LESSON 158

🔒 Moving Average

⏱ 3 Mins • ⭐ 1710 XP • Advanced

LESSON 159

🔒 First Value

⏱ 3 Mins • ⭐ 1720 XP • Advanced

LESSON 160

🔒 Last Value

⏱ 3 Mins • ⭐ 1730 XP • Advanced

← Previous ModuleNext Module →