SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, PERCENT_RANK
1.9 هزار بار بازدید -
2 ماه پیش
-
In Part 3, we'll dive
In Part 3, we'll dive into 6 SQL rank window functions, focusing on ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, and PERCENT_RANK. We'll explore the concept behind these functions, their syntax, and important use cases from real-life projects.
We will cover very important analytical use cases: Top-N Analysis, Bottom-N Analysis, Identify Duplicates, Assign Unique IDs, Data Segmentation, and Data Distribution Analysis.
SQL ranking window functions provide powerful tools to analyze and understand data distributions, rankings, and proportions within SQL queries.
🔔 If you enjoyed this video and found it helpful, please support the channel by Subscribing, liking and commenting. http://bit.ly/3GiCVUE
--------------------------------------------------
⏬ FREE DOWNLOAD LINKS ⏬
--------------------------------------------------
Access all course materials: https://bit.ly/advancedsqlcourse
You can find list to all courses & materials in my substack page https://datawithbaraa.substack.com/su...
----------------------------------------------------
🎓 Free Courses On Youtube 🎓
-----------------------------------------------------
✅ Tableau Course
Tableau Ultimate Full Course (21 Hour...
✅ SQL Course - Basic concepts
SQL Tutorial for Beginners [Ultimate ...
✅ AI Chat GPT Course
ChatGPT Tutorial for Beginners [Ultim...
---------------------------------
☕ FOLLOW ME ☕
---------------------------------
Baraa Khatib Salkini
Website: https://www.datawithbaraa.com
Channel: http://bit.ly/3GiCVUE
LinkedIn: LinkedIn: baraa-khatib-salkini-845b1b55
Email: [email protected]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
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
Thank you for watching! Remember to like, share, and subscribe for more high quality content on data. Stay curious, stay connected!
#SQL #DataAnalytics #SQLCourse #AdvancedSQL #Data #Analytics #Database #DataScience #Programming #Tech #Technology #Coding #DataAnalysis #SQLServer #BigData #DataManagement #Query #MasteringSQL #SQLTutorial #DataEngineering #bigdata #businessintelligence #datawithbaraa
We will cover very important analytical use cases: Top-N Analysis, Bottom-N Analysis, Identify Duplicates, Assign Unique IDs, Data Segmentation, and Data Distribution Analysis.
SQL ranking window functions provide powerful tools to analyze and understand data distributions, rankings, and proportions within SQL queries.
🔔 If you enjoyed this video and found it helpful, please support the channel by Subscribing, liking and commenting. http://bit.ly/3GiCVUE
--------------------------------------------------
⏬ FREE DOWNLOAD LINKS ⏬
--------------------------------------------------
Access all course materials: https://bit.ly/advancedsqlcourse
You can find list to all courses & materials in my substack page https://datawithbaraa.substack.com/su...
----------------------------------------------------
🎓 Free Courses On Youtube 🎓
-----------------------------------------------------
✅ Tableau Course
Tableau Ultimate Full Course (21 Hour...
✅ SQL Course - Basic concepts
SQL Tutorial for Beginners [Ultimate ...
✅ AI Chat GPT Course
ChatGPT Tutorial for Beginners [Ultim...
---------------------------------
☕ FOLLOW ME ☕
---------------------------------
Baraa Khatib Salkini
Website: https://www.datawithbaraa.com
Channel: http://bit.ly/3GiCVUE
LinkedIn: LinkedIn: baraa-khatib-salkini-845b1b55
Email: [email protected]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
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
Thank you for watching! Remember to like, share, and subscribe for more high quality content on data. Stay curious, stay connected!
#SQL #DataAnalytics #SQLCourse #AdvancedSQL #Data #Analytics #Database #DataScience #Programming #Tech #Technology #Coding #DataAnalysis #SQLServer #BigData #DataManagement #Query #MasteringSQL #SQLTutorial #DataEngineering #bigdata #businessintelligence #datawithbaraa
2 ماه پیش
در تاریخ 1403/02/25 منتشر شده
است.
1,915
بـار بازدید شده