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 !
@nikhilsharma-jj6vd3 ай бұрын
Hi, Can you also share the presentation and cheat sheet for this course on your website. That'd be really helpful
@jephersonventura75106 күн бұрын
Baraa your tutorials are unlike many others. You break thigns down in a very digestible way, then you give us examples in SQL Server. 10/10 Tutorial!
@rajdhaubanjar23 күн бұрын
You don't need to go in any other channels to understand the window functions, this video is more than enough.
@DataWithBaraa23 күн бұрын
Thank you! 😊 Really glad to hear the video was helpful
@Ascendify54 ай бұрын
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
@jephersonventura75105 күн бұрын
@@Ascendify5 this tutorial is the best out there!
@minjon5621 сағат бұрын
Brilliant! 💙 Your talent to simplify such a complex concept is amazing. Thank you for sharing.
@DataWithBaraa17 сағат бұрын
Thanks for the feedback ❤️
@krizzylovesnature6 күн бұрын
Love how you explain it simply, I wish there are more activities or problems for us . Thanks alot dear.
@DataWithBaraa4 күн бұрын
My pleasure
@sowmya64714 ай бұрын
This is actually a Granularity Level of explaination.. What a LOD explaination 👏👏👏👏👏
@DataWithBaraa4 ай бұрын
Very smart! Thanks for the nice words
@ctvtv-ngogiahuy58072 ай бұрын
I wish I could subscribe a thousand times!!! one single subscription is not enough to justify this level of quality for your content !!!
@DataWithBaraa2 ай бұрын
Wow thanks so much, your support means a lot for me and motivate me to make more content 🙂
@daayush6654Ай бұрын
Awesome content !!! Loved they way you explain everything with great visuals !! 🐐
@MegaJohnwesly3 ай бұрын
Yesterday, I messed up in test with window functions...Came here! This really helped me. Thank alot Baraa!! You are really gifted with teaching!!
@user-hr5bm4oe8fАй бұрын
best resource to learn for sql
@XYZandRGB2 ай бұрын
Excellent presentation. I appreciate your hand-drawn diagrams and breakdowns.
@DataWithBaraa2 ай бұрын
Thank you! I'm glad you enjoyed it!
@SC-mx4wp27 күн бұрын
YOUR VIDEOS ARE AWESOME BRO ❤❤🎉🎉 KEEP IT UP!!! 🎉🎉
@godbhaigod17 күн бұрын
Finally Finally Finally I understood the concept and reason behind the window function😢❤Big burden is OVER() now.
@DataWithBaraa16 күн бұрын
I am happy it is OVER() :)
@wapikasamanta47803 ай бұрын
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.
@sagarprajapati60264 күн бұрын
Literally top notch content.....
@DataWithBaraa4 күн бұрын
Thanks !
@Stuti123454 ай бұрын
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.
@DataWithBaraa4 ай бұрын
Tons of Thanks for your nice words, I'm glad that everyone is enjoy the course :)
@srikarreddy825221 күн бұрын
Man! you teach the topics so well with visualizing every step! thank you!👏
@DataWithBaraa19 күн бұрын
Glad you think so!
@FRANELC-ss8sz4 ай бұрын
YOUR EXPLAINATION ARE SOOOOO GOOD I CAME TO WINDOW FUNCTION BY SIMPLE WAY THANK U LOTSSSS ❤❤ BARAA
@DataWithBaraa4 ай бұрын
Thanks for the nice feedback !
@khawla092Ай бұрын
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 🥰
@TheJADHAVRAM2 ай бұрын
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.❤
@DataWithBaraa2 ай бұрын
Thanks for the kind words ❤️
@DaddyYow202 ай бұрын
wow! very useful tutorial, with a clear explanation and example. Hoping more content about data analysis you deserve a subscribed thank you!
@DataWithBaraa2 ай бұрын
Much appreciated! I will keep pushing as long you guys are enjoying my content
@Theunemployedmen25 күн бұрын
What a man you are , your voice is so soothing i heard it on normal speed and understood everything great content man!
@DataWithBaraa25 күн бұрын
Wow, thanks dear ❤️
@mohammadthousif7439Ай бұрын
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.
@adrianoschwenkberg67734 ай бұрын
Highly educational, thank you
@mochamadsyahrizal22 күн бұрын
You truly know how to teach well. Thanks for this tutorial!
@DataWithBaraa19 күн бұрын
You're very welcome!
@farukhahmad15614 күн бұрын
I see a lot of hard work in your content, I hope you get 1M Soon.
@rezanurkabir704 ай бұрын
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!
@DataWithBaraa4 ай бұрын
Thanks for taking time writing this amazing feedback, I really appreciate it.
@shreyashmhatre9606Ай бұрын
Hello, your teaching style is simple yet impactful, if you share dataset along with it, we can practice while watching
@hafedhabdulhafeedh3195Ай бұрын
That's one of the best! Can't thank you enough!
@SC-mx4wpАй бұрын
Bro, TOP MOST BEST CHANNEL ON KZfaq 🎉🎉🎉. KEEP IT UP. PLEASE HAVE MORE COMPLEX ON SQL + POWER BI BRO 🙏🙏🙏🎉🎉🎉
@sam_nyoike2 ай бұрын
The hand-drawn diagrams were super helpful in understanding the topic. Great teaching methodology!
@DataWithBaraa2 ай бұрын
Thanks a lot! I'm happy to hear the hand-drawn diagrams made the topic clearer! 😊📝
@GowdaKiranGangadhar4 ай бұрын
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!!!!
@DataWithBaraa4 ай бұрын
Thank you for the amazing feedback :)
@jaideepthanage49344 ай бұрын
Bhai....You are amazing teacher! Salute to you from India❤
@DataWithBaraa3 ай бұрын
You are amazing too for leaving wonderful comment
@tarusheebhalla119618 күн бұрын
I totally loved your creative content.... so easy to understand lovedddd it
@DataWithBaraa16 күн бұрын
Thank you so much 😀
@sapbo22843 ай бұрын
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.
@DataWithBaraa3 ай бұрын
Thanks for taking time writing this wonderful comment i really appreciate and happy to hear my content is helping. Have a nice day😉
@DeepakTiwari-et3bdАй бұрын
Thank you so much for such an amazing interactive session
@DataWithBaraaАй бұрын
You are welcome :)
@shakir33732 ай бұрын
That was super helpful, thank you!
@DataWithBaraa2 ай бұрын
glad it helped, thanks for the nice comment
@deeoneill415923 күн бұрын
So easy to follow, thank you
@DataWithBaraa19 күн бұрын
Glad to hear than ❤️
@juancruz78362 ай бұрын
Thank you!! Really liked it, hope you complete this incredible course soon! We all appreciate this material :D
@DataWithBaraa2 ай бұрын
Thanks dear :)
@ashutoshmishra47812 ай бұрын
You explain it very nicerly , hatsoff to you bara
@DataWithBaraa2 ай бұрын
hank you so much! I'm really glad you liked it! 🙏😊
@Parvin-m1sАй бұрын
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
@ferripradana42654 ай бұрын
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
@rajeshantony749 күн бұрын
Great lessons Baraa. I am a new subscriber now!!
@DataWithBaraa9 күн бұрын
@@rajeshantony74 welcome to the channel and thanks for supporting ❤️
@Shokouhikia4 ай бұрын
thanks for your valuable contents
@DataWithBaraa4 ай бұрын
So nice of you
@arnavsharma248514 күн бұрын
Great video
@gopikrishnasistla88964 ай бұрын
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.
@DataWithBaraa4 ай бұрын
Thanks and welcome, so nice of you!
@kn537222 күн бұрын
So good. Thank you!!
@DataWithBaraa19 күн бұрын
Glad you liked it!
@chidimbamalu34904 ай бұрын
Like before viewing 👍
@DataWithBaraa4 ай бұрын
:)
@user-og7vi4ot1i4 ай бұрын
hi Baraa thank you so much for your amazing videos please make videos on sql performance tuning and debugging please
@joyotiegbe15492 ай бұрын
Excellent presentation. Thanks for sharing.
@DataWithBaraa2 ай бұрын
You are welcome thanks !
@RohitKumar-kd5fj20 күн бұрын
Correct 70 to 60 at 36.26 .... BTW the best video on SQL so far .Cheers Baraa
@DataWithBaraa19 күн бұрын
Thanks for the info!
@RohitKumar-kd5fj19 күн бұрын
@@DataWithBaraa Indeed thanks to you Barra. Please make videos on sql order of execution in complete details .
@SaadiaZahoor24 күн бұрын
Thanks for a wonderful lecture
@DataWithBaraa24 күн бұрын
Most welcome!
@c0f2a2 ай бұрын
Thank you so much! I have learned a lot from this vid :)
@DataWithBaraa2 ай бұрын
I'm so glad!
@reemkhaled1334Ай бұрын
THANK YOU SO MUCH FOR THIS CONTANT
@DataWithBaraaАй бұрын
WELCOME
@user-hr5bm4oe8f27 күн бұрын
best teacher for sql ill learn tabealu from you too
@user-ez7jl6ts8x12 күн бұрын
Getting such an amazing content for free feels like cheating.
@emilianolopezfilippini8220Ай бұрын
Cant thank enough❤
@DataWithBaraaАй бұрын
You are so welcome
@apamwamba3 ай бұрын
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 ()
@CuocSongQuanhTa2044 ай бұрын
Awesome sharing. Thanks Baraa!
@DataWithBaraa4 ай бұрын
your welcome
@SaadiaZahoor25 күн бұрын
Thanks 👍
@DataWithBaraa16 күн бұрын
Welcome 👍
@alieut.k.wolobah25154 ай бұрын
Thank you so much Sir ❤❤
@DataWithBaraa4 ай бұрын
you are very welcome!
@makarsh293 ай бұрын
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 ???
@sureshsp29333 ай бұрын
Wonderful bro
@cretive5492 ай бұрын
Sir please make a video on multiple tables joins in detail and also tell how the on condition works in joins.
@DataWithBaraa2 ай бұрын
Hi, i explained Joins in details in the Basic SQL Course, please check that out kzfaq.info/get/bejne/hLqXmM19zcurlYk.html
@cretive5492 ай бұрын
@@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.
@DataWithBaraa2 ай бұрын
@@cretive549 noted I will do SQL project at the end of the course and tackle this topic
@cretive5492 ай бұрын
@@DataWithBaraa please sir make seperate video on that. I want to learn multiple tables join in detail
@OmKale0075 күн бұрын
Your videos are very addictive. KZfaq please take strict actions
@DataWithBaraa4 күн бұрын
Oh no !
@vikashsoni92003 ай бұрын
Thank you ❤
@DataWithBaraa3 ай бұрын
Welcome 😍
@fatihhattatoglu68724 ай бұрын
excellent explanation as always..
@DataWithBaraa4 ай бұрын
Glad you liked it!
@lakshmie32034 ай бұрын
Excellent Master🎉🎉❤
@DataWithBaraa4 ай бұрын
Thank you! 😃
@ankitkeshari9362Ай бұрын
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?
@DataWithBaraaАй бұрын
@@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!
@kom_senapati4 ай бұрын
Fantastic content Baraa, I love ur videos keep up good work
@DataWithBaraa4 ай бұрын
Thanks, i will try my best :)
@Cuxaven3 ай бұрын
Great video, thank you! A bit curious, what's the software you're using to draw diagrams and stuff ?
@DataWithBaraa3 ай бұрын
Thank you, I use drawio and procreate
@norianekrouf7279Ай бұрын
Excellent video bro ! Can u make a total project in SQL
@ychen2024 ай бұрын
So damn good...
@micaelzekarias15374 ай бұрын
Thanks as always.
@DataWithBaraa4 ай бұрын
You are always welcome
@kameshkannan64434 ай бұрын
How you create animation videos what kind of tool you using?
@DataWithBaraa4 ай бұрын
I used ProCreate :)
@guiltycrown602428 күн бұрын
the last problem can also be solved using the table as an alias select customerid,totalsales,rank() over(order by totalsales desc) as ranked from (select customerid, sum(sales) as totalsales from sales.orders group by customerid) as a
@leonardoruiz16234 ай бұрын
Thank you master!
@DataWithBaraa4 ай бұрын
You are welcome 😎
@yashshah86884 ай бұрын
Hi Baraa, Can you please add interview questions as well?
@gurusasidharpattem45534 ай бұрын
@baara can you post the full video for members only access ?
@calebfavour3380Ай бұрын
Please can you do python course? You teach differently.
@rezanurkabir7026 күн бұрын
Can u tell me ,which website did you use to create all diagrams for better understanding?
@DataWithBaraa26 күн бұрын
@@rezanurkabir70 I use drawio and procreate
@OmKale0075 күн бұрын
I wanna ask u Is there really coffee in that cup or is it just for fun
@DataWithBaraa4 күн бұрын
Ofc !! Without coffee I can’t do anything !!
@kumezhКүн бұрын
hey, i wasn't able to download free data materials of this course.. can u please provide the link.
@qasimjan525810 күн бұрын
Hi Baraa, we can use WHERE clause in WINDOW function inside FILTER function incase we are doing "Conditional Aggregation. Am I right?
@DataWithBaraa10 күн бұрын
@@qasimjan5258 yes you can do that using Case when statement
@qasimjan52589 күн бұрын
@@DataWithBaraa MAX(created_at) FILTER (WHERE type = 'Refinance') OVER (PARTITION BY user_id) AS most_recent_refinance
@Karansamal113 ай бұрын
SELECT Valuable_day FROM Days WHERE Valuable_day = You;
@norianekrouf7279Ай бұрын
In real situation when we used frame what is the goal?!
@nikhilsharma-jj6vd3 ай бұрын
How can I find the dataset . please help
@DataWithBaraa3 ай бұрын
Hi it is in the download link in video description 🙂
@nikhilsharma-jj6vd3 ай бұрын
@@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?
@DataWithBaraa3 ай бұрын
@@nikhilsharma-jj6vd yes but at the end of the course :)
@nikhilsharma-jj6vd3 ай бұрын
@@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. ❤️
@DataWithBaraa3 ай бұрын
@@nikhilsharma-jj6vd really glad you liked it, and your support to the channel will help reach others ! Thanks for the kind words
@drorbenami2 ай бұрын
Clearer at .75 speed….
@DataWithBaraaАй бұрын
I will slow down 😉
@drorbenamiАй бұрын
@@DataWithBaraa no problem….very good lessons….I shared your videos with all the students in my school…..
@mkkhan869526 күн бұрын
Watching in 1.5x 🙌
@drorbenami24 күн бұрын
@@mkkhan8695 watching yes…..understanding…..how much ?