I have never seen anyone explain this so clearly. Thank you so much
@osoriomatucurane95115 ай бұрын
You are absolutely right, I must admit
@maxwellbicking8276 Жыл бұрын
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
@jingchaowang55325 күн бұрын
The best lecture on window functions EVER. Thanks Colt!
@johnvak73903 ай бұрын
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
@joshuaagama10149 ай бұрын
I am so grateful. This explanation erased every confusion!
@proterotype2 ай бұрын
Dude, I am nerding out over this! Where has this been all my life
@littlebigdawg Жыл бұрын
I spent over an hour not understanding this until now. Thank you!
@thiorofall8751 Жыл бұрын
So far, the best SQL Window functions video. Thanks you so much!
@topanime75637 ай бұрын
Short, direct and clear explanation. You dropped your crown 👑
@janardhan4814 Жыл бұрын
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.
@evelyn_deforest933 ай бұрын
I really struggled with window functions and thanks to you dude I think it's finally starting to make sense!
@GabrielGarcia-ew2em10 ай бұрын
It was sooooo clear, AMAZING explanation, thank you very much man!
@siddharthsingh50317 ай бұрын
Wow! This was gold standard explanation. Thanks a lot.
@emilymalkin27025 күн бұрын
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. 😉
@marcelobour10 ай бұрын
Super clear explanation, in 2 minutes I had understood, thanks!
@tonywalls1728Ай бұрын
Instant sub! Didn't even have to rewatch, this was SO clear. Thank you so much!!
@banamailat_BM10 ай бұрын
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.
@kelsey.ann.taylor Жыл бұрын
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 😂😅
@pranavbhat925 ай бұрын
Very clear! Thank you Colt
@fdu63 ай бұрын
This was absolutely perfectly clear. Thanks for your work
@carloslizarraga1240Ай бұрын
Such a great video to understand this advaced concept. Thanks a bunch!!
@theamithsingh2 ай бұрын
glad i clicked this as my first video about window function 😊
@pablovindas99553 ай бұрын
A simple clear explanation, finally I got it! Thanks
@fbravoc97486 ай бұрын
Amazing window function explaination!! Thanks!
@zeyondАй бұрын
You are the best!. clearly explained the Window functions
@claraoliva2547 ай бұрын
lifesaver omg thank you so much for the side by side comparison of group by vs window
@markslima1557 Жыл бұрын
Oh awesome! Thanks for posting a video on this totally was looking for more info on SQL window functions.
@carlosfernandez64779 ай бұрын
Literally the best explanation so far
@michaelp90612 ай бұрын
One of the best on this topic. Thank you.
@aditideshpande556611 күн бұрын
Great video! Thanks for explaining this so clearly!
@HL-SBR5 ай бұрын
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.
@lucasinocencio46684 ай бұрын
just amazing. thank you buddy
@monicabetancourt79963 ай бұрын
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!
@hameddadgourАй бұрын
Great video. Thank you for sharing!
@mrmurangaАй бұрын
well explained thanks Colt...
@anjumanalam Жыл бұрын
Woohoo! Glad to see you doing SQL
@rohitpatil61114 ай бұрын
so easily and seamlessly explained. thank you so much
@pratikmandlecha66724 ай бұрын
Perfectly explained. Thanks
@emanuelgabrielbarata41212 ай бұрын
the best explanation on window functions I`ve ever seen, thanks
@perianka2 ай бұрын
THIS WAS SO CLEAR TYSM
@krishnapande894111 ай бұрын
Great Explanations thnx 👍
@user-og9fr7ct2uАй бұрын
This was brilliant, thank you so much!
@marvhan88810 ай бұрын
great video, great content
@zynga512 Жыл бұрын
Very solid explanation, Thanks mate
@ahmadkelany8 ай бұрын
Thanks, clear and concise explanation 👌 Just perfect.
@mihailisman89406 ай бұрын
Very good explanation. Thank you!
@sharmanihal994 ай бұрын
Great video
@shadowthehedgehog27276 ай бұрын
Damn SQL is so powerful... great job explaining this
@goramnikitha54915 ай бұрын
Love the explanation
@valentinakurenshchikova81183 ай бұрын
great explanation !
@yanivavraham37725 ай бұрын
VERY GOOD EXPLANATION THANK YOU!
@muradaslanli88746 ай бұрын
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👍
@vybhavavenkatesh77032 ай бұрын
I like the last sentence in the video. great explanation.
@battlesship11 ай бұрын
Great explanation!
@user-xo3wj5fe2m6 ай бұрын
Very well explained. Thank you!
@evolutionstation20248 ай бұрын
Thank you for making it easy to understand.
@adrianoschwenkberg6773Ай бұрын
very useful, thanx for the efforts
@djalan8412 сағат бұрын
Nice and clear!!
@SuaveBBX4 ай бұрын
Thanks champ! You are the best!!
@returnMarccoАй бұрын
Great lecture, clear and concise 👍
@chandanjha32053 ай бұрын
Best video on this topic...
@JamesTAu987 ай бұрын
That was awesome. Thanks
@inkarsagatova37323 күн бұрын
Thank you! You really helped so much
@qamarhoms58807 ай бұрын
Very clear explanation thank you
@TheViktormartin2 күн бұрын
Nice video!
@sidmoitra0077 ай бұрын
Hi, I have bought ur course in udemy. Thanks for all your effort. Great teacher!
@edgarleiva21443 ай бұрын
Best explanation of the world!!!, so happy that I could dance with a wheelchair
@austecon68188 күн бұрын
So great. Thanks. I wish you would have also covered cumulative sums though too because I am using that now.
@mohammadturabali38707 ай бұрын
Excelletnt and to the point explanation
@kyang-cj2ik5 ай бұрын
Thank you so much. It was helpful!
@olgaklimenko944Ай бұрын
The most understandable explanation about window functions ever
@radeshf8 ай бұрын
very good explanations, thank you
@xgerra162 ай бұрын
WE NEED THAT ADVANCED SQL COURSE KING!!
@vaibhavsrivastava95852 ай бұрын
Very well explained
@sakshamp448810 ай бұрын
bro loved your content as always ,i have oa next week ,wish me luck!
@user-ek4rp7fi9l3 ай бұрын
very clear explanation
@__nry8 ай бұрын
Thank you so much!
@andrecoetzer7032 Жыл бұрын
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
@vighneshjs200Ай бұрын
very much usefull ❤
@chaoukimachreki64228 ай бұрын
you are awesome beyond awesomness..
@katyaynisrivastava99614 ай бұрын
I don't usually write comments, I'm sleepy and my brain is working in 2 cells but I still got it. Great explanation.
@mohamedfaalil9 ай бұрын
this video is gem.
@jouGOETEАй бұрын
Well explained in an English accent I can understand. Thank you... (English isn't my first language, b.t.w.)
@maikhanhtruong92310 ай бұрын
thank you so much ^^
@imtiazshoykat3 күн бұрын
Thanks. This is so helpful though I still only know oracle Sql 😊
@nehashinde60174 ай бұрын
thank you!!!!!!!!!
@marylynkaka5733Ай бұрын
Awesome!
@just_a_viewer528 күн бұрын
thank you bro
@Joeysz Жыл бұрын
We need an advanced SQL course!
@KvintKek8 ай бұрын
Super helpful !!! Save and like ))
@user-pf8jj1uu1f11 күн бұрын
thanks
@teslavlogs8568 Жыл бұрын
I love colt’s lectures and videos. ❤. Can i join your bootcamp in San Francisco
@ShreyashBohara5 ай бұрын
Can you also make a video for lead/lag? This was a great explanation
@hussainnagaria24435 ай бұрын
Hi Colt! What is the setup you are using? (VSCode + ?)
@danieldweebler3392 Жыл бұрын
When will the new/updated sql course out???
@keysbythenumbers Жыл бұрын
Hey Colt, I saw one of your SQL courses on Udemy. Can I install MySQL on my MBP?
@hintsoftware11 ай бұрын
Can we use where clause or any kind of filters in any way for each windows function seperately ? We are unable to fully utilize window function without where clauses... or any trick to do so in sql server ?
@arimorrison78165 ай бұрын
helpful
@DucaTech Жыл бұрын
Does this work any sql database or only MySQL? I use MS SQL, Postgres, and Oracle at work. I notice that there's certain functions that are only applicable to Postgres, and vice versa.