I really want to say, i have heard from most of them saying that SQL is easy, but many TH-camr videos, made me feel otherwise, untill i came across your video. Most recommended channel for SQL.
Dear Rishabh sir, I have completed your SQL course and it really helped me .. Thanks for sharing knowledge in easy manner on free platform.... God bless you..!!!
This lecture covers the basic of SQL to the advance SQL. I have not learn that much when I was doing my BTECH in six months in compare to what I have learned in 3-4 days. Fantastic list, easy to understand, and easy to learn. the rest of the thing is on us, and we have to practice and revise. Thank you Rishabh, One request if you can upload videos on AWS or PowerBI like this, it will be wonderful, keep teaching
Thank you Sir! The whole series was really helpful and easy to understand. Keep uploading new skills so that we can learn from you. Your way of teaching is very good.
Easy explanations, where were you from last months? I was trying to find some good resources for DB, finally got your videos really useful. Keep going, I'll recommend your videos to my friends.
Just finished the whole series and it was so well structured and explained. Thanks Rishabh for making SQL looks easy and interesting. Would you be making more videos on advanced SQL?
Hi Rishabh Bhai, I really love your videos. Please Could you also make a separate Video on Views, Procedures and Trigger Functions? That would really help us. Thanks in Advance Bhai.
Everyone says SQL is soo much easy than Python, but now learning it by myself, i feels like that Python is more easy than SQL though it's my personal experience, i don't know why but i found myself to grasp Python syntaxes quite easily, maybe because I learned Python for 2 years i guess!
learning specific topic with example is easy to understand but when it comes to real life application and where to use it becomes bit difficult. Anyways Great content @RishabhMishra with clear cut explanation.
Good evening Rishabh bhai, your sql series is awesome and also your Example is very helpful or easy for everyone who want to learn, bhaiya I have a question, I want to ask that after learning sql what can I learn in either power bi tool or python? Plz reply for this query 😊😊😊
Yes after sql you can learn any of these excel, power bi n python. For detailed information n free resources you can watch my video on the - data analyst roadmap
Hii Rishab bhaiya, I hope you will be happy and healthy🙏, bhaiya I want to know, can I get a data analyst job based on Excel, SQL or Power BI without python ?
Rishabh sir, you did not show 'country' table data, we don't know what data were in "country' table, but whole contents are so good, can't express in words, Thanks
Hi Rishabh, learning from you always great experience, here I am having error as "Column 'Customer_ID' was specified multiple times for my_cte" Please provide your solution, thanks in advance
Can you please make videos on tableu and python just the same way as you made videos for sql. I really loved it and appreciate your quality content crisp videos.
Thanku so much sir.Mne ye puri playlist ki .Aap kaafi easy way mai samjate ho.Sir Advance SQL par Videos bana aur uske interview question par bi.Uske baad par Java in One Video aur Web Devlopment in one video bana do.Sir kam time mai aap bahut sikha dete ho.Plz Sir inn par bana do.Aapki vhje se jin students par time kam hota hai vo jaldi se new chije sikh lenge aur unka time bach jayega.Thanku So Much Sir Again.
SIR pls make videos on some other functions of SQL which helps to generate the random data especially for bank ,it will help to create the project related to bank generating random data
Hi @Rishab, thanks for explaining it in a simple way. I am facing an issue while trying to run the first CTE query (Video Time 11:20). MySQL has given an error: "Error Code: 1060. Duplicate column name 'Customer_ID'." How to resolve this ? I will share the screenshot to you over LinkedIn
Thank you for the clear and concise explanation, Rishabh. I wish you the best. Could you please create a Python playlist? It would be greatly appreciated and very useful.
After seeing all these comments 😒 Why can’t you explain in English bro ? It will be very useful for many of the job seekers and students from south India and it’s definitely gonna increase your viewers and subscribers as well 💯
sir please if possible make another video on CTE topic .there are still some confusion in it . can u explain it with some scenario based questions .like where we can use it and how it is different from windows functions etc.
Hi Sir, I have watched the whole playlist and I'm currently practicing. I find this video a little incomplete or difficult to understand. I would be grateful if you can make a detail video of this concept CTE.
@9:21 Hi, first of all thnx for this wonderful SQL course. I've a doubt in CTE example-Advance section... Doubt: "my.highest_price, my.total_price" or baad mein jo "join my_cte my" isme ye my kaha se aaya... my koi table ka naam h ????
5:10 Rishab bhai jab main select first_name, last_name From my_cte Kar raha hu tab syntax error araha hae how i should solve it? The output message is relation "my_cte" Doesn't exists.
Hi sir, I have learnt SQL and I have better knowledge of advance excel. Currently I m learning python...could you please tell me from where I get projects for mentioning in resume.
You have not shared nor mentioned about certain tables you have used in this video and the last few videos; they are not even available in your github link as well, I checked many times. From this video, the address table and country table are not available. And from previous videos, test_data table, custA table, custB table, emp table. Please recheck this and provide the tables. I am getting an error every time after running the same query as you.
Dear Sir, I am trying for FIFO Stock Valuation as follows using your taught methods like cte and window functions. but not getting done so far. If possible please help us solving this below case solved in a separate video which can be very fast even for lacs of records. Input Table: DocNo Date InnQty InnRate OutQty OutRate 1 12/02 12 12.50 2 12/03 13 ? 20 12/04 50 10.20 10 12/10 100 11.25 11 12/25 25 ? 14 12/29 150 ? We need to populate the data according to FIFO method as following:
for 1st OutQty(13 Pcs)=12 Pcs @12.50+1Pcs*10.20=160.20/13=13 Pcs@12.32
for 2nd OutQty(25 Pcs)=25 Pcs @ 10.20 (Because 2nd InnQty has still sufficient Left(50-1-25)=24Pcs for next outqty)
for 3rd OutQty(150 Pcs)=24 Pcs @10.20+100Pcs*11.25+26 Pcs*11.25 (From Last InnQty as there is no more InnQty left) =1662.30/150=150Pcs@11.08
Output Query by CTE, Running Total and window functions Approach: DocNo Date InnQty InnRate OutQty OutRate 1 12/02 12 12.50 2 12/03 13 12.32 20 12/04 50 10.20 10 12/10 100 11.25 11 12/25 25 10.20 14 12/29 150 11.08
I really want to say, i have heard from most of them saying that SQL is easy, but many TH-camr videos, made me feel otherwise, untill i came across your video.
Most recommended channel for SQL.
Glad it was helpful ✅️
Soon will start tutorial for Python as well so stay tuned 🚀
Dear Rishabh sir, I have completed your SQL course and it really helped me .. Thanks for sharing knowledge in easy manner on free platform.... God bless you..!!!
Glad you liked ✅️
Bro can you solve this question. Retrive the two maximum and minimum salary from table.
PLEASE KEEP POSTING SUCH QUALITY CONTENT.. Thank You so much!
Glad you liked it ✨️
@@RishabhMishraOfficialsir my cte command is not working...it is showing " syntax error at the end of input"
bro how avg_price values are calculated ?
how 280 and 270 comes
Great teaching
last 2 din se maien itne saare videos dekhe, nahi samjh aa raha tha..finally samajh aaya isse..thanks for this video.
Glad you liked ✅️
RIshab, Just awesome, very specific topic was discussed in a very simple manner. Love you man..
This lecture covers the basic of SQL to the advance SQL. I have not learn that much when I was doing my BTECH in six months in compare to what I have learned in 3-4 days. Fantastic list, easy to understand, and easy to learn. the rest of the thing is on us, and we have to practice and revise. Thank you Rishabh, One request if you can upload videos on AWS or PowerBI like this, it will be wonderful, keep teaching
Glad it was helpful ✅️ n power bi videos are already uploaded
This topic is less covered by other instructors. tysm!
Glad it was helpful! ✅️
Super content with a simpliest way of explanation worth than paid content ...... thanks a lot......
Glad it was helpful ✅️
A complex topic explain in very simple way , its amazing😍
Glad you liked it ✅️
Thank you so much for the explanation ❤. Hindi mein itna accha samjhhaane ke liye bahut bahut aabhar.
Glad it's helpful ✅️
you are genius, you cleared all my doubts ,I watched all your videos and my all doubts got cleared.
Glad it helped you! 🚀
Thank you so much for the series. You made learning very very easy . World needs more people like you :) Love from Pune
Glad you liked it ✅️
Best playlist for SQL I have ever come across, thank you.
Glad you like it! 👍
@@RishabhMishraOfficial bro you have not shared country table...
Thank you brother for helping us to understand clear everything about SQL and especially CTE, WINDOWS functions
Glad you found it helpful ✅️
Thank you. This series is so helpful.. Thank you very much...😇😇
Glad you liked it ✅️
Really appreciate it
Your explanations are really gud🙏keep posting such content
Thanks boss
Excellent, A big thank you Rishabh
Glad you liked it ✅️
thank you so much Rishabh sir, your vidoes are really really helpfull! 🤗
Glad it was helpful ✅️
Sir , you are doing great....and please Make detailed videos on CTE and windows function..
Bro your explanation very simple so all video as it's captured and store in brain 😅
Glad it's helpful ✅️
Thank you Sir! The whole series was really helpful and easy to understand. Keep uploading new skills so that we can learn from you. Your way of teaching is very good.
Glad you liked ✅️
Content is good and easy to understand
Glad you liked ✅️
Great explanation bhaiya 🙏🙏
Great explanation 👌 thank you bhaiya 🙏
most welcome, glad you liked it :)
Excellent , Your explanations are really fantastic .
Glad you liked it ✨️
Please keep posting bhaiya its really helpful ❤❤
Glad it was helpful ✅️
Thank you for this tutorial 🎉.
Really appreciate it.
your explanation are really good 👍🏻🙏🏻
Thank you Rishabh for this amazing concept, please keep creating such contents and help us achieve our goal!
Glad you liked ✅️
Very helpful support from you Rishabh bhai 🙏
Easy explanations, where were you from last months? I was trying to find some good resources for DB, finally got your videos really useful. Keep going, I'll recommend your videos to my friends.
Thank you for this great series
Glad you like them! 👍
Great series👋👋👋👋👍
gajab sir bhut badiya smjhaya hai apne
Glad you liked ✅️
Excellent 👍
Glad you liked ✅️
Just finished the whole series and it was so well structured and explained. Thanks Rishabh for making SQL looks easy and interesting. Would you be making more videos on advanced SQL?
Glad you liked it n for more sql videos you can watch the sql interview questions playlist on this channel
@@RishabhMishraOfficial @RishabhMishraOfficial bro you have not shared country table...
thank you bhaiya
Amazing Rishabh😊
YOU ARE GREAT MAN. THANKS ALOT FOR THIS TUTORIAL
Glad it helped :)
very nice content
Namaste sir very well explained thank you
Hi Rishabh Bhai, I really love your videos. Please Could you also make a separate Video on Views, Procedures and Trigger Functions? That would really help us. Thanks in Advance Bhai.
thanku sir,
Thank you
Thank you so much sir
Glad you liked
Everyone says SQL is soo much easy than Python, but now learning it by myself, i feels like that Python is more easy than SQL though it's my personal experience, i don't know why but i found myself to grasp Python syntaxes quite easily, maybe because I learned Python for 2 years i guess!
Yes may be. But if you know python then it's easy to understand sql
learning specific topic with example is easy to understand but when it comes to real life application and where to use it becomes bit difficult. Anyways Great content @RishabhMishra with clear cut explanation.
Yess that's why practice- solve interview problems
nice content
Thank you so much bhiya🙏🙏
Thank you for this tutorial !🎉
thanks man
Brother better than paid courses....but plz also make practice vedioes
Glad it was helpful ✅️
5:39 lol 😅 . good way of explanation
thanks
Glad you liked it ✅️
Good evening Rishabh bhai, your sql series is awesome and also your Example is very helpful or easy for everyone who want to learn, bhaiya I have a question, I want to ask that after learning sql what can I learn in either power bi tool or python? Plz reply for this query 😊😊😊
Yes after sql you can learn any of these excel, power bi n python. For detailed information n free resources you can watch my video on the - data analyst roadmap
Hii Rishab bhaiya, I hope you will be happy and healthy🙏, bhaiya I want to know, can I get a data analyst job based on Excel, SQL or Power BI without python ?
Well Explained, Make some videos on big Query
Noted ✅️
Rishabh sir, you did not show 'country' table data, we don't know what data were in "country' table, but whole contents are so good, can't express in words, Thanks
Sir Please can u send "country" and 'Address" table me kya kya columns and values hai bta skte hain , Please sir
Thank you in advance
Grateful!
Hi Rishabh, learning from you always great experience, here I am having error as "Column 'Customer_ID' was specified multiple times for my_cte"
Please provide your solution, thanks in advance
same doudt , brother you got any solution?
Can you please make videos on tableu and python just the same way as you made videos for sql. I really loved it and appreciate your quality content crisp videos.
Yes, soon ✅️
Sir please in one video cover recursive CTE too
Okay noted ✅️
Thanku so much sir.Mne ye puri playlist ki .Aap kaafi easy way mai samjate ho.Sir Advance SQL par Videos bana aur uske interview question par bi.Uske baad par Java in One Video aur Web Devlopment in one video bana do.Sir kam time mai aap bahut sikha dete ho.Plz Sir inn par bana do.Aapki vhje se jin students par time kam hota hai vo jaldi se new chije sikh lenge aur unka time bach jayega.Thanku So Much Sir Again.
Rishabh plss make videos on triggers nd store procedure also detailed w example
Okayy noted ✅️
Sir please make plsql series as well.
Okayy noted ✅️
SIR pls make videos on some other functions of SQL which helps to generate the random data especially for bank ,it will help to create the project related to bank generating random data
Hi @Rishab, thanks for explaining it in a simple way.
I am facing an issue while trying to run the first CTE query (Video Time 11:20).
MySQL has given an error: "Error Code: 1060. Duplicate column name 'Customer_ID'."
How to resolve this ? I will share the screenshot to you over LinkedIn
Same issue here
Thank you for the clear and concise explanation, Rishabh. I wish you the best. Could you please create a Python playlist? It would be greatly appreciated and very useful.
Will do soon ✅️
@@RishabhMishraOfficial bro you have not shared country table...
please one video about SQL variables.
Bhaiya aap padhate ho
.
.
Partition function pr video banao
After seeing all these comments 😒
Why can’t you explain in English bro ? It will be very useful for many of the job seekers and students from south India and it’s definitely gonna increase your viewers and subscribers as well 💯
Hii..
Please make vedio on ANY,ALL concept
Okayy noted ✅️
sir please if possible make another video on CTE topic .there are still some confusion in it . can u explain it
with some scenario based questions .like where we can use it and how it is different from windows functions etc.
Okayy noted ✅️
@@RishabhMishraOfficial thank you sir.. Will wait for it... 🙏
Rishabh bhai Stored procedure ka bhi vedio banao ek
Okayy noted ✅️
Can u make video on user defined function and all its type
Yess noted ✅️
Hi . Your content is great.
But i have a doubt in cte why we use cte ??? What is the benifit of cte ??
Sir stored procedure and triggers and view pe video bana do
just awesome sir, but i dont batter understand in subquery and windows function. please send for batter vedio this topic.
awesome work bhaiya but i am not getting the address table and country table ....plz do provide those files as well
can you please make the video on recursive cte
Okayy noted ✅️
Hi Sir, I have watched the whole playlist and I'm currently practicing. I find this video a little incomplete or difficult to understand. I would be grateful if you can make a detail video of this concept CTE.
@RishabhMishraOfficial ya I also feel the and country's csv file is not provided in github
@9:21 Hi, first of all thnx for this wonderful SQL course. I've a doubt in CTE example-Advance section...
Doubt: "my.highest_price, my.total_price" or baad mein jo "join my_cte my" isme ye my kaha se aaya... my koi table ka naam h ????
my_cte ek CTE hai we can say name of virual table
🔥
Plz tell me the best book for sql to purchase online
ek question dijiye please is topic se related of cutomer aur payment table se related. then we can try to solve problem.
Sir, ek basic data cleaning in a file using sql banado.... please aur uske liye dataset plus query caption mei provide krdo please
5:10 Rishab bhai jab main select first_name, last_name
From my_cte
Kar raha hu tab syntax error araha hae how i should solve it?
The output message is relation "my_cte" Doesn't exists.
Pls share the sql query
Bhai kya ye 15 videos me jo aapne topic cover kiye he SQL ke wo sufficient hai for entry level data analyst?
Yess along with this course just follow my playlist on sql interview questions and answers
Why average price came as 60
280
270
And count to why 1 2 3
It was supposed to come 3 in every row for count
And 270 for average
8:20 sir joi query ap run KR rhy hain
Me b wo he run KR rha ho
Lekin dublicate column name
Error aarha hai mysql me
Please reply me sir
How to fix it
Yeah... Even I am getting the same error of Duplicate column
Did u get any solution to it
if we will store cte in a view will it be saved in the memory ?
index ke upper ak video
Hi sir, I have learnt SQL and I have better knowledge of advance excel. Currently I m learning python...could you please tell me from where I get projects for mentioning in resume.
Hi Amit, you can get projects on YT, LinkedIn, Kaggle , etc
I have mentioned this point in my video How I Switched my career to data science.
I didn't understand few things.
Tell me I will explain bro
You have not shared nor mentioned about certain tables you have used in this video and the last few videos; they are not even available in your github link as well, I checked many times. From this video, the address table and country table are not available. And from previous videos, test_data table, custA table, custB table, emp table. Please recheck this and provide the tables. I am getting an error every time after running the same query as you.
same issue. Did you find it @hangloo6780
Sir Please can u send "country" and 'Address" table me kya kya columns and values hai bta skte hain , Please sir
Thank you in advance
same issue. did you find it @ram4437
then bhaiya what is the use of view vs cte
Dear Sir,
I am trying for FIFO Stock Valuation as follows using your taught methods like cte and window functions. but not getting done so far. If possible please help us solving this below case solved in a separate video which can be very fast even for lacs of records.
Input Table:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 ?
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 ?
14 12/29 150 ?
We need to populate the data according to FIFO method as following:
for 1st OutQty(13 Pcs)=12 Pcs @12.50+1Pcs*10.20=160.20/13=13 Pcs@12.32
for 2nd OutQty(25 Pcs)=25 Pcs @ 10.20 (Because 2nd InnQty has still sufficient Left(50-1-25)=24Pcs for next outqty)
for 3rd OutQty(150 Pcs)=24 Pcs @10.20+100Pcs*11.25+26 Pcs*11.25 (From Last InnQty as there is no more InnQty left) =1662.30/150=150Pcs@11.08
Output Query by CTE, Running Total and window functions Approach:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 12.32
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 10.20
14 12/29 150 11.08
Regards-
Sanjeeb
is this course completed? and enough for getting a job in data analytics?
Along with this course, also practice questions n make projects
But if we do not use cte and just join tables and do query for required columns, would that not work?
What if you need to perform any operations on the joined data
@@RishabhMishraOfficial as in? I did not get it. Please elaborate.
address ki table bhi create ki hai kya apne...
💌💌