I have been learning SQL from quite a long time and have been working on and off using SQL, but this is the first time ever I have felt this confident in answering certain SQL questions and solving certain advanced queries. Must say this is one of the best but underrated SQL playlist. Thank you so much for this playlist, also if you can please make some videos on lead() and lag() and the group by extensions, that would be super helpful.
There are very less playlist that I complete from start to end and I must say this is one of those, Loved the content level and the way you describe examples and that to from basic I started this playlist for my revision perspective but got to know new methods and ways to write those query and the specially the Rank and Row_number methods are bit confusing but you did a great job, Who so ever is starting this playlist just go for it, If a begineer within a week you can complete this and if for revision in 3 days... but also do handson, again Thank you Sumit sir for this valulable playlist.
This is my first course or series I can say which I've completed in my life because everytime I start something and end up feeling bored but this was amazing series having pool of knowledge into it. Thank you to Sumit sir and his team for bringing this much amazing series on UA-cam for free. Also I would recommend everyone to go for this series and believe me this guy has god gifted teaching skills which will fall in love with SQL.
I was always confused with joins , group by and having clauses in my college days but your explainations has removed my confusions now i am feeling confident in mastering sql. Thankyou Sumit Sir👌. Please contd with this series, its a masterpiece on youtube please cover some more topics like stored procedures & functions.
I've completed the whole playlist. Before this one I checked out many courses on SQL but they do not teach like you did. This is amazing. The best part is you've covered how questions can come in interviews.
Thanks for all the SQL videos, your examples are very good. I've recommended your videos to 7 of my friends already. I finally cleared my confusion over Row_Number and the Rank functions. .
his is my first course or series I can say which I've completed in my life because everytime I start something and end up feeling bored but this was amazing series having pool of knowledge into it. Thank you to Sumit sir and his team for bringing this much amazing series on UA-cam for free.
Nice lessons. Well put for beginners and nice refresher for the experienced. Suggestions: Please revisit select distinct with order by video. That definitely needs to be redone as it is not clearly explained. Also, in this video instead of 3 sql queries showing 3 different outputs, it could be clubbed as different columns for even easier understanding. Thank you!
@@LEVI-hv8dw depends on where you apply.. And after learning this skill you need to show your skill using some projects on this topic.. Project is a must
Hi Sir, why did you stop uploading the SQL videos. These are quit useful and interesting. Please continue this SQL playlist. Thankyou very much for your content
Thank you sir for making this video! I was not understanding the concept of row_number() but you made so clear that even I got to know about ranks and dense ranks. Have a great day sir! :)
Thank you so much Sumit, for this sql series...It was super useful for me to understand the concepts clearly. Please don't stop this and upload much more concept videos frequently.💫
Great learning through your SQL playlist. Approach is Very simple and with lots of practical examples but I made a mistake I thought I would get a link of your whole SQL playlist notes in the last video description and I continued watching it without making any notes and now when I completed it. I got to know that there is no such link its my bad. It its possible for you would you please share your notes link here. THANKS IN ADVANCE.
Hello Sumit Sir! I want to be a master in SQL if you have any paid courses for it please suggest me because these 16 lectures are the best lectures on youtube and also the best explanation of SQL. Thankyou sir.
sir ap sad mat ho ke baar pure playlist banake to deko app bhohat acah padhate ho ap bohat age javo ge par app kam suru karke katam to karo sir i depanded on you ples requst for starting atutorial \
recommendations: who cares about loading the data, the data doesn't matter, don't show it; use a proper IDE; no scrolling. You should be able to fit everything in one screen. You can comment out your notes in mysql workbench, show the complete query, and show the results below the query all in one screen. Otherwise great and thanks.
There is nothing new in it. Why so much of hype... This topic is already explained beautifully three years ago by kudvenkat. You can check the sql by kudvenkat He is the champ in SQL.
Well to answer your question ..this video is a part of SQL tutorial series and the word "tutorial" is meant to indicate that it is for people who don't know about what is being discussed in videos , I hope this answers your "nothing new part" as it was "new" for me before I watched this video. Now to answer your "why so much hype" part ..I would like to ask you who is creating a hype here ? do you see the creator of this video claiming this to be the best tutorial on UA-cam ? Most of the people who come here to see Sumit's videos is because we like the way he teaches and also because of his reputation from other courses that he offers. Venkat may be a champ but I simply don't relate with the way he teaches.
@@kiranshah177 Great reply !! I am sorry I assumed that you may be a well educated professional but the choice of your language has made it very clear to me that there is no sense in indulging with you in a discussion.
Sir I am interested in learning the course however I have a concern, I am in manufacturing company I can't leave my present job. Will this skill will help me in extra earning
Hi Sir, why did you stop uploading the SQL videos. These are quit useful and interesting. Please continue this SQL playlist. Thankyou very much for your content
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql16
I have been learning SQL from quite a long time and have been working on and off using SQL, but this is the first time ever I have felt this confident in answering certain SQL questions and solving certain advanced queries. Must say this is one of the best but underrated SQL playlist. Thank you so much for this playlist, also if you can please make some videos on lead() and lag() and the group by extensions, that would be super helpful.
I was Scared of ROW_NUMBER (), RANK() and DENSE_RANK(). After watching this video I can't never forget these functions. Thank you sir
Good to hear that you could understand the concepts easily.
Yes sir me too, Thank you so much 😊
There are very less playlist that I complete from start to end and I must say this is one of those, Loved the content level and the way you describe examples and that to from basic I started this playlist for my revision perspective but got to know new methods and ways to write those query and the specially the Rank and Row_number methods are bit confusing but you did a great job, Who so ever is starting this playlist just go for it, If a begineer within a week you can complete this and if for revision in 3 days... but also do handson, again Thank you Sumit sir for this valulable playlist.
If professor have taught in this fashion, it could have saved a few years.
Thank you Sumit Sir ❤️
This is my first course or series I can say which I've completed in my life because everytime I start something and end up feeling bored but this was amazing series having pool of knowledge into it. Thank you to Sumit sir and his team for bringing this much amazing series on UA-cam for free.
Also I would recommend everyone to go for this series and believe me this guy has god gifted teaching skills which will fall in love with SQL.
I can completely relate to this even i also watched the entire playlist 😅
I was always confused with joins , group by and having clauses in my college days but your explainations has removed my confusions now i am feeling confident in mastering sql.
Thankyou Sumit Sir👌.
Please contd with this series, its a masterpiece on youtube please cover some more topics like stored procedures & functions.
I've completed the whole playlist. Before this one I checked out many courses on SQL but they do not teach like you did. This is amazing. The best part is you've covered how questions can come in interviews.
thank you very much got such motivating words
Sumit Sir, you are a saviour! I haven't seen anyone teaching SQL concepts so clearly with apt examples. Thankyou so much!
sir u explain very nicely. I always use to get confuse among these window functions concepts. Thankyou sir for clearing all doubts
Thanks for all the SQL videos, your examples are very good. I've recommended your videos to 7 of my friends already. I finally cleared my confusion over Row_Number and the Rank functions. .
I finished this series .... very good way of teaching
Someone please give award for the "BEST PROFESSOR" to this man. THANK YOU SUMIT SIR!
his is my first course or series I can say which I've completed in my life because everytime I start something and end up feeling bored but this was amazing series having pool of knowledge into it. Thank you to Sumit sir and his team for bringing this much amazing series on UA-cam for free.
Is this SQL series enough to learn full concept of SQL?
cant be thankful enough for this series
finished watching all 16/16 in a single go. practice is next.
Nice lessons. Well put for beginners and nice refresher for the experienced.
Suggestions:
Please revisit select distinct with order by video. That definitely needs to be redone as it is not clearly explained.
Also, in this video instead of 3 sql queries showing 3 different outputs, it could be clubbed as different columns for even easier understanding.
Thank you!
too much hardwork really thank you so much sir.
Thank you Sumit Sir for this wonderful playlist. You have amazing teaching style. I revised all concepts in 5hr in one sitting. It's amazing 😍
24-Aug-2022 ended this playlist and waiting for more videos @Trendytech Insights. Very helpful videos.
Thank you very much for giving good knowledge in SQL.
Undoubtedly the bestest SQL tutorial ... even better than every paid courses... I'm thankful to you from the bottom of my heart core...
Is the SQL sessions over.......was this the final chapter in SQL?
@@LEVI-hv8dw it has covered almost 90% of the sql topics, you can clear maang level interviews with this
@@dkkashyap6494 and what about cte ?
@@LEVI-hv8dw depends on where you apply.. And after learning this skill you need to show your skill using some projects on this topic.. Project is a must
@@dkkashyap6494 what kind of project i need to work on and how to improve my query writing skills......any tips for that?
Not the hero we expected but the one we needed
Best teacher got in my entire life
Means a lot. Thank you so much
Hi Sir, why did you stop uploading the SQL videos. These are quit useful and interesting. Please continue this SQL playlist. Thankyou very much for your content
Will upload soon
@@sumitmittal07 thank you very much
@@sumitmittal07 sir still waiting for further concepts
@@sumitmittal07?? Fastt
Thanks sir very good explanation
Thank you so much, Sir. Best Explanation.
Ever best trained by any other thanks
Thank you so much Sir. Awesome Session.
Always welcome. Keep watching the space for more :)
Thank you sir for making this video! I was not understanding the concept of row_number() but you made so clear that even I got to know about ranks and dense ranks. Have a great day sir! :)
Great Explanation. 🎊
very good explanation
Thank you so much sir for great video ! ✅
Keep watching. I am happy that you are liking the videos.
Is it over or more videos to come?
Thank you so much Sumit, for this sql series...It was super useful for me to understand the concepts clearly. Please don't stop this and upload much more concept videos frequently.💫
Hey is this a full course of SQL please reply
@@rupaliminati8356 Not really.... but it covers all the important concepts which we must know in data field
@@dudetastic4521 hey can yoilu suggest any youtube course to learn SQL for placments , thank you
@@rupaliminati8356 This SQL playlist is enough for interviews and for practicing problem solving.
great explaination sir thanks
SQL is my favorite lang 💯✨
Sir Your all SQL session help me lot. Can I get notes which used for explaining SQL.
Great video how many videos remaining in this series?
Yep How many more videos remaining sir ??
Great learning through your SQL playlist. Approach is Very simple and with lots of practical examples but I made a mistake I thought I would get a link of your whole SQL playlist notes in the last video description and I continued watching it without making any notes and now when I completed it. I got to know that there is no such link its my bad.
It its possible for you would you please share your notes link here.
THANKS IN ADVANCE.
did u get?
Great video SIr!
Hello Sumit sir.Please post videos about Normalization forms.
Thnkuu so much sir for this sql series ✨✨✨
Sir, please do snowflake course videos..
Hello Sumit Sir!
I want to be a master in SQL
if you have any paid courses for it please suggest me because these 16 lectures are the best lectures on youtube and also the best explanation of SQL.
Thankyou sir.
Hi Atul i also want to learn the advance topic by paid course , do you want to share paid course ? half half
@@ishukumar2041 definitely if I find any course I will suggest you.
@@atulnagar1841 Thanks Atul
@@atulnagar1841 Brother you can learn advance topics in techTFQ channel. He teaches well.
@@SanthoshKumar-fw4dz thanks bro
Please continue SQL playlist
Sir please continue this series with complete sql.
sir ap sad mat ho ke baar pure playlist banake to deko app bhohat acah padhate ho ap bohat age javo ge par app kam suru karke katam to karo sir i depanded on you ples requst for starting atutorial
\
hi sir,
pls continue this sql topics
Please continue this SQL Series sir
are these topics required to be studied- stored procedures, views, triggers, index, CTEs, ?
Triggers, Views, Window Functions, CTEs, Indexes are important.
Hello sir , thank you for this wonderful session . Is this sql playlist the complete course ???
Thank you very much
Did you have any plsql sessions video based on your scenario .
Could you please share the notes so that it will be useful for us
Great videos, liked the way it was explained 👍
It's almost 2 weeks, no new topic Waiting for more videos
Thank you so much 😀 Keep watching
Hloo Sumit sir, please do one video on how to convert rows to columns
Hi Sumit sir, please make a video on lead() and lag()
sir when come next tutorial
the dense rank does the job of finding nth sal or any other similar query so what is the need of rank then??
recommendations: who cares about loading the data, the data doesn't matter, don't show it; use a proper IDE; no scrolling. You should be able to fit everything in one screen. You can comment out your notes in mysql workbench, show the complete query, and show the results below the query all in one screen. Otherwise great and thanks.
These videos are also meant for the larger audience who are just getting started with SQL. Thanks for the feedback!
Yeh series mein total kitna video or upload hona bakee hain??
row number is not working in goorm ide
Sir is this playlist complete or not? Are you planing to complete this playlist or not?
can't we use only partition by inside over() ?
kindly, provide that pdf / txt file, where you have written all things
Pleas upload more videos
Is there a github repo where i can find these sessions?
Not as of now.
@@sumitmittal07 please try and add one if possible. Will be helpful for quick lookups.
There is nothing new in it. Why so much of hype...
This topic is already explained beautifully three years ago by kudvenkat.
You can check the sql by kudvenkat
He is the champ in SQL.
Well to answer your question ..this video is a part of SQL tutorial series and the word "tutorial" is meant to indicate that it is for people who don't know about what is being discussed in videos , I hope this answers your "nothing new part" as it was "new" for me before I watched this video. Now to answer your "why so much hype" part ..I would like to ask you who is creating a hype here ? do you see the creator of this video claiming this to be the best tutorial on UA-cam ? Most of the people who come here to see Sumit's videos is because we like the way he teaches and also because of his reputation from other courses that he offers. Venkat may be a champ but I simply don't relate with the way he teaches.
@@dudechany only chamcha can reply in this way 😌
@@kiranshah177 Great reply !! I am sorry I assumed that you may be a well educated professional but the choice of your language has made it very clear to me that there is no sense in indulging with you in a discussion.
When are the new videos coming on SQL ??
Is the course completed with this Video @sumit sir
Please upload more videos sir. I beg you😭 I belong from very poor family and can't afford paid courses😭
Sir I am interested in learning the course however I have a concern, I am in manufacturing company I can't leave my present job. Will this skill will help me in extra earning
Yes, this skill will help you to fetch various reports from the database where all your manufacturing data is stored.
sir new video kab ayegi
coming tuesday se...
@@sumitmittal07 sir please upload new videos
@@sumitmittal07 pls share the notes.
Pls pls pls share the notes.
Waiting for next video sir ???
Coming up soon
sir intaha ho gaye intaza ke
after this video, SQL is completed?
Please someone answer my question, sumith sir
Sir where is the notes of the above videos?
sir intaha ho gaye intaza ke
CREATE TABLE employee (
firstname varchar(20),
lastname varchar(20),
age int,
salary int,
location varchar(20)
);
INSERT INTO employee VALUES ('sachin', 'sharma', 28, 10000, 'bangalore');
INSERT INTO employee VALUES ('shane', 'warne', 30, 20000, 'bangalore');
INSERT INTO employee VALUES ('rohit', 'sharma', 32, 30000, 'hyderabad');
INSERT INTO employee VALUES ('shikhar', 'dhawan', 32, 25000, 'hyderabad');
INSERT INTO employee VALUES ('rahul', 'dravid', 31, 20000, 'bangalore');
INSERT INTO employee VALUES ('saurabh', 'ganguly', 32, 15000, 'pune');
INSERT INTO employee VALUES ('kapil', 'dev',34, 10000, 'pune');
Hi Sir, why did you stop uploading the SQL videos. These are quit useful and interesting. Please continue this SQL playlist. Thankyou very much for your content