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

  Рет қаралды 9,294

Data with Baraa

Data with Baraa

Күн бұрын

Пікірлер: 84
@yashkamath9969
@yashkamath9969 8 күн бұрын
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
@hunorvadasz-perhat6001 2 ай бұрын
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
@guiltycrown6024 4 ай бұрын
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
@DataWithBaraa 4 ай бұрын
Wow, thank you! I'm really glad you like my method !
@shubh_pokharkar8145
@shubh_pokharkar8145 23 сағат бұрын
completed the whole advance sql in 4 days thankyou barra and grateful , learning sql seems easy now
@idreeskhan5129
@idreeskhan5129 7 ай бұрын
Far Far better lectures than any other lectures on you tube . thankyou Bara. You are amazing human being .
@udaymehta8917
@udaymehta8917 18 күн бұрын
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
@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
@syedmohsin1536 Ай бұрын
More worthy than any other paid course.. Eagerly waiting for the python playlist.. 🤩🤩🤩🤩🤩
@DataWithBaraa
@DataWithBaraa Ай бұрын
Nice thanks 🙏
@gauravbharti9676
@gauravbharti9676 5 ай бұрын
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
@c0f2a 6 ай бұрын
The illustrations in your vid are so clear! I am always learning tons from your videos. Thanks a lot!
@DataWithBaraa
@DataWithBaraa 6 ай бұрын
Happy to hear that!
@deepam.g4558
@deepam.g4558 Ай бұрын
I am smashing SQL like never before, Yaay I am loving it.
@DataWithBaraa
@DataWithBaraa Ай бұрын
I‘m very glad you enjoy my videos and you keep supporting the channel this really helps 🙏🙏
@juancruz8392
@juancruz8392 2 ай бұрын
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
@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
@Ferdausi-ow5rw 6 күн бұрын
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
@chandrashekarkammari-l4v 5 күн бұрын
No words brother !!!!!
@ansumanakaikai6207
@ansumanakaikai6207 7 күн бұрын
I’ve learnt so much from Baraa. You’re the best. Thanks a lot. 🤝🤝
@PANKAJKANSAL-y8u
@PANKAJKANSAL-y8u 2 ай бұрын
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
@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
@letsdomistakes 3 ай бұрын
Thank you Baraa , today i completed this lecture with Notes making and practice.
@sajibislam3281
@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
@DataWithBaraa Ай бұрын
Great job!
@govardhanreddy690
@govardhanreddy690 2 ай бұрын
fantastic explanation sir
@DataWithBaraa
@DataWithBaraa 2 ай бұрын
Thanks a lot
@rajshekar1362
@rajshekar1362 4 ай бұрын
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
@DataWithBaraa 4 ай бұрын
Thanks for the amazing support and kind words, glad you liked it. I am doing my best to cover everything ❤️
@zainierizal3807
@zainierizal3807 Ай бұрын
the best lecturer in youtube. Good job Baraa, i really appreciate your videos, thanksss
@DataWithBaraa
@DataWithBaraa Ай бұрын
Wow, thank you!
@Toyahan43
@Toyahan43 2 ай бұрын
You are my favorite DA teacher on and I pray that you get a lot of subs and your channel reaches the top
@gsalema9607
@gsalema9607 4 ай бұрын
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
@MamtaSingh-vs7zt 19 күн бұрын
Just wow🙂Thanks for being so good
@KunalKumar-hw5lb
@KunalKumar-hw5lb 3 ай бұрын
Thank you for teaching the concepts in such an easy manner.
@DataWithBaraa
@DataWithBaraa 3 ай бұрын
You are welcome!
@muhamedhalil
@muhamedhalil 4 ай бұрын
Fascinating content. Respect from Bosnia.
@DataWithBaraa
@DataWithBaraa 4 ай бұрын
Thanks dear, glad you liked it.
@PowerBiWithVivek
@PowerBiWithVivek 18 күн бұрын
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
@190sunny 4 ай бұрын
Good stuff ! Thanks !
@DataWithBaraa
@DataWithBaraa 4 ай бұрын
Glad you liked it!
@emilianolopezfilippini8220
@emilianolopezfilippini8220 4 ай бұрын
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
@DataWithBaraa 4 ай бұрын
I appreciate that! Glad you liked my work.
@snakeeyesA
@snakeeyesA 4 ай бұрын
Thank you sir. VERY clear and easy to understand, I like when you break down what the query is getting row by row.
@DataWithBaraa
@DataWithBaraa 4 ай бұрын
Glad it was helpful!
@suresekhar
@suresekhar 3 ай бұрын
very impressive teaching style. thanks for ur sharing wisdom
@ajay_sahoo0
@ajay_sahoo0 3 ай бұрын
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
@daayush6654 4 ай бұрын
Clear explanations with the visuals💥
@DataWithBaraa
@DataWithBaraa 4 ай бұрын
Glad you liked it!
@asrithagudla4865
@asrithagudla4865 3 ай бұрын
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
@DataWithBaraa 3 ай бұрын
I would suggest to see my playlist if you want to understand everything about tableau
@rishabh-d1s
@rishabh-d1s 4 ай бұрын
Thanks baraa
@DataWithBaraa
@DataWithBaraa 4 ай бұрын
Your welcome
@rajshekar1362
@rajshekar1362 4 ай бұрын
in detail and clear explanation -----Thanq 😍😍
@DataWithBaraa
@DataWithBaraa 4 ай бұрын
You are welcome ❤️
@rakibulhaque3444
@rakibulhaque3444 3 ай бұрын
Thanks
@micaelzekarias1537
@micaelzekarias1537 7 ай бұрын
Good job as always. Thanks
@ashutoshmishra4781
@ashutoshmishra4781 6 ай бұрын
Great content bara sir
@DataWithBaraa
@DataWithBaraa 6 ай бұрын
Thanks 😊
@pavanshetty6086
@pavanshetty6086 6 ай бұрын
❤‍🔥Explanation, teaching style was really good....🔥 Please do a video on CTE and Views in future...
@nitinrawat-g6t
@nitinrawat-g6t 4 ай бұрын
20:39
@joyotiegbe1549
@joyotiegbe1549 6 ай бұрын
Always amazing.
@DataWithBaraa
@DataWithBaraa 6 ай бұрын
You are!
@kennyng3221
@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
@asrithagudla4865 3 ай бұрын
thank you❤
@DataWithBaraa
@DataWithBaraa 3 ай бұрын
Welcome!
@purushottammitra1258
@purushottammitra1258 5 ай бұрын
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
@DataWithBaraa 5 ай бұрын
Noted
@jaideepthanage4934
@jaideepthanage4934 7 ай бұрын
Best one again!
@DataWithBaraa
@DataWithBaraa 6 ай бұрын
thanks !
@yuvarajg533
@yuvarajg533 7 ай бұрын
Hi Baraa, could you please share SQL books where you learned the SQL
@chidimbamalu3490
@chidimbamalu3490 7 ай бұрын
Here we go again ❤.
@gopikrishnasistla8896
@gopikrishnasistla8896 6 ай бұрын
Hi sir we learned MOM analysis. Requesting plz teach us with YOY analysis. Thank you sir.
@DataWithBaraa
@DataWithBaraa 6 ай бұрын
Hi YoY very similar just use Year() instead of month()
@gopikrishnasistla8896
@gopikrishnasistla8896 6 ай бұрын
@@DataWithBaraa thank you sir
@aaqeebshaikh5450
@aaqeebshaikh5450 6 ай бұрын
When the next video will come??
@RakshitDwivedi-pq8qc
@RakshitDwivedi-pq8qc 2 ай бұрын
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
@krupenderm3080 7 ай бұрын
Pls do videos on sub querries
@riyaz7442
@riyaz7442 3 ай бұрын
pls can you make video of YTD,QTD,MTD,YOY,MOM in Tableau
@Dr.RaFatAL-MsieDeen
@Dr.RaFatAL-MsieDeen 3 ай бұрын
question, how you do shift the query to right togather ?
@mahmoudalsayyad90
@mahmoudalsayyad90 2 ай бұрын
thanks a lot! could you please provide the slides?
@WrestleLane
@WrestleLane Ай бұрын
When will you start python series..?
@aaqeebshaikh5450
@aaqeebshaikh5450 6 ай бұрын
When the new video will come
@DataWithBaraa
@DataWithBaraa 6 ай бұрын
Already out Set operators
Каха и дочка
00:28
К-Media
Рет қаралды 3,4 МЛН
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 15 МЛН
Power Query Secrets: Use coalesce (??) to handle null values
6:36
Excel Off The Grid
Рет қаралды 10 М.
SQL NULL vs Empty String vs Blank Space Explained | #SQL Course #10
17:05
Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
16:48
Systems Design in an Hour
1:11:00
Jordan has no life
Рет қаралды 34 М.
What are Tableau WINDOW Functions? (WINDOW_AVG, WINDOW_MIN, WINDOW_MAX)
14:22
OneNumber - Tableau Experts
Рет қаралды 4 М.
How I Would Become a Data Analyst In 2025 (if I had to start over again)
15:40
Avery Smith | Data Analyst
Рет қаралды 47 М.