Top 10 SQL interview Questions and Answers | SQL Interview Questions (Must Watch)
HTML-код
- Опубликовано: 13 июл 2024
- Top 10 SQL interview Questions and Answers | SQL Interview Questions (Most Important)
Want more similar videos- hit like, comment, share and subscribe !
🔖SQL Interview Q&A PDF: drive.google.com/file/d/1BVq6...
❤️Do Like, Share and Comment ❤️
❤️ Like Aim 5000 likes! ❤️
➖➖➖➖➖➖➖➖➖➖➖➖➖
👍 Subscribe Now: bit.ly/3Fc7Gc6
Do you want to become a Data Analyst or learn data analytics ? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science :)
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content⭐
00:00 Intro
01:20 Create Table
03:00 SQL Interview Question-1
12:18 SQL Interview Question-2
22:20 SQL Interview Question-3
29:50 SQL Interview Question-4
33:21 SQL Interview Question-5
39:28 SQL Interview Question-6
46:46 SQL Interview Question-7
53:09 SQL Interview Question-8
57:00 SQL Interview Question-9
59:18 SQL Interview Question-10
1:02:08 SQL Interview Question Bonus
1:04:12 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
More SQL for data science Videos:
📢Full SQL Tutorial in One Video: • SQL Tutorial for Begin...
🔖Most Asked SQL Interview Question: • Top SQL interview Ques...
🔖SQL Tutorial Playlist: • SQL Tutorial In Hindi
➖➖➖➖➖➖➖➖➖➖➖➖➖
👉Topics covered in this video:
SQL SELECT statement
SQL OPERATORS
SQL JOINS
SQL SUB QUERY
SQL DATE TIME FUNCTIONS
SQL CTE
SQL CASE STATEMENT
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
👉Instagram: / rishabhnmishra
👉LinkedIn: / rishabhnmishra
👉Twitter: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
More Related Videos:
📢Full Excel Tutorial in one Video: • Excel Tutorial For Beg...
🔖Excel Tutorial Playlist: • Excel for Beginners | ...
🔖Complete Data Analyst Roadmap: • How to Become Data Ana...
🔖Data Analyst Roadmap, Skills and Jobs: • Data Analyst- Skills, ...
🔖What Does a Data Analyst Actually Do?: • What Does a Data Analy...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
.
.
.
.
.
.
.
.
.
⭐Hashtags⭐
#sql #sqlinterviewquestions #sqlinterviewquestionsandanswers #sqlquestions
Related keywords
sql interview questions
sql interview questions and answers
sql interview
sql questions and answers
top sql questions
sql rishabh mishra
sql interview questions for freshers
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
sql queries interview questions and answers
sql interview preparation
sql basic questions
sql questions
sql query
interview questions sql
interview question sql join
interview questions sql basic
Advanced SQL Interview Questions Answer
Top 10 SQL Interview Questions Answer
SQL Interview Questions in hindi
SQL Interview Questions and answers for Freshers and Experienced
Top 10 SQL Interview Questions Answer
SQL Interview Questions Answer
SQL Interview hindi
SQL Interview Questions for freshers
SQL Interview Questions and answers for freshers
SQL Roadmap 2023
SQL Interview Questions 2023
SQL Interview Experience Interview questions for SQL Experienced
BEST SQL Interview Questions
Top 10 SQL interview Questions and Answers | SQL Interview Questions
Awesome Bhaiya 🔥🔥🔥
I learned whole SQL from your videos. Your explanation is another level🔥🔥.
Glad it was helpful ✅️
Keep learning n keep growing 🚀
Mere job interview mei bhi same questions aye the 👍👍
This is best 👍
@@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 🔥🔥🔥
@@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.
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
yes and that is simple too ,i did that way
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.....
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
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.
Awesome vedio please come with more scenarios based interview questions.thanks
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 🙏
Thank you brother...i needed this video for my upcoming interviews 😊
Seriously You are God for me, so impressive. I started following you from yesterday You are giving me so much confidence to pursue.
for mysql users this is the query
SELECT
Gender,
count(*) * 100.0 / (select count(*) from employee ) as ratio
FROM
Employee
GROUP BY
Gender;
thank you Rishabh You are a great teacher for me
It was great work brother. Thank You for the teach this. God Bless you
Glad it was helpful! ✅️
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
We want a combined project, related to mnc job profile. Those are realistic problems related to your daily work experience.🙏
Please help. How were you able to listen to the video in english? I don't understand his language. Please help. Thanks
Your Explanation is best and easy to understand for Beginners..............Thankyou So Much Sir😊🙏
Glad it was helpful ✅️
Thank you Rishabh, for this SQL tutorial. You are doing great!! Your explanation gives quick idea to understand.👌
Glad it was helpful! ✅️
Best sql qna video, was waiting for this video ❤❤🙏🙏
Glad you liked it ✅️
This is best SQL questions video 👍
bhai Your explanation is mind-blowing I did never thought like this thank you bhai
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....
Thanks a lot for knowledgeable content keep rocking looking forward for more technology videos. SQL and power bi are the best
Glad you like them! 👍
Good brain twisting questions. Helped me. Appreciate your efforts
Glad it was helpful ✅️
Superb bhai❤thnk u and expected more interview related questions basically am snowflake developer and job seeker pls help more bro
Sir ....aap kamal ho .....you r the one of the Best Teachers, Instructor, guide and so .....Huge Respect for you 🙏
Glad you liked the content ✅️
most helpfull video
Glad it helped ✅️
amazing video the last bonus question has been asked lately in obe the interviews.
Glad you liked it ✅️
Thanks for this amazing video with pure Content 💯 You are amazing ❤
Glad you liked ✅️
Awesome rishabh
Damn! Learned a lot from this video. Thank you so much and you are doing great for all of us .
Glad you liked it ✅️
Great effort ❤❤❤ Incredible explaination❤❤ keep going sir❤❤❤
Glad you liked it ✅️
thanks for the video lecture. Too much useful and informative.
Glad it was helpful! ✅️
Thanks for another SQL video 👍🏼👍🏼
Glad you liked ✅️
Create one video on data modeling, also explain how to create dimension table if we have only fact tables
Excellent , can i discuss DB2 IBM-I as well
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 .
Gr8 sir Thank you sir, because of you, I understood SQL very well.And I'm still learning SQL.
Glad it was helpful ✅️ keep learning n keep growing 🚀
@@RishabhMishraOfficial sir thoda sql me query h Maine apko instagram pr msg kiya h sir
Thank you so much for your hard work 👍👍 and then helping us out.
Glad you liked ✅️
Thankyou Sir
Glad you liked ✅️
Great ...waiting for advance level questions
Very soon..
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 ❤️
Hi, did you got the job?
Awesome sir as always
Glad you liked ✅️
Thank u so much for this video.......I need it
Glad you liked it ✅️
You are awesome rishabh
Thank you so much
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.
You are genuine. God will bless you
Glad you liked it ✅️
Thanks so much mate
Happy to help ✅️
Thank you for sharing this Information.
Glad it was helpful! ✅️
Really good 👍 thanks brother 👏👏
Glad you liked ✅️
Thank You Sir...learning a lot from u
Glad you liked it ✅️
Awesome brother, i try watch your all vedio
Glad you liked the content ✅️
Keep learning n keep growing 🚀
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.
Job mili?
Mili job?
Check how to update resume on days analytics on RUclips
Got ur job or still looking for ?
85954O7987 Please help with the data analyst job
great video bhaiya.....tons of thanks..
Please bring pyspark realtime project with problem statement .....
Glad you liked it ✅️ n noted
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
Thank you sir 🙏❤
Glad you liked ✅️
Thanks bhai its really very helpful for me 😘😘
Glad you liked 👍
Thank you very much bhaiya for easy video's like this. 😊🎉
Glad you liked ✅️
Thanks bhai
Happy to help ✅️
Most valuable video for career growth 📈
Glad you liked ✅️
Superb bro...
Glad you liked ✅️
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
Sir ThenxXX ; 🙏🙏
Glad you liked ✅️
Excellent bhaiya
Glad you liked ✅️
Rishab Bhai Thank you so much for this ( Bohot saari Duaaye )
Glad you liked ✅️
Best video ever
Love you Guru ❤️
Glad you liked ✅️
Thaxn for this video sir🙏
Glad you liked ✅️
You are fabulous thanx sir
Glad you liked the content
no words to say you Thank you
Glad you liked it ✅️
Best Video
Glad you liked ✅️
Please share interview questions for Power BI as well
Excellent video Bro....🔥🔥🔥🔥
Glad you liked ✅️
You are the best ❤❤
Glad you liked ✅️
Fantastic tutorial videos brother 🎉😊😊
Glad you liked ✅️
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
Thanks. Sir ❤️❤️
Glad you liked ✅️
Great efforts bhai🎉🎉🎉🎉🎉🎉🎉
Glad you liked it ✅️
Thanks Rishabh Brother !
Glad you liked ✅️
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.
thank you so much sir🥰🥰
Glad you liked ✅️
This is best sql interview video 👍👍✨✨
Glad you liked ✅️
Thank you for this video. But please make some videos on power bi.
I'm glad you liked ✅️ there are already 3 videos on power bi, and you can watch them
@@RishabhMishraOfficial thank you sir for reply ☺️
you are doing a great work bro
Glad you liked ✅️
Thanks for ensuring that we have insert statement for hands on.
Glad it was helpful ✅️
Thanks brother 🎉
Glad you liked ✅️
congratulates 100k
Thank you so much brother 😀 🙌
Sir pls make some more power bi, python, sql portfolio project videos pls sir i learn more from them as compared to questions
you r the best
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?
Really love your content. Love you from Pakistan.
Glad you liked ✅️
PLEASE!!! Make a Video On PowerBI Project
It's really good 👍 approach but I have still some doubts
Please make video on pgadmin4 DBMS tutorial
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.
Okayy noted ✅️
Nice one, do you have any session to install db in windows or macos system for practice?
Yes, already uploaded a video on how to download n install postgre sql
Mose easiest way in MS SQL-select empname,stuff(salary,len(salary)-1,3,'XX') as masked_salary from employee
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
Sir make one full video on what is needed to be cover on python,numpy,panda and important stuff
Okayy noted ✅️
Please solve in Oracle SQL 🙏
I would like to request you, Please make video Power BI, SQL and Python for data analyst with project
Okayy noted ✅️
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);
7(a) not working, This solution is wrong, please check it again.
Video on how to explain data analytics projects in interview please ❤❤
Noted!