SQL Window Functions in 10 Minutes

Поділитися
Вставка
  • Опубліковано 22 лис 2024

КОМЕНТАРІ • 163

  • @bananaboydan3642
    @bananaboydan3642 Рік тому +178

    I have never seen anyone explain this so clearly. Thank you so much

  • @Semio_Elias
    @Semio_Elias 2 місяці тому +10

    I hardly ever comment on video but I had to for this video, I have been so confused about how to use these Window functions, this video is the most simplifed explanation. Thank you very much. After watching this video, I understand it perfectly well, no longer confused again

  • @johnvak7390
    @johnvak7390 9 місяців тому +21

    Bro literally the clearest of explanation and a guy that actually explain all the parts. If i ever get into data analytics, i hope i have someone like you as a person I can shadow. STG

  • @maxwellbicking8276
    @maxwellbicking8276 2 роки тому +49

    Please do an advanced SQL course as a follow up to your Ultimate Bootcamp! It would be so awesome to see more advanced applications of SQL for data analytics

  • @rachitsharma8644
    @rachitsharma8644 6 днів тому

    Bro has the clearest explanation even after 2 years. Thank you for the amazing tutorial.

  • @TDMac11
    @TDMac11 5 місяців тому +8

    I've been trying to understand this for 24 hours with no real traction and you summed it up in 10 minutes. You have a real gift, thank you.

  • @joshuaagama1014
    @joshuaagama1014 Рік тому +6

    I am so grateful. This explanation erased every confusion!

  • @proterotype
    @proterotype 9 місяців тому +2

    Dude, I am nerding out over this! Where has this been all my life

  • @topanime7563
    @topanime7563 Рік тому +5

    Short, direct and clear explanation. You dropped your crown 👑

  • @pavaniarra2144
    @pavaniarra2144 Місяць тому

    This is the best video on window funcitons i've ever watched. Thankyou for making the concept clear.😇

  • @banamailat_BM
    @banamailat_BM Рік тому +2

    Really thank you. I'm pretty new to SQL. All the puzzle pieces related to Window functions fell into place. I didn't fully understand until I watched this video. Thank you again.

  • @janardhan4814
    @janardhan4814 Рік тому +3

    I have always been trying to use the window functions without understanding how they work. Thanks to you, most of the window functions now makes sense.

  • @Kelsey.Ann.Taylor
    @Kelsey.Ann.Taylor Рік тому +3

    WILDLY helpful, this is the first video I’ve found that lays this out so clearly. Wish I’d found this before the technical interview I had today 😂😅

  • @HL-SBR
    @HL-SBR 11 місяців тому +1

    You're heaven sent. Been racking my brains since last month learning SQL on a browser based coding tutorial site, and some concepts are just plain jargon for me. You're explanation here is super simple and easy to digest. I guess some people really have that talent on how to teach superbly well. Great job, I think I'm gonna sign up on your Udemy SQL course enhance what I already learned.

  • @monicabetancourt7996
    @monicabetancourt7996 9 місяців тому

    Wow you made something so hard and complicated to explain to a walk in the park. Thank you! I am new to this, and it was in Martian; now it is in simple English. Blessings!

  • @subhambasu4012
    @subhambasu4012 3 місяці тому

    Best ever video that I saw over any platform regarding SQL window functions.....

  • @katyaynisrivastava9961
    @katyaynisrivastava9961 10 місяців тому

    I don't usually write comments, I'm sleepy and my brain is working in 2 cells but I still got it. Great explanation.

  • @xephazxephaz2092
    @xephazxephaz2092 3 дні тому

    This explanation is everythingggg!! Thank you Colt.

  • @theamithsingh
    @theamithsingh 8 місяців тому +1

    glad i clicked this as my first video about window function 😊

  • @jingchaowang5532
    @jingchaowang5532 6 місяців тому

    The best lecture on window functions EVER. Thanks Colt!

  • @muhammadarshadalishaik6870
    @muhammadarshadalishaik6870 4 місяці тому

    Within 10 minutes, I got what I needed. Excellent presentation. Wish you made videos on advanced SQL like cte...

  • @Ira-rr7lf
    @Ira-rr7lf 4 місяці тому

    It's the best explanation of the Window Functions that I've seen. Thank you so much!

  • @Son_of_Gondor96
    @Son_of_Gondor96 27 днів тому

    Hey Mr. Colt, great explanation concise and clear. I'll keep following your work.
    Cheers.

  • @carlosfernandez6477
    @carlosfernandez6477 Рік тому +1

    Literally the best explanation so far

  • @olgaklimenko944
    @olgaklimenko944 7 місяців тому

    The most understandable explanation about window functions ever

  • @sidmoitra007
    @sidmoitra007 Рік тому +1

    Hi, I have bought ur course in udemy. Thanks for all your effort. Great teacher!

  • @thetungstenduck
    @thetungstenduck Рік тому

    I spent over an hour not understanding this until now. Thank you!

  • @emilymalkin270
    @emilymalkin270 6 місяців тому

    I stumbled upon this lesson by chance and I am amazed by your teaching style and presеntation! I actually know about all that was taught in this lesson, but I just could not stop watching because oh how well you presented! I wish you taught Power BI because I was looking for a power BI equivalent. 😉

  • @MiltonWeinhold
    @MiltonWeinhold 2 місяці тому

    This is TOP TIER explanation, thank you so much!

  • @emanuelgabrielbarata4121
    @emanuelgabrielbarata4121 8 місяців тому

    the best explanation on window functions I`ve ever seen, thanks

  • @limotto9452
    @limotto9452 4 місяці тому

    Thank you very much for making this video. I have a hard time to fully grasp the concept of window function. Your explanation clears all confusion for me and I will rmb this forever.

  • @siddharthsingh5031
    @siddharthsingh5031 Рік тому +1

    Wow! This was gold standard explanation. Thanks a lot.

  • @vybhavavenkatesh7703
    @vybhavavenkatesh7703 8 місяців тому +1

    I like the last sentence in the video. great explanation.

  • @veronikafrankovicova5060
    @veronikafrankovicova5060 6 днів тому

    Great video - the explanation, the visuals you use,... Thank you!

  • @pablovindas9955
    @pablovindas9955 9 місяців тому

    A simple clear explanation, finally I got it! Thanks

  • @thiorofall8751
    @thiorofall8751 Рік тому +1

    So far, the best SQL Window functions video. Thanks you so much!

  • @marcelobour
    @marcelobour Рік тому +1

    Super clear explanation, in 2 minutes I had understood, thanks!

  • @fdu6
    @fdu6 9 місяців тому

    This was absolutely perfectly clear. Thanks for your work

  • @xgerra16
    @xgerra16 9 місяців тому

    WE NEED THAT ADVANCED SQL COURSE KING!!

  • @SistaSueK
    @SistaSueK 4 місяці тому

    You are a very talented teacher.

  • @shadowthehedgehog2727
    @shadowthehedgehog2727 Рік тому +1

    Damn SQL is so powerful... great job explaining this

  • @muradaslanli8874
    @muradaslanli8874 Рік тому +1

    Great thanks for amazing and understandable explanation. Even I have watch many youtube videos, however only understand it after your video. Thank you, keep going👍

  • @edgarleiva2144
    @edgarleiva2144 9 місяців тому

    Best explanation of the world!!!, so happy that I could dance with a wheelchair

  • @austecon6818
    @austecon6818 6 місяців тому

    So great. Thanks. I wish you would have also covered cumulative sums though too because I am using that now.

  • @rohitpatil6111
    @rohitpatil6111 11 місяців тому

    so easily and seamlessly explained. thank you so much

  • @XzcutioneR2
    @XzcutioneR2 2 місяці тому

    Dude. You're a lifesaver!

  • @claraoliva254
    @claraoliva254 Рік тому

    lifesaver omg thank you so much for the side by side comparison of group by vs window

  • @sargata3054
    @sargata3054 3 місяці тому

    Awesome explanation and demonstration. I finally understand OVER() more. Thank you!

  • @Our_Joyful_Journeys
    @Our_Joyful_Journeys 7 місяців тому

    You are the best!. clearly explained the Window functions

  • @JuanHernandez-pf6yg
    @JuanHernandez-pf6yg Місяць тому

    Very useful. Thank you! Where is the video in which you explain the lead() and lag() functions, please?

  • @tonywalls1728
    @tonywalls1728 7 місяців тому

    Instant sub! Didn't even have to rewatch, this was SO clear. Thank you so much!!

  • @michaelp9061
    @michaelp9061 8 місяців тому

    One of the best on this topic. Thank you.

  • @designrevolutionsent
    @designrevolutionsent 2 місяці тому

    Amazing video. So much given in just 10 minutes. I'll definitely buy the Udemy course.

  • @ekaterinaafanaseva6460
    @ekaterinaafanaseva6460 5 місяців тому

    The clearest explanation ❤

  • @afiblebo490
    @afiblebo490 2 місяці тому

    Best explanation by far!

  • @returnMarcco
    @returnMarcco 7 місяців тому

    Great lecture, clear and concise 👍

  • @jouGOETE
    @jouGOETE 7 місяців тому

    Well explained in an English accent I can understand. Thank you...
    (English isn't my first language, b.t.w.)

  • @uirriiurriuuiruruuir
    @uirriiurriuuiruruuir Місяць тому +1

    Nice

  • @dominicirudhayaraj1313
    @dominicirudhayaraj1313 6 місяців тому

    Wonderful crisp and clear

  • @ShwetaSingh-u2s
    @ShwetaSingh-u2s 6 днів тому

    Thanks for explaining in such a nice way

  • @mohamedfaalil
    @mohamedfaalil Рік тому +2

    this video is gem.

  • @GabrielGarcia-ew2em
    @GabrielGarcia-ew2em Рік тому +1

    It was sooooo clear, AMAZING explanation, thank you very much man!

  • @jorgegt8819
    @jorgegt8819 2 місяці тому

    Dude this was so well explained, thanks man

  • @religious2155
    @religious2155 3 місяці тому

    Nice , Easy explanation thank you

  • @missrizzer
    @missrizzer 12 днів тому

    omg Colt thank you for explainin it and makes it easy to understand!

  • @pratikmandlecha6672
    @pratikmandlecha6672 10 місяців тому

    Perfectly explained. Thanks

  • @andrecoetzer7032
    @andrecoetzer7032 2 роки тому +1

    Colt you should become a model. You a natural infront of the camera xD. I have a feeling you enjoy the picture taking a lot. Haha

  • @MotivationUnleashedOfficial.
    @MotivationUnleashedOfficial. 2 місяці тому

    bro gave such a good explanation

  • @AjayYadav-ev2ej
    @AjayYadav-ev2ej 2 місяці тому

    Best explained.. Need more sql video

  • @bbiasao
    @bbiasao 4 місяці тому

    Very clear explanation! Thanks!

  • @Qasimwahaj2024
    @Qasimwahaj2024 Рік тому

    Thank you for making it easy to understand.

  • @carloslizarraga1240
    @carloslizarraga1240 7 місяців тому

    Such a great video to understand this advaced concept. Thanks a bunch!!

  • @arkyadas7849
    @arkyadas7849 3 місяці тому

    Please make a video explaining how running total gets calculated with window function. I mean what is the inner working.

  • @fbravoc9748
    @fbravoc9748 Рік тому

    Amazing window function explaination!! Thanks!

  • @qamarhoms5880
    @qamarhoms5880 Рік тому

    Very clear explanation thank you

  • @Joeysz
    @Joeysz Рік тому +1

    We need an advanced SQL course!

  • @aditideshpande5566
    @aditideshpande5566 6 місяців тому

    Great video! Thanks for explaining this so clearly!

  • @mihailisman8940
    @mihailisman8940 Рік тому

    Very good explanation. Thank you!

  • @yanivavraham3772
    @yanivavraham3772 11 місяців тому

    VERY GOOD EXPLANATION THANK YOU!

  • @pranavbhat92
    @pranavbhat92 11 місяців тому

    Very clear! Thank you Colt

  • @chandanjha3205
    @chandanjha3205 9 місяців тому

    Best video on this topic...

  • @mrmuranga
    @mrmuranga 8 місяців тому

    well explained thanks Colt...

  • @andrewcenteno3462
    @andrewcenteno3462 2 місяці тому

    beautiful tutorial

  • @ahmadkelany
    @ahmadkelany Рік тому

    Thanks,
    clear and concise explanation 👌
    Just perfect.

  • @VinayBora-eq9ig
    @VinayBora-eq9ig 4 місяці тому

    wow! very nice tutorial🤩

  • @Perer876
    @Perer876 2 місяці тому

    Amazing explanation!

  • @BadrinathIllur
    @BadrinathIllur 9 місяців тому

    very clear explanation

  • @imtiazshoykat
    @imtiazshoykat 6 місяців тому

    Thanks. This is so helpful though I still only know oracle Sql 😊

  • @anjumanalam
    @anjumanalam 2 роки тому

    Woohoo! Glad to see you doing SQL

  • @ShreyashBohara
    @ShreyashBohara 11 місяців тому

    Can you also make a video for lead/lag? This was a great explanation

  • @goramnikitha5491
    @goramnikitha5491 11 місяців тому

    Love the explanation

  • @mohammadturabali3870
    @mohammadturabali3870 Рік тому

    Excelletnt and to the point explanation

  • @krishnapande8941
    @krishnapande8941 Рік тому

    Great Explanations thnx 👍

  • @alexzink4451
    @alexzink4451 11 днів тому

    Very clear, thank u 4 ur effort!

  • @DanParris-q2p
    @DanParris-q2p 7 місяців тому

    This was brilliant, thank you so much!

  • @markslima1557
    @markslima1557 2 роки тому

    Oh awesome! Thanks for posting a video on this totally was looking for more info on SQL window functions.

  • @radeshf
    @radeshf Рік тому

    very good explanations, thank you

  • @vaibhavsrivastava9585
    @vaibhavsrivastava9585 8 місяців тому

    Very well explained

  • @ilkhomjoon
    @ilkhomjoon 4 місяці тому

    very nice explanation.

  • @ChristianCastillo-j4f
    @ChristianCastillo-j4f Рік тому

    Very well explained. Thank you!