It's been 7 years and still, this tutorial series is far better than every other material on SQL :) Hands Down, Thanks a lot!
@mostafatarek50885 жыл бұрын
give this guy a medal
@RohitKumar-qo7pt3 жыл бұрын
why ?
@IamDanish99 Жыл бұрын
@@RohitKumar-qo7pt Because of the clarity in his presentation, the lucid way of explaining such concepts. He deserves to get a medal.
@shazibnomair7010 Жыл бұрын
Seriously.
@krzysztofs85357 жыл бұрын
Best tutorial available on the net . Thank you for your hard job . You are the best teacher on the planet. The way of teaching is just superb! Greetings from Poland !
@7aydarah Жыл бұрын
After 20 years as software developer, it's the fist time that I pay attention to the adventage of window function, I'v been using the subqueries to get this kind of results, but with a very low performance in execution time.
@alekzhdo7 жыл бұрын
This is gold! I have been struggling to understand Window functions and syntax and your explanation makes it all clear now.
@venkatashasidharreddychali7485 Жыл бұрын
Hello Venkat gaaru, great work . Just to add on for the default value of ROWS or RANGE values in OVER() Clause, which varies based on ORDER BY clause --The default value of ROWS or RANGE clause is "RANGE BETWEEN UNBOUNDED PRECEEDING AND CURRENT ROW" If the ORDER BY clause is specified --The default value of ROWS or RANGE clause is "ROWS BETWEEN UNBOUNDED PRECEEDING AND UNBOUNDED FOLLOWING" If the ORDER BY clause is not specified i.e the entire window. Please correct me, if anything is wrong. Kudos to your work and Thank you🙏.
@AW-ld7uk7 жыл бұрын
You're a natural born teacher. You're doing what you were born to do. Keep up the good work!
@danieladetayo371111 ай бұрын
This is the best tutorial on windows functions on youtube. Thank you so much for this.
@frenkyb1235 жыл бұрын
if you use just this: AVG(Salary) OVER() - then whole set is used for computing average. But as soon you put order by into OVER, default value for ROWS and RANGE are taken into calculation. I would expect that just using ORDER BY should not affect calculation of AVG, but it does - it completely changes result set on which calculation is made.
@saurabhdsawant5 жыл бұрын
would test , thanks for letting us know
@mermaidviv45173 жыл бұрын
Yes, AVG(Salary) OVER () seems to have the same result
@meghasyam4273 жыл бұрын
Nice tip
@AhmadAbdallah03954 жыл бұрын
I don't know what to say to you. Thank you very much. You saved me a lot of time and I'm in the middle of exams, usually I would've spent a lot of time searching for an even 50% good tutorial, but your videos are 100% good and precise. Keep up the great work. I hope you do more topics.
@just39634 жыл бұрын
What an amazing teacher! Thank you so much for breaking down these concepts for us! :)
@Csharp-video-tutorialsBlogspot4 жыл бұрын
Hello Justin - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
@TheBaBaLand5 ай бұрын
Great video! Thanks a lot! One thing I would add is that instead of writing BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING statement, we could remove the ORDER BY entirely and just write: AVG(SALARY) OVER() as Average
@rohity2944 жыл бұрын
Freely available at this quality is incredible...god bless!
@RubCalBatАй бұрын
Amazing explanation. Thank you!
@BRelding928 жыл бұрын
Can't believe this doesn't have more views!
@harpreetkaur-yr7gn7 жыл бұрын
I was struggling to understand windows functions and you have explained it with so ease .Its just awesome.Please keep posting such videos.Thanks a lot :)
@MrBhardwaj03 Жыл бұрын
This video is exceptional, searched whole of the youtube and internet but no one explained so easily and clearly
@desisto007 Жыл бұрын
Your tutorials never disappoint! Thanks for sharing your knowledge!
@justinli199010278 жыл бұрын
this guy is so good at teaching.
@pardhasaradhik92344 жыл бұрын
thanks for all the parts in sql, i have no hope of learning before seeing your videos ,slowly learnt total course because of u , god may bless you with happy family
@sami35923 жыл бұрын
very very good and clear teaching.
@akashdahiya90002 жыл бұрын
The best video on Window functions so far! highly recommend!!
@ladhkay4 жыл бұрын
Hats off bro...easy to follow and well explained!
4 жыл бұрын
This is a really comprehensive tutorial! Thank you so much!
@Tarikffm798 жыл бұрын
Best Tutorial in KZfaq! I Love your detailed Videos! I hope you will start with Analysis (SSAS) one day! Thank you Venkat!
@hscsoft_tutorials8 ай бұрын
You are awssssssom, spent entire day yesterday. think will view kudvenkat tomorrow sunday. found solution withing 5 minute. GREAT
@meghasyam4273 жыл бұрын
Good attention to detail Thanks a lot
@shahdanyal75424 жыл бұрын
Words cannot translate the emotions . Only can say excellent presentation in clearing the concepts. Thank you from core of heart.
@MasterBetham7 жыл бұрын
You are a gem! Explained and demonstrated so well. Thank you very much good Sir!!
@margimehta96093 жыл бұрын
One of the best explanation of the concept of Windows function! I have referenced to lots of tutorials online, but this one really stands out to me :) Kudos gentleman!
@Fawad06 Жыл бұрын
this person is teaching better than paid courses...
@shashireddy2314 жыл бұрын
Venkat are too good. Unbelievably clear and simple.
@samuelatobatele58943 жыл бұрын
The best of the very best! Thank you very much. Greetings from Nigeria
@shivaprasadmpshivu18822 жыл бұрын
really a very detailed explanation.
@divyas56353 жыл бұрын
Great sir This video helps me lot thank u so much 🙏🙏
@cblucohigen82815 жыл бұрын
Wow this is my first comment I’ve ever left on KZfaq, you are an amazing teacher I wish I could be mentored by you. From South Africa
@jayashreejay29893 жыл бұрын
Worth watching
@b2theb7 жыл бұрын
Total hero.....I have 70-461 coming up and you've helped me no end!!!!!
@preyaaatri29434 жыл бұрын
Best video for understanding window functions.
@likithabh39443 жыл бұрын
you explained it so well, thankyooou
@ibrahims61635 жыл бұрын
EXELENT !!!!! it is the best for 10 minutes !!! Perfect
@hanansaleena3 жыл бұрын
Awesome explanation
@shubhamsaxena97897 жыл бұрын
WOW.....you are too good in explaining the things..cheers...
@NoobLahe6 жыл бұрын
video was straight forward and detailed, thank you for sharing your knowledge
@93gbz5 жыл бұрын
OMG Thanks for this absolutely amazing video
@balrajvirdee1087 Жыл бұрын
Great explanation 👍🏽
@pascalhauschildt8563 жыл бұрын
GREAT JOB!!!
@DB-sf1hy4 жыл бұрын
Great explanation
@onyu5813 Жыл бұрын
Thanks! very helpful content
@TheThodi7 жыл бұрын
keep it up! extremely well made tutorial! :)
@hotechmanager4 жыл бұрын
You are like a GOD for me....
@prvnkumar7 Жыл бұрын
Thank you Venkat Sir.
@balrajvirdee1087 Жыл бұрын
Thanks great video 👍🏽
@HygienicMaggot8 жыл бұрын
I'm reading Itzik Ben-Gan Fundamentals and joes2pro books but your videos really do give the best clarification on SQL topics. Subscribed and be checking the rest of your channel
@kakakukukakakuku7 жыл бұрын
Very helpful video, clearly and nicely explained . Thanks !
@Passrord5 жыл бұрын
you made it so clear and precise...thank you
@urspramila8 жыл бұрын
very well explained with simplicity. Great Work.
@operationbroomstick Жыл бұрын
Wow. Thanks brother ❤
@deepikakbify8 жыл бұрын
Thanks a lot for the videos. They are very well explained.
@imransaieen8 жыл бұрын
Simplicity of your explanation is remarkable. Keep it up.
@anmolpreetkaur7113 жыл бұрын
What an explanation! Thank you!
@mariyademirova55718 жыл бұрын
Great video! Thank you, it is much clearer now!
@sundeepyadav62349 жыл бұрын
Very detailed video.... Thank you :)
@vaishalib49384 жыл бұрын
very neat and to the point explanation !
@malvikachandhok85713 жыл бұрын
Thank you so much! Best tutorial!
@Sonny02767 жыл бұрын
Great Video. Thank you for posting.
@TheDhanoopjose8 жыл бұрын
Thanks for the video. It was really helpful
@Csharp-video-tutorialsBlogspot8 жыл бұрын
+Dhanup Thank you for the feedback. This means a lot. Very pleased you found these videos useful. Dot Net & SQL Server training videos to help you become a web developer kzfaq.infoplaylists?view=1&sort=dd Download videos for offline viewing www.pragimtech.com/Order.aspx Slides, Code Samples & Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our youtube channel kzfaq.info/get/bejne/r51oY7Cozb-bYKc.html To receive alerts, when new videos are uploaded, please subscribe to our channel kzfaq.info If you like these videos, please click on the THUMBS UP button below the video May I request you to please share the link with your friends who you think would also benefit from them To teach is to learn Thanks Venkat
@jamesabsalemlintu95176 жыл бұрын
Thank you so much and appreciate your work.
@santhoshgayakvad10136 жыл бұрын
To the point, very nice explanations . Thank you :)
@smtzac0027 жыл бұрын
Thank you. That was extremely clear
@ivywang32763 жыл бұрын
super helpful
@doreenshen36903 жыл бұрын
This is super helpful. Thanks!
@80amnesia3 жыл бұрын
Thank you Venkat
@HorrorTube13134 жыл бұрын
Can't thank you enough for these videos ! :)
@NightKingMarhoom3 жыл бұрын
Sir u r great
@harveybains1466 жыл бұрын
Great video, Many thanks
@parvathirajan.n3 жыл бұрын
Amazing ! No words !!!
@aayushisaxena57383 жыл бұрын
You are awesome!
@anekarvishal84776 жыл бұрын
Very good explanation
@5tarda8 жыл бұрын
Thanks man, apreciate your work you've done here :) helpfull, keep doing good work :)
@khaledrabah30013 жыл бұрын
5 star teacher
@haziqhumayun58786 жыл бұрын
Too good, thank you so much
@TheHimaBindu8 жыл бұрын
Very informative
@antoniosol98639 жыл бұрын
El Maestro returns
@mohammadal-aqrabawi71458 жыл бұрын
Excellent!!!
@f1r3shoot8 жыл бұрын
Отличное видео
@soniasadeque42487 жыл бұрын
great..
@romiltube7 жыл бұрын
Hi Venkat, first off I enjoy your videos a lot, very helpful for interviews. I have a question related to analytic window function (sum) Could you please confirm which version of MS SQL Server are you using? Not 2008 right? Because, I tried running below query in 2008 version which is quite similar to what you demonstrated in of your slides in above video and it threw syntax error. select *, sum(sales) over(order by sales) as sumofsales from test1......error select *, sum(sales) over() as sumofsales from test1.......no error it ran successfully select *, sum(sales) over(partition by dealer) as sumofsales from test1.......no error it ran successfully The reason why the first query failed makes sense to me, because I believe there is no need at all for a order by argument in analytic window function; partition by argument might be required sometimes though (my 3rd query) I got confused because your query (quite similar to mine, as per above logic it should have failed since it contained order by arguement in analytical window function you demonstrated) ran successfully... Seems like you are using a different SQL version than mine...Just curious to know why your query did not fail :) Thanks again for comprehensive, well articulated and ofcourse free videos :) Regards, Romil
@raqibulAlam-su3jo9 жыл бұрын
Thanks
@anshumanbupathi Жыл бұрын
venkat sir could u explain realtime queries in fucntions
@dengzhonghan51253 жыл бұрын
Good tutorial. Partition by Gender order by Salary. Why salary is not in ascending order?
@edwardbrown74696 жыл бұрын
Running average by accident, I love it!
@ssmahajan5 жыл бұрын
You are my Guru 🙏
@muhammadrehbarsheikh84989 жыл бұрын
Thanks sir!!
@monsterMonks3 жыл бұрын
Your voice sounds like Sadhguru
@orxanbabashov7 жыл бұрын
thanks so much
@kkjjjj32965 жыл бұрын
Ngubk
@cbdbee7075 жыл бұрын
Is there anyway to set the preceeding/following row clause programatically so that i can write one function that can output moving average of variable window width? (without using dynamic queries)
@ishanvallabhkamat42545 жыл бұрын
Why can't we directly use partition by instead of specifying Unbounded values? In video 108 this is achieved by Partitioning it right?
@UrBoyiVignesh4 жыл бұрын
i think we have to use ID column for Order By Clause to avoid duplicates.....
@questscape3 жыл бұрын
If we just use OVER() without specifying anything inside over then it is an equivalent to mentioning UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING.