SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE |

[@yashkamath9969]

Hi Baraa ,I never really comment on videos, no matter how much I like them, but I had to stop and leave a message after finishing your window functions video. Honestly, your content deserves way more than just a simple thanks. With your expertise in working with real world projects , you not only teach what's the syntax and the rules , but also the use cases and that's so much useful for freshers like me where i understand when and what functions to leverage. You visualizations , your speaking skills are just so perfect for me to understand everything without getting bored. I am just overwhelmed when writing this comment and cant express everything. I can see that your subscribers and views are much less compared to the efforts and the quality of your content but I believe and pray that your channel crosses more and more limits . I can sense your hard work and people are yet to discover this gem of a channel. So keep going Baraa and I will keep going with your videos to learn more and more. Thank You very much Baraa, I look upon you as my elder brother as someone working in the industry and guiding me with the real world experience

[@hunorvadasz-perhat6001]

Yes, it is now official! I have found the BEST TEACHER for ADVANCED SQL on KZbin 🎉🎉 What an effort was put into these high-quality tutorials! ✨✨What a great contribution to the community! 🙏

[@guiltycrown6024]

this content is absolute gold..ive not seen any youtuber or teachers use such striking visualization to teach..these are not only captivating, but help us retain what we learn..thank you for all the effort you put in making this videos..

[@DataWithBaraa]

Wow, thank you! I'm really glad you like my method !

[@shubh_pokharkar8145]

completed the whole advance sql in 4 days thankyou barra and grateful , learning sql seems easy now

[@idreeskhan5129]

Far Far better lectures than any other lectures on you tube . thankyou Bara. You are amazing human being .

[@udaymehta8917]

Even 8-9-10th grade student can learn SQL Advanced after watching this amazing series. Thank you very much sir for your amazing effort. Fun learning. Watching your video & practicing along with you, doesn't feel like working at all. It's fun time for me. You made SQL very easily digestable.

[@shubh_pokharkar8145]

This is one of the best channel to learn sql especially with visuals and examples which Baraa gives with his unique style of presenting knowledge makes it top notch , i wonder why he is having so less subscribers may god suggest he's videos to all the fellows out their confused in their career and sql , you deserve 1 million subscribers man and i know you will definitely get it.

[@syedmohsin1536]

More worthy than any other paid course.. Eagerly waiting for the python playlist.. 🤩🤩🤩🤩🤩

[@DataWithBaraa]

Nice thanks 🙏

[@gauravbharti9676]

Hi Baraa, at 4:08 you might want to correct the slide as it says LEAD function provides value from previous row and LAG function provides value from next row. Thanks for the amazing content. Teaching style is super engaging and easy to learn.

[@c0f2a]

The illustrations in your vid are so clear! I am always learning tons from your videos. Thanks a lot!

[@DataWithBaraa]

Happy to hear that!

[@deepam.g4558]

I am smashing SQL like never before, Yaay I am loving it.

[@DataWithBaraa]

I‘m very glad you enjoy my videos and you keep supporting the channel this really helps 🙏🙏

[@juancruz8392]

the background music, the visuals, and the time you take to explain it is the best I have ever seeing in a tutorial. Good job Baraa, hope this channel gets the love it deserve.

[@shubh_pokharkar8145]

I dont have job right now so i could;nt donate or give a token of momento for your efforts Barra , but i assure i will like , comment on each videos and share it to everyone who is facing challenge in their journey. I will donate once i get job .

[@Ferdausi-ow5rw]

Hello, buddy. You have excellent teaching methods. I appreciate how you taught things in a simple and understandable manner. By the way, could you please tell me what tools you use for mind mapping? So that I can use it in my academic studies. Thank you for sharing such high-quality content ❤️😊.

[@chandrashekarkammari-l4v]

No words brother !!!!!

[@ansumanakaikai6207]

I’ve learnt so much from Baraa. You’re the best. Thanks a lot. 🤝🤝

[@PANKAJKANSAL-y8u]

I have seen many tutorials in you tube but this is the only advance sql tutorial which is best in the world. Thankyou so much sir to give the high quality content. And please provide the full data analytics course with the best guidence roadmap. God Bless you Sir ❤❤

[@HiteshSharma-18]

I Dont Know How To Explain In Words, What Your Tutorials Means To Me Baraa.So I Will Just Say Thank You For Sharing Your Precious Knowledge Free Of Cost,Hugee Hugee Fan From India.

[@letsdomistakes]

Thank you Baraa , today i completed this lecture with Notes making and practice.

[@sajibislam3281]

Thank you so much Bara.. Just completed the Window Function... It is so clear now.. I will finish Remaining tutorials consecutively and will leave a comment for your effort.

[@DataWithBaraa]

Great job!

[@govardhanreddy690]

fantastic explanation sir

[@DataWithBaraa]

Thanks a lot

[@rajshekar1362]

Thanks so much for the in depth knowledge of sql ,4 Months I joined institute for Data analytics course (Excelr) this paid courses also Nothing infront of your Teaching love From Bharat💓 Request from my side do each and every topic of SQL

[@DataWithBaraa]

Thanks for the amazing support and kind words, glad you liked it. I am doing my best to cover everything ❤️

[@zainierizal3807]

the best lecturer in youtube. Good job Baraa, i really appreciate your videos, thanksss

[@DataWithBaraa]

Wow, thank you!

[@Toyahan43]

You are my favorite DA teacher on and I pray that you get a lot of subs and your channel reaches the top

[@gsalema9607]

I am in tear! Thank you so much For first time I feel like I am really learning something about data I pass all day long in my head trying to use what I learned from you in different cases wherever I am, may God bless you ❤🎉

[@MamtaSingh-vs7zt]

Just wow🙂Thanks for being so good

[@KunalKumar-hw5lb]

Thank you for teaching the concepts in such an easy manner.

[@DataWithBaraa]

You are welcome!

[@muhamedhalil]

Fascinating content. Respect from Bosnia.

[@DataWithBaraa]

Thanks dear, glad you liked it.

[@PowerBiWithVivek]

Your videos are remarkable because they explain concepts using graphical representations 📊, which sets you apart from other teachers. Additionally, could you create a video to demonstrate the difference between cumulative distribution and percent rank? 🤔 I would appreciate more clarity on their use cases in practical situations. 🙏

[@190sunny]

Good stuff ! Thanks !

[@DataWithBaraa]

Glad you liked it!

[@emilianolopezfilippini8220]

Its absolutly valuable how u relate every concept with a real use case. Always well time spent watching your videos Baraa. Im getting into data science world and find a mentor in you thanx

[@DataWithBaraa]

I appreciate that! Glad you liked my work.

[@snakeeyesA]

Thank you sir. VERY clear and easy to understand, I like when you break down what the query is getting row by row.

[@DataWithBaraa]

Glad it was helpful!

[@suresekhar]

very impressive teaching style. thanks for ur sharing wisdom

[@ajay_sahoo0]

Thank You Baraa.... I am searching for a good SQL Tutorial a long time. I like the way you are teaching with attractive visuals and clear cut summary at the end.. Please Provide CTE's and Stored Procedures etc. Waiting & Thank You once again

[@daayush6654]

Clear explanations with the visuals💥

[@DataWithBaraa]

Glad you liked it!

[@asrithagudla4865]

Hi bara, I’m currently going through all of your SQL videos, and right now, I'm learning advanced SQL. I came across your Tableau videos and want to learn Tableau from you. Could you suggest a playlist, or should I watch the 2-hour complete Tableau video? I want to master it under your guidance, so I’d appreciate any recommendations. Thank you!

[@DataWithBaraa]

I would suggest to see my playlist if you want to understand everything about tableau

[@rishabh-d1s]

Thanks baraa

[@DataWithBaraa]

Your welcome

[@rajshekar1362]

in detail and clear explanation -----Thanq 😍😍

[@DataWithBaraa]

You are welcome ❤️

[@rakibulhaque3444]

Thanks

[@micaelzekarias1537]

Good job as always. Thanks

[@ashutoshmishra4781]

Great content bara sir

[@DataWithBaraa]

Thanks 😊

[@pavanshetty6086]

❤‍🔥Explanation, teaching style was really good....🔥 Please do a video on CTE and Views in future...

[@nitinrawat-g6t]

20:39

[@joyotiegbe1549]

Always amazing.

[@DataWithBaraa]

You are!

[@kennyng3221]

Hi Baraa, hope you doing well, since I am a fresh graduate who started planning to be a data analyst just couple months ago, I have been watching your videos which is very detailed and beginner-friendly! Thanks for your effort. However, as a non-data related degree holder, how do I show employer that I am capable to do the job? Is certificates needed? If needed, which SQL certificate do you recommend? But I am still learning and not prepared for now, just asking for if I want to do it in the future!

[@asrithagudla4865]

thank you❤

[@DataWithBaraa]

Welcome!

[@purushottammitra1258]

Bara an earnest request, can you pls make a video on Month on month , year on Year Growth and also YTD, MTD and QTD

[@DataWithBaraa]

Noted

[@jaideepthanage4934]

Best one again!

[@DataWithBaraa]

thanks !

[@yuvarajg533]

Hi Baraa, could you please share SQL books where you learned the SQL

[@chidimbamalu3490]

Here we go again ❤.

[@gopikrishnasistla8896]

Hi sir we learned MOM analysis. Requesting plz teach us with YOY analysis. Thank you sir.

[@DataWithBaraa]

Hi YoY very similar just use Year() instead of month()

[@gopikrishnasistla8896]

@@DataWithBaraa thank you sir

[@aaqeebshaikh5450]

When the next video will come??

[@RakshitDwivedi-pq8qc]

I have a question - in % MoM change. the first value is NULL substracting CurrentMonthsales with PreviousMonthSales but that would give incorrect analysis as there is a change MoM so do we replace NULL with 0 or let NULL be as it is since we don't have a previous month date.

[@krupenderm3080]

Pls do videos on sub querries

[@riyaz7442]

pls can you make video of YTD,QTD,MTD,YOY,MOM in Tableau

[@Dr.RaFatAL-MsieDeen]

question, how you do shift the query to right togather ?

[@mahmoudalsayyad90]

thanks a lot! could you please provide the slides?

[@WrestleLane]

When will you start python series..?

[@aaqeebshaikh5450]

When the new video will come

[@DataWithBaraa]

Already out Set operators