Awesome Bhaiya 🔥🔥🔥 I learned whole SQL from your videos. Your explanation is another level🔥🔥.

@RishabhMishraOfficial

Жыл бұрын

Glad it was helpful ✅️ Keep learning n keep growing 🚀

@hk0153

Жыл бұрын

Mere job interview mei bhi same questions aye the 👍👍

@vrindakunj

Жыл бұрын

This is best 👍

@sanchitkanojia5460

Жыл бұрын

@@RishabhMishraOfficial one request Bhaiya if you have more questions on SQL related to interview please share with us as soon as possible. I almost done with SQL for data analyst interview. Right now I am practicing. I loved your content 🔥🔥🔥

@ihgamingfun6295

Жыл бұрын

@@sanchitkanojia5460 gud luck 🤞

Your teaching is truly exceptional. Your SQL tutorials have been an immense help to me. I was wondering if you might consider creating a comprehensive video series that covers Power BI, starting from the basics and progressing to advanced topics. Your teaching style is fantastic, and I believe many learners, including myself, would greatly benefit from such a series.

Great work Rishabh. You're the best. 100% trust in your work and efforts.

Hey brother !! SQL Server: Since you mentioned SQL Server, focus on learning the specific features and tools provided by SQL Server, such as SQL Server Management Studio (SSMS) for administration, SQL Server Integration Services (SSIS) for data integration, and SQL Server Reporting Services (SSRS) for reporting. Please make video on this

Thank you brother...i needed this video for my upcoming interviews 😊

thank you Rishabh You are a great teacher for me

Best teacher, i would understand your teachings easily Alhamdulillah. I have watched and taken notes of your excel, sql and power bi videos. Waiting for python videos. You keep teaching and keep growing.

Brother, we have one query, that is, which type of data are used to analyse in mnc firms where we are supposed to work. Please make one project on power BI related to that problem. For example any of the queries related to your job profile, will give us more confidence 🙏

for 6th question we can also use simple window function to solve it: with cte as( select *,dense_rank() over(order by salary desc) as rnk from Employee ) select distinct cte.salary from cte where cte.rnk = 2 # 2nd highest salary

@rohitkumarraghav6307

6 ай бұрын

yes and that is simple too ,i did that way

@ashwinkrishnan1287

Ай бұрын

As a general thumb rule we shouldn’t write co related sub queries in practice because of poor performance so better to use window functions

your's way of explanation is very nice.....

for mysql users this is the query SELECT Gender, count(*) * 100.0 / (select count(*) from employee ) as ratio FROM Employee GROUP BY Gender;

Awesome vedio please come with more scenarios based interview questions.thanks

Hello sir apke guide se bht kch clear hua hai sir mai mba in business analytics kr rhi hubut mera background psychology graduate h but mai basic power bi, sql basic , basic paython or Excel janti hu mujhe Carrer kaise start krna chahiye data analytics me job mil payega yah fir business analytics se start krna shi hoga as a fresher

Seriously You are God for me, so impressive. I started following you from yesterday You are giving me so much confidence to pursue.

You are awesome rishabh Thank you so much

bhai Your explanation is mind-blowing I did never thought like this thank you bhai

Q7(b) select empname,project from employee as co inner join employedetail as ed on co.empid=ed.empid Group By empname,project it can be done by this method also

Thank you so much Rishabh sir for this sql question and answers series....You are great❤❤❤You are the best teacher in the whole world.... Because of you i learnt sql from scratch....Keep posting more videos on these topics...we all love you ❤❤❤❤ lots of love❤More power to you....

You are genuine. God will bless you

@RishabhMishraOfficial

10 ай бұрын

Glad you liked it ✅️

Thanks for another SQL video 👍🏼👍🏼

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

delete from employee where empid in (select empid from employee group by empid having (count (*))>1); this query deletes all the records we should implement the query to delete duplicates and it should keep 1 record out of duplicates records.

Superb bhai❤thnk u and expected more interview related questions basically am snowflake developer and job seeker pls help more bro

Your Explanation is best and easy to understand for Beginners..............Thankyou So Much Sir😊🙏

@RishabhMishraOfficial

11 ай бұрын

Glad it was helpful ✅️

amazing video the last bonus question has been asked lately in obe the interviews.

@RishabhMishraOfficial

7 ай бұрын

Glad you liked it ✅️

thanks for the video lecture. Too much useful and informative.

@RishabhMishraOfficial

10 ай бұрын

Glad it was helpful! ✅️

It was great work brother. Thank You for the teach this. God Bless you

@RishabhMishraOfficial

4 ай бұрын

Glad it was helpful! ✅️

Excellent , can i discuss DB2 IBM-I as well

Thank You Sir...learning a lot from u

@RishabhMishraOfficial

10 ай бұрын

Glad you liked it ✅️

Great ...waiting for advance level questions

@RishabhMishraOfficial

11 ай бұрын

Very soon..

Thank you for sharing this Information.

@RishabhMishraOfficial

8 ай бұрын

Glad it was helpful! ✅️

Create one video on data modeling, also explain how to create dimension table if we have only fact tables

Thank u so much for this video.......I need it

@RishabhMishraOfficial

6 ай бұрын

Glad you liked it ✅️

Thanks a lot for knowledgeable content keep rocking looking forward for more technology videos. SQL and power bi are the best

@RishabhMishraOfficial

11 ай бұрын

Glad you like them! 👍

Sir ....aap kamal ho .....you r the one of the Best Teachers, Instructor, guide and so .....Huge Respect for you 🙏

@RishabhMishraOfficial

10 ай бұрын

Glad you liked the content ✅️

Om Shanti Your teaching practice is good. But you explain with accounting situation just like receipt, payment, invoice, customer master, item master, employee master, account group master, in this validation, min. Max. Reorder level & save with text box feed.

Thanks so much mate

@RishabhMishraOfficial

10 ай бұрын

Happy to help ✅️

Most valuable video for career growth 📈

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Best sql qna video, was waiting for this video ❤❤🙏🙏

@RishabhMishraOfficial

Жыл бұрын

Glad you liked it ✅️

@vrindakunj

Жыл бұрын

This is best SQL questions video 👍

Thank you so much for your hard work 👍👍 and then helping us out.

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

You are great and no 1 who made excellent projects . I learnt how to make dashboards on excel from u only and also sql from u and power bi ❤❤❤❤❤. Thanks for everything bhaiya . We are expecting lot from you . Please make combined projects like sql+ tabluea or sql + excel bhaiya

@AK-wu2yp

11 ай бұрын

We want a combined project, related to mnc job profile. Those are realistic problems related to your daily work experience.🙏

@ehisolojo4502

11 ай бұрын

Please help. How were you able to listen to the video in english? I don't understand his language. Please help. Thanks

Rishab Bhai Thank you so much for this ( Bohot saari Duaaye )

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Thankyou Sir

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

Thank you sir 🙏❤

@RishabhMishraOfficial

Ай бұрын

Glad you liked ✅️

Thanks for this amazing video with pure Content 💯 You are amazing ❤

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Thank you rishab sir you and your videos is helping me a lot I had been concerned about how will I make my career but now I am working on my self and learning the skills to become a data analyst by watching your videos I am a beginner but I m sure that with your help I will definitely make a good career thank you sir ❤️

@shweta6580

Ай бұрын

Hi, did you got the job?

Damn! Learned a lot from this video. Thank you so much and you are doing great for all of us .

@RishabhMishraOfficial

11 ай бұрын

Glad you liked it ✅️

Please share interview questions for Power BI as well

Great effort ❤❤❤ Incredible explaination❤❤ keep going sir❤❤❤

@RishabhMishraOfficial

7 ай бұрын

Glad you liked it ✅️

Best video ever Love you Guru ❤️

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

Good brain twisting questions. Helped me. Appreciate your efforts

@RishabhMishraOfficial

Ай бұрын

Glad it was helpful ✅️

Thank you Rishabh, for this SQL tutorial. You are doing great!! Your explanation gives quick idea to understand.👌

@RishabhMishraOfficial

4 ай бұрын

Glad it was helpful! ✅️

Thanks Rishabh Brother !

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

How do you use the sum, join the group by, and order by function in SQL in 1 command will you give some examples?

Q. 7 b the easiest approach is Select empname, project from employee inner join employeedetail on employee.empid = employeedetail.empid group by project having count (*) >1

You are fabulous thanx sir

@RishabhMishraOfficial

9 ай бұрын

Glad you liked the content

Mose easiest way in MS SQL-select empname,stuff(salary,len(salary)-1,3,'XX') as masked_salary from employee

Really good 👍 thanks brother 👏👏

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

most helpfull video

@RishabhMishraOfficial

Жыл бұрын

Glad it helped ✅️

great video bhaiya.....tons of thanks.. Please bring pyspark realtime project with problem statement .....

@RishabhMishraOfficial

10 ай бұрын

Glad you liked it ✅️ n noted

no words to say you Thank you

@RishabhMishraOfficial

5 ай бұрын

Glad you liked it ✅️

Awesome brother, i try watch your all vedio

@RishabhMishraOfficial

11 ай бұрын

Glad you liked the content ✅️ Keep learning n keep growing 🚀

Gr8 sir Thank you sir, because of you, I understood SQL very well.And I'm still learning SQL.

@RishabhMishraOfficial

11 ай бұрын

Glad it was helpful ✅️ keep learning n keep growing 🚀

@mayankrajput8074

11 ай бұрын

@@RishabhMishraOfficial sir thoda sql me query h Maine apko instagram pr msg kiya h sir

Thanks bhai its really very helpful for me 😘😘

@RishabhMishraOfficial

10 ай бұрын

Glad you liked 👍

Thanks bhai

@RishabhMishraOfficial

11 ай бұрын

Happy to help ✅️

First of all Thank you Mr. Rishabh to make this awesome & helpful video, please help me to resolve one doubt of question 4, where you used Emp.Rownumber % 2 = 0, my doubt is why did you use operater '%' instead of operator '/ ' thanks in advance , will wait for your reply

Sir ThenxXX ; 🙏🙏

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Thank you very much bhaiya for easy video's like this. 😊🎉

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Thaxn for this video sir🙏

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Thanks. Sir ❤️❤️

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

Q6. we can also use below query to get 2nd highest salary select * from (select *, rank() over(order by salary desc) as rn from employee) as t where t.rn = 2; Q7. solution for removing duplicate values delete from employees where ( select empid, empname,gender,salary, city from (select *, row_number() over(partition by empid) as rn from employees ) as t where t.rn > 1);

@Mr_Cap.

7 ай бұрын

7(a) not working, This solution is wrong, please check it again.

Awesome rishabh

q7 a if there are duplicate values such as 2 arjun with same empid then both the data is being deleted . please look into it

Thanks brother 🎉

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Fantastic tutorial videos brother 🎉😊😊

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Please solve in Oracle SQL 🙏

One more solution for finding Nth Salary Using Rank Method : WITH cte AS( SELECT *, RANK() OVER(ORDER BY salary DESC) FROM employee ORDER BY salary DESC ) SELECT * FROM cte WHERE rank = N

Hey Rishabh , really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience .

It's really good 👍 approach but I have still some doubts

This is best sql interview video 👍👍✨✨

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

thank you so much sir🥰🥰

@RishabhMishraOfficial

10 ай бұрын

Glad you liked ✅️

PLEASE!!! Make a Video On PowerBI Project

Excellent video Bro....🔥🔥🔥🔥

@RishabhMishraOfficial

9 ай бұрын

Glad you liked ✅️

Excellent bhaiya

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

Thank you Rishabh , I started my Data Analyst journey 4 months back from your videos and its been monumental for me. I have a request to please make a demo video on " updating resume as per the job requirement" . I have been applying for DA job but getting rejections from everywhere. I think there's need of a change in the way I apply. Also, I got really happy to know that You are also an APS alumni.

@frazafridi6316

9 ай бұрын

Job mili?

@ethenhunt1654

8 ай бұрын

Mili job?

@tejasvikamble9061

5 ай бұрын

Check how to update resume on days analytics on KZread

@Anamikasingh_23

5 ай бұрын

Got ur job or still looking for ?

@sagarkumar-hd1yd

3 ай бұрын

85954O7987 Please help with the data analyst job

Thanks for ensuring that we have insert statement for hands on.

@RishabhMishraOfficial

Жыл бұрын

Glad it was helpful ✅️

hi rishabh i have a doubt in hackerrank top eaner problem the solution with worked is select months * salary , count(employee_id) from employee group by months * salary order by months * salary desc limit 1 ; but i thought abt an alternate solution but it didnot worked select months * salary , count(employee_id) from employee where months * salary = (select max(months * salary) from employee); in chatgpt they both are giving same result with multiple examples can you tell me how these two are diffrent ?

Awesome sir as always

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

Hii rishabh I have completed excel python and sql But now I am very confused about math for data science.... How much I have to read , which topics, how much time should I give...... Don't know anything Statistics, probability, linear algebra, calculus and so onn.... I don't know where to start..... Please make a detailed video on it...... And if you read this comment then please let me know by your reply..... Thanks

Good content. However the solution to deleting duplicate rows seems incorrect. Your solution will delete all the employee data which has more than 1 row for an empid. We only want unique employees in the table and duplicated removed. We don't want to delete the whole empids which has duplicates. Correct solution would be I believe: delete from Employee where empid in ( select empid from ( select *, row_number() over (partition by empid order by empid) as rn from Employee) A where A.rn > 1) Correct me if I am wrong. Happy learning!!

Sir agar koi koi company hire kar rahi hai based on sql skill to us par bhi video banana

you are doing a great work bro

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

Great efforts bhai🎉🎉🎉🎉🎉🎉🎉

@RishabhMishraOfficial

10 ай бұрын

Glad you liked it ✅️

Sir pls make some more power bi, python, sql portfolio project videos pls sir i learn more from them as compared to questions

Bhaeya apke videos dekh kar sql and excel Sikh liya and 2 projects bhi bana diye, first of all thanks for that providing such valuable knowledge, but mujhe portfolio banana nahi aa raha, kya aap ekbar apne music sql project ka portfolio bana k dengey jab bhi aap k pass time ho.

@RishabhMishraOfficial

11 ай бұрын

Glad it was helpful ✅️ Okayy will make a detailed video on this ✅️

Really love your content. Love you from Pakistan.

@RishabhMishraOfficial

11 ай бұрын

Glad you liked ✅️

You are the best ❤❤

@RishabhMishraOfficial

Жыл бұрын

Glad you liked ✅️

Hi , Bhaiya I want to become to Data Analyst but I've no experience in coding, what should I start with ? SQL or Python?!Please guide me..

Thanks much. Would you please make video on Agile scrum, Project manager and Product manager. And roadmap for all these 3 jobs - Project Manager, Product manager and Scrum master.

@RishabhMishraOfficial

10 ай бұрын

Okayy noted ✅️

Hi Rishabh, Thanks a lot for this awesome video. Will you please reply this-: Alias doesn’t work with where clause ( I understand this reason ) then Why Alias works with “Having Clause “ . Don’t understand clear reason behind this. Thanks

Best Video

@RishabhMishraOfficial

9 ай бұрын

Glad you liked ✅️