SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, PERCENT_RANK
Ғылым және технология
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. bit.ly/3GiCVUE
--------------------------------------------------
⏬ FREE DOWNLOAD LINKS ⏬
--------------------------------------------------
Access all course materials: bit.ly/advancedsqlcourse
You can find list to all courses & materials in my substack page datawithbaraa.substack.com/su...
----------------------------------------------------
🎓 Free Courses On KZread 🎓
-----------------------------------------------------
✅ Tableau Course
• Tableau Ultimate Full ...
✅ SQL Course - Basic concepts
• SQL Tutorial for Begin...
✅ AI Chat GPT Course
• ChatGPT Tutorial for B...
---------------------------------
☕ FOLLOW ME ☕
---------------------------------
Baraa Khatib Salkini
Website: www.datawithbaraa.com
Channel: bit.ly/3GiCVUE
LinkedIn: / baraa-khatib-salkini-8...
Email: baraa@datawithbaraa.com
---------------------------------
⏱️ 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
Пікірлер: 36
If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE ⏱ 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 Enjoy ☕
Hi Baraa, Hope you are doing well! Baraa you might don't know how much you are helping people like me.Thanks a million
I didn’t seen any videos on sql with immense detailed explanations.
Hi Baraa, you don't realize how amazing your work is! Please, keep it up with the tutorials!! Thanks :)
@DataWithBaraa
Ай бұрын
And you don't realize how awesome you are, when you take time a writing me this nice comment 🙂
I wonder why something like this doesn't have at least hundreds of thousands of views. Thanks for you efforts
@DataWithBaraa
12 күн бұрын
With your people like you supporting, maybe my content will reach the others ❤️
Thanks very much Baraa
Thank you Baraa! very Informative and I was able to crack my SQL interview because of your SQL videos..
@DataWithBaraa
24 күн бұрын
Excellent! Great job 👏
I'm starting to get the hang of SQL from you're tutorial lecture Simply Brilliant ❤❤❤
@DataWithBaraa
2 ай бұрын
Great to hear!
your teaching style is mind blowing
@DataWithBaraa
Ай бұрын
Thanks dear ✌️
Thanks for introducing advance concept Cume_dist(). It is gonna help me in my office work.
@DataWithBaraa
Ай бұрын
Nice, it’s useful function!
I really feel blessed that you made this all video. It's really interesting and easy to understand. when the 1st time i watched your video, i am immediately subscribe!! Great Job Baraa!! Thank you
@DataWithBaraa
Ай бұрын
I am aswell blessed to be able to reach kind people like you, thanks for the support and glad you liked it
Keep doing it bro your explanation makes more sense I bet you.
@DataWithBaraa
Ай бұрын
Thanks
Thank you so much Baraa! Your videos are so helpful. I appreciate the effort you put into them. Can you please do a video on handling different Date types in SQL?
@DataWithBaraa
28 күн бұрын
Thank for the kind words, yes I’ll cover it in my course!
As always I have no word to thank you. God bless u wherever u r.
Awesome,, pls keep making more extraordinary videos
Outstanding! 👏🏻👏🏻👏🏻 Thank you so much!
Thanks Baraa as always!
I am excited even before going through the video ….i am sure I m going to enjoy this … Thanqqqqqq
Was waiting for this eagerly!❤
Thank you so much, was waiting for this video eagerly!!!
@DataWithBaraa
2 ай бұрын
You are welcome, i hope you will enjoy it !
Thanks alot
Hi Baraa, hope all is well. Question: do you know MySQL and if you do, can you please do a tutorial on it?
Whether all of this work same in MySQL server
ITALY and SQL both are beautiful only by Baraa sir. From sales.orders) t where rank byproduct=1 Above query after bracket the letter t comes. What it mean Thank you sir
@DataWithBaraa
2 ай бұрын
Italy is very lovely and amazing culture. The letter t that comes after the closing bracket in your query is an alias for the subquery. In SQL, you can assign an alias to a table or a subquery to simplify references to it in the rest of your query. In SQL Server it is required to give an Alias after each subquery.
@gopikrishnasistla8896
2 ай бұрын
@@DataWithBaraa thank you sir