I never thought I would understand window functions so fast and easily like this. Thank you a million times.
@techTFQ2 жыл бұрын
Glad this helped ☺️
@mukeshbarnwal2705 Жыл бұрын
turu
@cecille2341 Жыл бұрын
same
@thedataholics Жыл бұрын
@@techTFQ does the way of window clause not work in SQL SERVER as I am getting error while doing so?? Below is the query I am using @techtfq select distinct product_category, FIRST_VALUE(product_name) over w as most_expensive_product_in_each_category, FIRST_VALUE(price) over w as price_of_most_expensive_product, LAST_VALUE(product_name) over w as least_expensive_product_in_each_category, LAST_VALUE(price) over w as price_of_least_expensive_product from products window w as (partition by product_category order by price desc range between unbounded preceding and unbounded following)
@srikanthkallakuri16763 ай бұрын
@@techTFQ p0llo
@saranrajv32 жыл бұрын
I have searched Udemy and many youtube channels to understand the Window functions and finally this video shed the light for an excellent clarity , Once again kudos to Taufiq for an excellent content and clarification :)
@techTFQ2 жыл бұрын
Glad it helped!
@aperxmim3 жыл бұрын
This is about easy as it gets to understand, just need to practice so these techniques could stay inside my brain. Good Job, better than most college professor teachings.
@techTFQ3 жыл бұрын
Thank you so much 🙏🏼 Glad to know you found this helpful 🙂
@shubh_pokharkar8145Күн бұрын
I have started learning sql and i found this channel grateful to Taufiq for providing valuable content free of cost , i would also like to tell people trying to learn sql and complex concepts like window function watch videos of Data with Baraa he has beautifully explained each and every concept of SQL with visuals.
@amaalanoos8382 жыл бұрын
This is how a tutorial should be. Concise and clear explanation. Greate Job!
@uraniumu242 Жыл бұрын
I hav spent a lot of money on books a courses but you are the best teacher. I have learned things that were skimmed over elsewhere. Thank you!
@avikkarmakar2278 Жыл бұрын
The goto channel to learn SQL. As a non-tech person, I really appreciate the ease of learning and understanding the language
@tejaswi19952 жыл бұрын
In the context of "unbounded preceding and unbounded following", this was the only time I understood it. Thanks a lot
@techTFQ2 жыл бұрын
Happy to know that :)
@meghanaiitb2 жыл бұрын
Hello Thaufiq, I’m on my SQL learning journey and came across your channel, thank the KZbin algo lords. Previously, I used to refer to the documentation pages to learn SQL and would easily get lost in understanding nuances. Your succinct explanation on LAST_VALUE() default frame just saved me loads of time. Huge thanks. Subscribed.
@techTFQ2 жыл бұрын
Hi Meghana , It means a lot to receive such amazing feedback.. thank you 🙏🏼 I am so glad my content helped you ..
@sanjoysaha16972 жыл бұрын
I have explored so many courses on udemy and on other online platforms but yours is unparallel. Excellent explanation, easy to understand making it stand out from the crowd. You rock man. Thanks for sharing the videos.
@techTFQ2 жыл бұрын
Thank you Sanjoy. Appreciate the feedback
@deepikameher93439 ай бұрын
Best video ever found on KZbin!! I was scared of SQL queries for all interviews,after going through your videos I have got confidence and creaked interviews as well...Many many thanks to you...the way you explain is superb...Kudos to you !!
@gojosatoru8057 ай бұрын
What questions were asked ?
@samreenfathima6793 Жыл бұрын
I completed a course on advanced sql windows functions on linkdin and in 15 minutes of your video i understood more than i did in that entire course!! kudos to you. I cannot thank you enough !! really really appreciate !! need more tutors like you!!
@nomatusi7514 Жыл бұрын
nth_value is not working on my MS SQL. I copy the codes but still cannot work.
@gauravhawadiya69903 жыл бұрын
this is the first video on youtube i have seen so far that has 1000 likes and 0 dislike as on december 12th , 2021.... indeed a great video and great teacher......
@techTFQ3 жыл бұрын
Thank you Gaurav 🙏🏼 I had not notice it .. it’s so nice you did and mentioned it here .. I am glad you liked the content ☺️ Thanks again
@ATVhasist-w5w Жыл бұрын
TechTFQ = Deep Understanding + Great knowledge + Impressive teaching style.
@artisartisworld8629 Жыл бұрын
one of the best and easy explanations, even better than what we pay for most of the Udemy courses.
@himanshumittal126511 ай бұрын
@techTFQ - I have paid a hefty amount to an ed-tech company to learn SQL, but believe me when I say, this is far far better explanation then those nincompoops. Kudos to you!
@nabilakhtar1048 Жыл бұрын
I just started learning SQL and this tutorial saved me. outstanding. Keep going
@satyaece20072 жыл бұрын
Exceptionally articulated starting with every query and data set explanation and I can't believe it's so easy after hearing to your explanation and it's impressive. It's not easy to watch an hour of new concept continuously but your videos are exception. It's really interesting though I'm pretty new to these concepts. Thanks a lot for making these videos.
@techTFQ2 жыл бұрын
Very happy to read this feedback Satya .. I am very glad you liked it .. 🙏🏼🙏🏼☺️
@sairamuddanda58162 жыл бұрын
Mind blowing!! Never come across this much clearer explanation in entire world which you have done it. Thanks for this
@techTFQ2 жыл бұрын
Glad you liked it bro
@anduamlaktadesse92842 жыл бұрын
After now on, I can solve any complex problems using window functions . Big respect for you!
@pzuazu86362 жыл бұрын
You sir are a God send. My number 1 port of call when i need sql explained in plain English. On behalf of all your viewers here's a massive THANK YOU.
@mateuszsmendowski26772 жыл бұрын
Literally the best channel about SQL on KZbin :)
@techTFQ2 жыл бұрын
I am glad you think so ☺️ Thank you 🙏🏼
@achmadthoriq44123 жыл бұрын
i like how the way you explain window function so easily for beginner. Thanks
@techTFQ3 жыл бұрын
Thank you Thoriq 🙏🏼 Very happy to hear this
@davidgitau88252 жыл бұрын
One of the best video of windowing functions done! Keep it up.
@techTFQ2 жыл бұрын
Thanks a lot!
@salaiarunmanijb1742 жыл бұрын
THE BEST video for the window function
@ShubhashreeMunot Жыл бұрын
One of my favorite channel on you tube!! Quality content!!!!! Really Thankful to you for sharing this detailed knowledge on window function!
@gulaggang63393 жыл бұрын
Great video. Looking forward to more advanced sql content. Thanks for the quality content.
@techTFQ3 жыл бұрын
Thank you so much 🙏🏼 Truly appreciate your feedback. Yeah will cover other advanced SQL concepts ☺️
@saibalpatra01 Жыл бұрын
Both the tutorials of window function are gem of video. Really love the way you teach. Thank you so much
@niveditav691 Жыл бұрын
Undoubtedly you have the best video explaining window functions !!
@aebirim92102 жыл бұрын
This is an excellent video. This explains to me why my SQL queries have been delivering funny results. That bit about unbounded preceding and unbounded following is priceless!
@techTFQ2 жыл бұрын
Glad it was helpful!
@vikramarora6508 Жыл бұрын
I used to think , SQL is so dam tough but not anymore. You are just too good
@stevenpalm94842 жыл бұрын
You are a great instructor. Thanks for sharing.
@techTFQ2 жыл бұрын
Thank you once again Steven 🙏🏼
@vaibhavitatekar47004 ай бұрын
I love how you explained the frame clause. It's so easy to understand in your way. Thank you for that
@kebincui3 жыл бұрын
Explaination Crystal clear. Thanks for sharing
@techTFQ3 жыл бұрын
Your welcome 🙏🏼 Glad this helped
@monicanalawade31066 ай бұрын
Your way of exlanation is very simple. You are making SQL very simple and easy. Thank you for your efforts. You are just great.
@anjanaray15943 жыл бұрын
After going through numerous videos on sql and trying to find the best one to understand the concept I found this, truly a gem. quality content easy to understand simplified language is used. watching your videos continuously more than 2 hours. Thanks a lot. please do create projects on sql too after all the concepts.
@techTFQ3 жыл бұрын
Thanks a lot Anjana 🙏🏼🙏🏼 Amazing to receive such feedback .. I am so so glad you liked the video and have benefited from it.. Surely will be making some videos on SQL projects in the near future..
@aimanansarmomin4542 Жыл бұрын
Jazakallah khair.. i am learning sql by watching your videos thanks you are a best teacher.
@SidhantPatra5 ай бұрын
It was so clear and understandable. Thank you so much for such valuable topic🤗
@shreepadjoshi514211 ай бұрын
For the PERCENT RANK window function example, I believe this would answer the question - How expensive the phone is with regards to the most expensive product rather than how expensive the phone is compared to all the phones(As every phone will have a different price). Liked the content and examples. Thank you.
@dobijr790010 ай бұрын
pls can i get the codes for this particular video....thank you
@gaurav.dahiya21 күн бұрын
really patient guy with good knowledge on subject!
@mayurjoshi14522 жыл бұрын
your sql master guide for beginners. toufiq sir.
@SakshiPandey-y9h12 күн бұрын
wow ur teaching style is just what i needed thank you so much !!!!
@story_teller_Is Жыл бұрын
default frame k concept p youtube m v bht kam videos hn., but iss vdo m bht mast explanation k sath default frame v clear hogya.
@ektabangar40949 ай бұрын
This is the best video on Window function I have ever came across. Kudos to you!!
@MachellBeach Жыл бұрын
I watched both of your videos on window functions. You have a way of making something that seems complicated, 😂easy to learn. You’re a very good teacher. Thanks for your help.
@techTFQ Жыл бұрын
Great to hear
@sonicasinha Жыл бұрын
Now finally I am able to understand completely how and where to use window functions in such a easy way. Thanks a lot for an amazing tutorial !!
@lize.612211 ай бұрын
Many thanks for your invaluable contribution to the success of my SQL journey. You are such a lifesaver.
@bhargavpaluri68582 жыл бұрын
Explanation is too good.making every concept look easy.
@techTFQ2 жыл бұрын
Glad you liked it
@niralikatre22522 жыл бұрын
EXECELLENT EXPLAINATION.....VERY EASY TO UNDERSTAND..THANK YOU SO MUCH...GREAT EFFORTS....
@kuldeeppatil96807 ай бұрын
Thanks toufiq for thus great tutorial
@manic-uq9si Жыл бұрын
Excellent teaching sir TQ very much
@anujshah73502 жыл бұрын
your voice and way of teaching don't let anyone go away from the long video length as well. Keep up (y)
@ramagirinikhil738310 ай бұрын
"I am so thankful to you because your videos have made me more interested in learning SQL. I love the way you explain the topics using simple words."
@chiluverimadhankumar2005 Жыл бұрын
best explanation ever seen about window functions. keep rocking sir...
@SaifRehman-f5s Жыл бұрын
Excellent teaching... understood in one go ..
@Olashileayomi2 жыл бұрын
I'm so glad I stumbled upon your page. My queries skills have improved a lot watching your videos. Keep doing the good work Taofiq.
@rizf800 Жыл бұрын
most comprehensive and easy explanation of the most difficult query thank you so much❤❤❤
@swetagupta55392 жыл бұрын
Explanation was crystal clear. Thank you so much for sharing this video.
@techTFQ2 жыл бұрын
Thank you :)
@rishavraj38673 жыл бұрын
I watched several videos, your is the best
@techTFQ3 жыл бұрын
Thank you Rishav 🙏🏼 Glad you liked it ..
@TeamEnneser Жыл бұрын
Easy explanations. No self advertisement. Absolutely Professional. Good Work Mate
@beulahr57405 ай бұрын
very useful video. Thank you soooo very much sir
@ritikas3832 жыл бұрын
I am so grateful that I stumbled upon this channel. Thank you for making it all so easy !
@techTFQ2 жыл бұрын
You are so welcome! Glad it helped
@sandeepmandavilli45122 жыл бұрын
you are saving my interviews , thank you for these amazing videos
@techTFQ2 жыл бұрын
Your welcome buddy Glad this is helping
@karennguyen70832 жыл бұрын
Clear explanation. Look forward to watching your following videos. Thanks.
@techTFQ2 жыл бұрын
Awesome, thank you!
@wrenggorwagnac59482 жыл бұрын
My good sir, I've been binge watching your videos. Got my Google Analytics diploma and I need as much practical knowledge and practice as I can get my hands on. THANK VERY MUCH for these videos.
@niteshkumar28742 жыл бұрын
It's is very tough for understand window function but when I landed here ..finally fear of window function gone ..thanku for videos.
@linnynguyen9 ай бұрын
this video is better than any other one in the same topic. Million thanks!
@gowthaman32642 жыл бұрын
Thanks For the video, anyone can learn SQL if you teach ...Please post more videos...
@techTFQ2 жыл бұрын
Thank you very much ☺️
@mullaipugazhendi3236 Жыл бұрын
WORLD BEST TUTOR.
@sagnikchakraborti24159 ай бұрын
Your way of explanations through queries makes every concept interesting and inspires to learn more.
@LalithammaBestavaripeta Жыл бұрын
All the window functions are very easy to understand. Thanks for explaining very clearly.
@swatisinha32303 жыл бұрын
Thank you for such a fine effort . Explained everything in detail :)
@techTFQ3 жыл бұрын
Thanks a lot Swati 🙏🏼 Happy to know this helped ..
@sidhantbourney48383 жыл бұрын
Best video on window functions that I've ever seen. Keep up the good work!!
@techTFQ3 жыл бұрын
Thank you Sidhant 🙏🏼 Appreciate the feedback ☺️
@DeltaDem7 ай бұрын
The explanation is simple and upto the point. I am glad I found this channel. Btw that slap sound is quite funny during intro to new functions. 😂
@IrakliChitishvili3 жыл бұрын
Great video series, good job! For added bonus - new chapter title intros sound like a slap haha :D. definitely subscribing.
@techTFQ3 жыл бұрын
Haha dint realize it sounds like a slap .. Still figuring out how to make the video quality better .. But thanks for liking the content 🙏🏼👍
@jeffreystine46382 ай бұрын
3 yers later and still relevant great job
@subha18182 жыл бұрын
Fantastic stuff. Better than paid courses. Thanks man.
@SantanuRoy-oq2nv Жыл бұрын
Outstanding Sir. Thank you for your both Windows functions videos..
@nagarajshenoy48485 ай бұрын
Unbounded preceding was a tricky one.. Loved the way you explained..
@alkaaswar17802 жыл бұрын
You are such a great person who are providing this all the helpful knowledge freely Thank you so much
@vishalnasre12512 жыл бұрын
wonderful video with a very detailed explanation. thank you
@techTFQ2 жыл бұрын
Glad you liked it 🙏🏼☺️
@archanachaube70272 жыл бұрын
Best SQL tutorials!
@techTFQ2 жыл бұрын
thank you Archana
@sampathkumar76333 жыл бұрын
Wonderful explanation.You have great teaching skills
@techTFQ3 жыл бұрын
Thank you so much for the appreciation 🙏🏼 Glad you liked it ..
@VinayKumar-ij4eu3 жыл бұрын
Able to understand each window formula within 2 videos using OVER clause...Thanks brother for such an informative video!!! Keep it up!!
@techTFQ3 жыл бұрын
Your welcome vinay 🙏🏼 Happy to know this helped
@teslaocean9949 Жыл бұрын
best video on window functions!! thank uu brother ...
@gowthamsagarkurapati93882 жыл бұрын
The concepts are very clear, Thank you for explaining!
@techTFQ2 жыл бұрын
Glad to hear that ☺️
@ayyappansri6 ай бұрын
Excellent explanation. Hats off 🎩
@odelolatechup14472 жыл бұрын
God bless you... I appreciate all your awesome videos
@techTFQ2 жыл бұрын
Thank you bro .. glad to hear that ☺️
@md.jannatultasnim26612 жыл бұрын
you are a great mentor . At first these things were very confusing for me but now i am confident enough to use them. Thank you
@oluomaIlobah3 ай бұрын
You are such an amazing teacher. Thank you so much.
@umesh660011 ай бұрын
best SQL channel
@lenzamoya62975 ай бұрын
This was awesome,you made window functions lesson easy for me.
@madhusmitatripathy87672 жыл бұрын
kudos to your presentation. Very clear ..loved this..
@techTFQ2 жыл бұрын
Thank you 🙏🏼 Glad you liked it
@pankajroy.42 жыл бұрын
Got it! After watching twice 😉♥️
@techTFQ2 жыл бұрын
Awesome Roy 👌
@nikolaybaranov22132 жыл бұрын
Good lesson about window functions. Thank you!
@aryamohit64962 жыл бұрын
you explained things in very simplified way, Thanks My search for advanced topics for sql stopped here.
@vamsinvizag49362 жыл бұрын
Extraordinary explanation and content. Thanks a lot!
@SarikaV-j7v3 ай бұрын
Thanks a ton..very very easily understanding video... requesting many more
@VishalAndhale-j1u Жыл бұрын
The way you explain the things makes it very easy to understand the functions. Thanks alot.
@techTFQ Жыл бұрын
You're welcome
@anikethdeshpande833610 ай бұрын
explanation of the frame was just amazing! thank you so much !!