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-jj6vd

Ай бұрын

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

Bro, TOP MOST BEST CHANNEL ON KZread 🎉🎉🎉. KEEP IT UP. PLEASE HAVE MORE COMPLEX ON SQL + POWER BI BRO 🙏🙏🙏🎉🎉🎉

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 🥰

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.

I wish I could subscribe a thousand times!!! one single subscription is not enough to justify this level of quality for your content !!!

@DataWithBaraa

Ай бұрын

Wow thanks so much, your support means a lot for me and motivate me to make more content 🙂

Hello, your teaching style is simple yet impactful, if you share dataset along with it, we can practice while watching

This is actually a Granularity Level of explaination.. What a LOD explaination 👏👏👏👏👏

@DataWithBaraa

3 ай бұрын

Very smart! Thanks for the nice words

Excellent presentation. I appreciate your hand-drawn diagrams and breakdowns.

@DataWithBaraa

Ай бұрын

Thank you! I'm glad you enjoyed it!

You explain it very nicerly , hatsoff to you bara

@DataWithBaraa

Ай бұрын

hank you so much! I'm really glad you liked it! 🙏😊

YOUR EXPLAINATION ARE SOOOOO GOOD I CAME TO WINDOW FUNCTION BY SIMPLE WAY THANK U LOTSSSS ❤❤ BARAA

@DataWithBaraa

3 ай бұрын

Thanks for the nice feedback !

Thank you!! Really liked it, hope you complete this incredible course soon! We all appreciate this material :D

@DataWithBaraa

28 күн бұрын

Thanks dear :)

Yesterday, I messed up in test with window functions...Came here! This really helped me. Thank alot Baraa!! You are really gifted with teaching!!

Excellent presentation. Thanks for sharing.

@DataWithBaraa

Ай бұрын

You are welcome thanks !

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.

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!!!!

@DataWithBaraa

3 ай бұрын

Thank you for the amazing feedback :)

wow! very useful tutorial, with a clear explanation and example. Hoping more content about data analysis you deserve a subscribed thank you!

@DataWithBaraa

29 күн бұрын

Much appreciated! I will keep pushing as long you guys are enjoying my content

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.❤

@DataWithBaraa

Ай бұрын

Thanks for the kind words ❤️

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!

@DataWithBaraa

3 ай бұрын

Thanks for taking time writing this amazing feedback, I really appreciate it.

Highly educational, thank you

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.

@DataWithBaraa

3 ай бұрын

Tons of Thanks for your nice words, I'm glad that everyone is enjoy the course :)

hi Baraa thank you so much for your amazing videos please make videos on sql performance tuning and debugging please

The hand-drawn diagrams were super helpful in understanding the topic. Great teaching methodology!

@DataWithBaraa

Ай бұрын

Thanks a lot! I'm happy to hear the hand-drawn diagrams made the topic clearer! 😊📝

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.

@DataWithBaraa

2 ай бұрын

Thanks for taking time writing this wonderful comment i really appreciate and happy to hear my content is helping. Have a nice day😉

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 ()

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.

@DataWithBaraa

3 ай бұрын

Thanks and welcome, so nice of 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 ???

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

Awesome sharing. Thanks Baraa!

@DataWithBaraa

3 ай бұрын

your welcome

Thank you so much for such an amazing interactive session

@DataWithBaraa

21 күн бұрын

You are welcome :)

Bhai....You are amazing teacher! Salute to you from India❤

@DataWithBaraa

2 ай бұрын

You are amazing too for leaving wonderful comment

That was super helpful, thank you!

@DataWithBaraa

Ай бұрын

glad it helped, thanks for the nice comment

Wonderful bro

Like before viewing 👍

@DataWithBaraa

3 ай бұрын

:)

thanks for your valuable contents

@DataWithBaraa

3 ай бұрын

So nice of you

Thank you so much! I have learned a lot from this vid :)

@DataWithBaraa

29 күн бұрын

I'm so glad!

Fantastic content Baraa, I love ur videos keep up good work

@DataWithBaraa

3 ай бұрын

Thanks, i will try my best :)

excellent explanation as always..

@DataWithBaraa

3 ай бұрын

Glad you liked it!

@baara can you post the full video for members only access ?

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

17 күн бұрын

@@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!

Great video, thank you! A bit curious, what's the software you're using to draw diagrams and stuff ?

@DataWithBaraa

Ай бұрын

Thank you, I use drawio and procreate

Sir please make a video on multiple tables joins in detail and also tell how the on condition works in joins.

@DataWithBaraa

Ай бұрын

Hi, i explained Joins in details in the Basic SQL Course, please check that out kzread.info/dash/bejne/gIibx8yFmMitlbg.html

@cretive549

Ай бұрын

@@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.

@DataWithBaraa

Ай бұрын

@@cretive549 noted I will do SQL project at the end of the course and tackle this topic

@cretive549

Ай бұрын

@@DataWithBaraa please sir make seperate video on that. I want to learn multiple tables join in detail

Thanks as always.

@DataWithBaraa

3 ай бұрын

You are always welcome

Thank you so much Sir ❤❤

@DataWithBaraa

3 ай бұрын

you are very welcome!

Thank you ❤

@DataWithBaraa

2 ай бұрын

Welcome 😍

Excellent Master🎉🎉❤

@DataWithBaraa

3 ай бұрын

Thank you! 😃

Thank you master!

@DataWithBaraa

3 ай бұрын

You are welcome 😎

Excellent video bro ! Can u make a total project in SQL

How you create animation videos what kind of tool you using?

@DataWithBaraa

3 ай бұрын

I used ProCreate :)

Hi Baraa, Can you please add interview questions as well?

So damn good...

Please can you do python course? You teach differently.

In real situation when we used frame what is the goal?!

How can I find the dataset . please help

@DataWithBaraa

Ай бұрын

Hi it is in the download link in video description 🙂

@nikhilsharma-jj6vd

Ай бұрын

@@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?

@DataWithBaraa

Ай бұрын

@@nikhilsharma-jj6vd yes but at the end of the course :)

@nikhilsharma-jj6vd

Ай бұрын

@@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. ❤️

@DataWithBaraa

Ай бұрын

@@nikhilsharma-jj6vd really glad you liked it, and your support to the channel will help reach others ! Thanks for the kind words

SELECT Valuable_day FROM Days WHERE Valuable_day = You;

Clearer at .75 speed….

@DataWithBaraa

20 күн бұрын

I will slow down 😉

@drorbenami

20 күн бұрын

@@DataWithBaraa no problem….very good lessons….I shared your videos with all the students in my school…..