Full Advanced Course: https://www.youtube.com/watch?v=ELdz0dXzWGM&list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
Free Materials (Downloads): https://datawithbaraa.substack.com
Support & Subscribe to Channel: http://bit.ly/3GiCVUE

Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join

Free Courses
Tableau: https://youtu.be/UcGF09Awm4Y
Tableau Project: https://www.youtube.com/watch?v=UcGF09Awm4Y
SQL Basics: https://youtu.be/NTgejLheGeU?si=2-m6dgYPRvoFUSgS
SQL Advanced: https://www.youtube.com/watch?v=ELdz0dXzWGM&list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
ChatGPT: https://youtu.be/LJLNfei4i-c?si=EhUNYN38dkswAvZH

Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare

My favorite books: https://kit.co/DataWithBaraa/my-favorite-books
My gear: https://kit.co/DataWithBaraa/my-desktop-gear

⏱ Timestamp
00:00 Intro
00:00:28 What are Window Ranking Functions?
00:05:48 ROW_NUMBER
00:10:13 RANK
00:14:18 DENSE_RANK
00:18:42 ROW_NUMBER vs RANK vs DENSE_RANK
00:19:45 ROW_NUMBER: TOP-N Analysis
00:23:24 ROW_NUMBER: Bottom-N Analysis
00:27:00 ROW_NUMBER: Assign Unique IDs
00:29:47 ROW_NUMBER: Identify Duplicates
00:35:21 NTILE
00:41:41 NTILE: Data Segmentation
00:45:35 NTILE: Equalizing Loads
00:49:02 Intro Percentage Based Ranking
00:50:10 CUME_DIST
00:53:52 PERCENT_RANK
01:01:40 Summary

#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**