SQL Window Functions in 10 Minutes

Поділитися
Вставка
  • Опубліковано 17 жов 2022
  • www.udemy.com/course/the-ulti...

КОМЕНТАРІ • 128

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

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

  • @TDMac11
    @TDMac11 Місяць тому +5

    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.

  • @maxwellbicking8276
    @maxwellbicking8276 Рік тому +42

    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

  • @johnvak7390
    @johnvak7390 5 місяців тому +13

    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

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

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

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

  • @joshuaagama1014
    @joshuaagama1014 11 місяців тому +5

    I am so grateful. This explanation erased every confusion!

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

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

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

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

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

  • @kelsey.ann.taylor
    @kelsey.ann.taylor Рік тому +2

    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 😂😅

  • @proterotype
    @proterotype 5 місяців тому +1

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

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

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

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

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

  • @HL-SBR
    @HL-SBR 7 місяців тому +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.

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

    I really struggled with window functions and thanks to you dude I think it's finally starting to make sense!

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

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

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

    The best lecture on window functions EVER. Thanks Colt!

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

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

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

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

  • @limotto9452
    @limotto9452 2 дні тому

    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.

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

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

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

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

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

    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!

  • @SistaSueK
    @SistaSueK 2 дні тому

    You are a very talented teacher.

  • @siddharthsingh5031
    @siddharthsingh5031 9 місяців тому +1

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

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

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

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

    Woohoo! Glad to see you doing SQL

  • @Ira-rr7lf
    @Ira-rr7lf 23 дні тому

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

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

    A simple clear explanation, finally I got it! Thanks

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

    Very clear! Thank you Colt

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

    This was absolutely perfectly clear. Thanks for your work

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

    Literally the best explanation so far

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

    Wonderful crisp and clear

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

    You are the best!. clearly explained the Window functions

  • @andrecoetzer7032
    @andrecoetzer7032 Рік тому +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

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

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

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

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

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

    Amazing window function explaination!! Thanks!

  • @muradaslanli8874
    @muradaslanli8874 8 місяців тому +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👍

  • @sidmoitra007
    @sidmoitra007 9 місяців тому +1

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

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

    One of the best on this topic. Thank you.

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

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

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

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

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

    Very clear explanation! Thanks!

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

    WE NEED THAT ADVANCED SQL COURSE KING!!

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

    so easily and seamlessly explained. thank you so much

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

    Great video. Thank you for sharing!

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

    just amazing. thank you buddy

  • @user-og9fr7ct2u
    @user-og9fr7ct2u 3 місяці тому

    This was brilliant, thank you so much!

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

    Very solid explanation, Thanks mate

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

    Great video! Thanks for explaining this so clearly!

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

    Thank you for making it easy to understand.

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

    The most understandable explanation about window functions ever

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

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

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

    bro loved your content as always ,i have oa next week ,wish me luck!

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

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

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

    Perfectly explained. Thanks

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

    Thanks,
    clear and concise explanation 👌
    Just perfect.

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

    well explained thanks Colt...

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

    Very good explanation. Thank you!

  • @VinayBora-eq9ig
    @VinayBora-eq9ig 11 днів тому

    wow! very nice tutorial🤩

  • @user-xo3wj5fe2m
    @user-xo3wj5fe2m 8 місяців тому

    Very well explained. Thank you!

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

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

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

    Thanks champ! You are the best!!

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

    THIS WAS SO CLEAR TYSM

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

    VERY GOOD EXPLANATION THANK YOU!

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

    Great lecture, clear and concise 👍

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

    Great explanation!

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

    Great Explanations thnx 👍

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

    Love the explanation

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

    Thank you! You really helped so much

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

    The clearest explanation ❤

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

    That was awesome. Thanks

  • @user-ve3no9pm9w
    @user-ve3no9pm9w 15 днів тому

    this video is fantastic, thanks a lot

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

    great explanation
    !

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

    Very clear explanation thank you

  • @kyang-cj2ik
    @kyang-cj2ik 7 місяців тому

    Thank you so much. It was helpful!

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

    Best video on this topic...

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

    great video, great content

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

    Nice and clear!!

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

    great job!

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

    Very helpful. Thanks a bunch!!!!

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

    Thank you so much!

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

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

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

    Amazing thank you !

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

    very useful, thanx for the efforts

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

    Great video

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

    Excelletnt and to the point explanation

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

    very good explanations, thank you

  • @mohamedfaalil
    @mohamedfaalil 11 місяців тому +1

    this video is gem.

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

    Nice video!

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

    We need an advanced SQL course!

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

    Very well explained

  • @ilkhomjoon
    @ilkhomjoon 5 днів тому

    very nice explanation.

  • @user-ek4rp7fi9l
    @user-ek4rp7fi9l 5 місяців тому

    very clear explanation

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

    thank you so much ^^

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

    you are awesome beyond awesomness..

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

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

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

    I love colt’s lectures and videos. ❤. Can i join your bootcamp in San Francisco