SQL Window Functions Basics | Partition By, Order By, Frame |
Вставка
- Опубліковано 23 лип 2024
- 🎬 Full Advanced Course: • How I'd Learn Advanced...
⬇️ Free Materials (Downloads): datawithbaraa.substack.com
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► Join: / @datawithbaraa
► Newsletter: bit.ly/BaraaNewsletter
► LinkedIn: / baraa-khatib-salkini
► Website: www.datawithbaraa.com
📚 Free Courses
✅ Tableau: • Complete HR Tableau Pr...
✅ Tableau Project: • Complete HR Tableau Pr...
✅ SQL Basics: • SQL Tutorial for Begin...
✅ SQL Advanced: • How I'd Learn Advanced...
✅ ChatGPT: • ChatGPT Tutorial for B...
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSkillshare
⭐ My favorite books: kit.co/DataWithBaraa/my-favor...
💻 My gear: kit.co/DataWithBaraa/my-deskt...
⏱️ Timestamp
00:00 intro
00:21 Window vs Group By
12:40 Window Syntax
17:44 Partition By Clause
27:55 Order By Clause
32:13 Frame Clause
46:39 4 Rules of Window
54:17 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* - Наука та технологія
If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
---------------------------------
⏱ TIMESTAMPS ⏱
---------------------------------
00:00 intro
00:21 Window vs Group By
12:40 Window Syntax
17:44 Partition By Clause
27:55 Order By Clause
32:13 Frame Clause
46:39 4 Rules of Window
54:17 Summary
Enjoy !
Hi, Can you also share the presentation and cheat sheet for this course on your website. That'd be really helpful
successfully completed your sql 4 hours course , if i have a teacher like u i can master advance sql in 2months your course is criminally underrated,i have hope your channel will get what it deserves
Cant thank you enough for this course, and how it easily and visually explained, perfect timing for my interview, we need you in our lives 🥰
Bro, TOP MOST BEST CHANNEL ON UA-cam 🎉🎉🎉. KEEP IT UP. PLEASE HAVE MORE COMPLEX ON SQL + POWER BI BRO 🙏🙏🙏🎉🎉🎉
Your explanations are literally top notch easy to understand and follow, the examples are also right on point. Most importantly the way you explain with your diagrams just makes it super easy for a beginner to grasp such complex and important concepts. You deserve a lot of appreciation and support for the kind of content you are doing. Big support and love, keep doing the excellent work.
Great Tutorial , very good examples with clear explanation, all you need to know about window functions in SQL, you are a legend sir, thank you
Awesome content !!! Loved they way you explain everything with great visuals !! 🐐
I wish I could subscribe a thousand times!!! one single subscription is not enough to justify this level of quality for your content !!!
Wow thanks so much, your support means a lot for me and motivate me to make more content 🙂
This is actually a Granularity Level of explaination.. What a LOD explaination 👏👏👏👏👏
Very smart! Thanks for the nice words
Excellent presentation. I appreciate your hand-drawn diagrams and breakdowns.
Thank you! I'm glad you enjoyed it!
Thank you!! Really liked it, hope you complete this incredible course soon! We all appreciate this material :D
Thanks dear :)
YOUR EXPLAINATION ARE SOOOOO GOOD I CAME TO WINDOW FUNCTION BY SIMPLE WAY THANK U LOTSSSS ❤❤ BARAA
Thanks for the nice feedback !
Yesterday, I messed up in test with window functions...Came here! This really helped me. Thank alot Baraa!! You are really gifted with teaching!!
You explain it very nicerly , hatsoff to you bara
hank you so much! I'm really glad you liked it! 🙏😊
You explain the complex things with simple steps and make it easily understandable, you are irreplaceable. Thank you for your efforts for sharing the knowledge.
Excellent presentation. Thanks for sharing.
You are welcome thanks !
Your dedication to providing valuable content is truly commendable. The effort you put into each video is evident and greatly appreciated by your audience. Your channel serves as a reliable source of information and guidance for viewers of all backgrounds. Thank you for consistently delivering high-quality content that enriches the lives of many. Keep up the excellent work!
Thanks for taking time writing this amazing feedback, I really appreciate it.
I have seen multiple videos related to Tableau and SQL, but no one explains them like you do. You helped me a lot to clear up Tableau and SQL concepts.❤
Thanks for the kind words ❤️
wow! very useful tutorial, with a clear explanation and example. Hoping more content about data analysis you deserve a subscribed thank you!
Much appreciated! I will keep pushing as long you guys are enjoying my content
Hi Bara, I must commend the explanation of window functions provided in the video and it was truly exceptional and thorough. Overall, the explanation was superb!!!!
Thank you for the amazing feedback :)
Thank you so much! You are the best teacher to learn from. I'm an aspiring data analyst from a completely different education background and your courses have helped me so much. I am learning Tableau from you and now advanced SQL. I can't thank you enough.
Tons of Thanks for your nice words, I'm glad that everyone is enjoy the course :)
Hello, your teaching style is simple yet impactful, if you share dataset along with it, we can practice while watching
Highly educational, thank you
The hand-drawn diagrams were super helpful in understanding the topic. Great teaching methodology!
Thanks a lot! I'm happy to hear the hand-drawn diagrams made the topic clearer! 😊📝
That was super helpful, thank you!
glad it helped, thanks for the nice comment
Thank you so much for such an amazing interactive session
You are welcome :)
Hi Baraa, You have such command over the subject and your teaching methodology is excellent.This is the first time I've deeply understood the concepts of window functions.Thank you so much.
Thanks for taking time writing this wonderful comment i really appreciate and happy to hear my content is helping. Have a nice day😉
hi Bara, I'm a programmer, not a data scientist, but thanks a lot. Ten years ago, Windows functions didn't exist; I just found out in 2022, but I didn't know how they worked. And you explained clearly to us.
Thanks
Hi sir . As per this video @time 57 minutes and 11 seconds Baraa sir videos for all learners.
From my side Lot of thanks for your idea , thinking and hard work which will benefit all learners.
Thanks and welcome, so nice of you!
Bhai....You are amazing teacher! Salute to you from India❤
You are amazing too for leaving wonderful comment
Awesome sharing. Thanks Baraa!
your welcome
Wonderful bro
Thank you so much! I have learned a lot from this vid :)
I'm so glad!
THANK YOU SO MUCH FOR THIS CONTANT
WELCOME
hi Baraa thank you so much for your amazing videos please make videos on sql performance tuning and debugging please
Like before viewing 👍
:)
thanks for your valuable contents
So nice of you
Excellent stuff Bara!! I love the illustrations esp on Window Frames. Please confirm on the default window frame. Is it RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW / ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW or both. Also what is the default window frame for ()
Thank you master!
You are welcome 😎
Thanks as always.
You are always welcome
Thank you ❤
Welcome 😍
Thank you so much Sir ❤❤
you are very welcome!
@baara can you post the full video for members only access ?
So damn good...
excellent explanation as always..
Glad you liked it!
Excellent Master🎉🎉❤
Thank you! 😃
select Baraa
sum(very lovely explanation) over(such complicated topic, Lots of Blessing and love ❤❤❤❤ to you)
from Akarsh;
---i know its hard for you to ignore the syntax error (but i think you got it)
although, at 45:24 the default frame is 'RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ' not row (in my knowledge)
and
how can i use frame in data analysis ???
Fantastic content Baraa, I love ur videos keep up good work
Thanks, i will try my best :)
Cant thank enough❤
You are so welcome
How you create animation videos what kind of tool you using?
I used ProCreate :)
Excellent video bro ! Can u make a total project in SQL
Great video, thank you! A bit curious, what's the software you're using to draw diagrams and stuff ?
Thank you, I use drawio and procreate
Hi Baraa, Can you please add interview questions as well?
Baraaa, you are the best guru for me, but could you please change your microphone or speak louder so that we can clearly hear your voice without subtitles?
@@ankitkeshari9362 thanks for the kind words ❤️. Oh I didn’t notice that my sound is not clear, are the others having same issue? I will try to be loader in the next videos!
Sir please make a video on multiple tables joins in detail and also tell how the on condition works in joins.
Hi, i explained Joins in details in the Basic SQL Course, please check that out ua-cam.com/video/NTgejLheGeU/v-deo.html
@@DataWithBaraa But sir, in that tutorial you explained the concept of join using only 2 tables, but I am confused about more than 2 tables join.
@@cretive549 noted I will do SQL project at the end of the course and tackle this topic
@@DataWithBaraa please sir make seperate video on that. I want to learn multiple tables join in detail
Please can you do python course? You teach differently.
How can I find the dataset . please help
Hi it is in the download link in video description 🙂
@@DataWithBaraa I got the data set thank you so much. When can we expect the sketchnotes.. For SQL window functions.. Are you planning to release them just like Tableau?
@@nikhilsharma-jj6vd yes but at the end of the course :)
@@DataWithBaraa I'm waiting eagerly.. I've watched two videos and can surely say. No one has expanded and explained the window functions like you've done. A big huge thank you. ❤️
@@nikhilsharma-jj6vd really glad you liked it, and your support to the channel will help reach others ! Thanks for the kind words
In real situation when we used frame what is the goal?!
SELECT Valuable_day FROM Days
WHERE Valuable_day = You;
Clearer at .75 speed….
I will slow down 😉
@@DataWithBaraa no problem….very good lessons….I shared your videos with all the students in my school…..