53 SQL Interview Questions Answers [Hindi+English] | Written Scanned Notes | My 200+ Interviews
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 2024
- #sql #sqlinterviewquestions #sqlinterviewquestionsandanswers
In this video, I will Provide You all the answers to the question that I mentioned in the Video - "53 SQL Interview Questions From my 200+ interviews"
Watch the video till the end, hope you enjoy the video. If you enjoy this video, please give it a like, comment, share, and Don't forget to SUBSCRIBE!
Chapters:
00:00 - Introduction
00:20 - 4 Parts Of Questions
00:44 - SQL Command Based Questions
21:02 - Mostly Asked Questions
51:11 - Commonly Asked Questions
59:02 - Advanced/Rarely Asked Questions
01:11:30 - Conclusion
************************************************
Stay Connected!! Connect with me:
Instagram: / nitinmangotra
LinkedIn:
Facebook: / nitmantalks
Twitter: / nitinmangotra07
************************************************
#SQLinonevideo #interviewexperience #nitinmangotra Nitin Mangotra | Nitman Talks
53 SQL Interview Questions Answers
53 SQL Interview Answers
53 SQL Interview Answer Key
53 SQL Interview Questions and Answers
Mostly asked SQL Interview Questions Answer
Commonly asked SQL Interview Questions Answer
SQL Command Based Interview Questions Answer
Advanced SQL Interview Questions Answer
Top 10 SQL Interview Questions Answer
SQL Interview QuestionsSQL Interview Questions and answers for Experienced
Top 10 SQL Interview Questions Answer
SQL Interview Questions Answer
SQL Interview
SQL Interview Questions for freshers
SQL Interview Questions and answers for freshers
SQL Roadmap
SQL Interview Questions 2022
SQL Interview Experience Interview questions for SQL Experienced
Interview experience Software Engineer
Software Developer Experience
Nitin Mangotra
************************************************
Thank you all for your love and Support. And I really hope this video helps you to crack your interviews.
53 SQL Questions-Answers -docs.google.com/presentation/...
Thanks and Much Love To You ALL!!!❤
PS: Do let me know in the comments if this video helps you in order to get shortlisted in any company.
❣💥🤘
Regards,
NitMan
Thank you all for your love and Support. And I really hope this video helps you to crack your interviews.
53 SQL Questions-Answers -docs.google.com/presentation/d/1IqV_h8SdailZMyvuzlzzCuoplXQ6fp64KMjFxORAZx0/edit?usp=sharing
Thanks and Much Love To You ALL!!!❤
PS: Do let me know in the comments if this video helps you in order to get shortlisted in any company.
❣💥🤘
Regards,
NitMan
Being very honest, I have had like 10-15 inteviews recently and this video has everything in it for yoour last min practice, splendid job brother and well explained.
Great to hear!
Actually I made the content for this video as per my 200+ interviews, Glad you Liked!!!
@@NitManTalks great work indeed
Please provide notes
@@preranagowda6689 Now you will ask to give interview in place of you...work hard and get the things rather than mugging up
@@NitManTalks where is the notes bro
finally, I get the best video on SQL.
38.13 min : Truncate is not a DML command, its a DDL command which is faster than delete.
Thanks NitMan for sharing this awesome video. Really helpful for the interview sessions. One recommendation would be using RANK/ DENSE_RANK function for getting nth highest salary instead of limit as multiple rows can have same salary. Let me know your thoughts.
Thank you so so much, Sir. You have no idea how much your lectures are benefiting us.
Awesome video!! covers almost all the queries that are asked in the interviews in just 1 hr. Great job wonderful content !!
One of the best video for the preparation of SQL.. Thanks for this video
No words to express my gratitude to u sir. Krishna bless u. Thanks a lot for your efforts and time. 😇
awesome bro... just after watching 3 questions, I was really impressed by your work and efforts, which forced me to like your videos first, and started watching the video.
Thank you so so much for all your videos. Keep posting, guiding us. God bless you. Best wishes.
Thank you bhaiya for making such videos, they really helped me a lot to revise all concepts before the interview. Please keep making more such content❤❤❤
Amazing explanation. God bless you. Keep the good work
Your content very helpful freshers and also Experience, Thank you.
Complete topics of sql in one video..💯👍🏻
very helpful videos.... Thanks NITMAN!!!!!
Bro questions and explanation is good But my suggestion is to code directly in mysql or microsoft sql server directly , so that simontinously we can do practice
Bhai mere dil jeet liya .Thanks for sharing slides.
very helpful and well explained. Thanks NitMan
Really nice video. Covered almost everything. Well done.
Please prepare video on Unix interview Questions as well..
Thank you ❤
You are providing Notes 👍
Love you brother ❤️
Big hats off to you 🙌
Its 53 again 🙏 .Now a days channel is growing very fast . I am happy to see that .
🙏🙏🙏🙏🙏✌️
Most easy way explaination
Thank you bro 😊
For 3rd Qn we can use select * into tablname2 from tablename1;
Great Source..Thanks Buddy
Superb bro ..no words about your explanation
Thanks you brother make one video for Flask framework questions and answers it is very helpful for me for my interview so i am waiting for videos on flask
Great video! Referring before every interview. One correction create comes under DQL(Data Query language).
Your video helped me get a job.. thanks a lot
You put lots of efforts in this video .. your video should have more likes. 👍
Awesome video bhai. This is a lifesaver
maja aaya ... almost everything covered.
Thank you so much. Make one video for DBMS interview questions too ( like ER diagrams etc. )
thanks so much nitman. you are amazing.
Is the first question applicable for Oracle-SQL too? Because I have not heard anything like "Create Database" over there.
nice work, good content
Great work brother
way of explaination is excellent brother
very informative video
Thank bhai. Helps a lot
best video ever on interview questions sir, thanks a lot
Glad you liked it. Thanks
lovely its really helpful for every one
Thank you so much for this video..I have one request to you that kindly make video for Pyspark
Excellent Sir
Very Helpful.
Bhai ..what a Information.....iske aage interviewer bhi kya puchega 🙏🙏🙏🙏🙏🙏 thanks Bhai .. 🙏😎
Thank u For Video
Thank you legend
Sir Plz Maintain the git hub repository. So that we can easily read all the questions.
Bhutt masst video hai sir jabardast 🔥
Thanks @NitMan Talks, indeed a best video. Request you have a complete video in English
Thanks. That will gonna take a while.
Thanks sir 👍😊🙏🏻
Thanks for the information, it inspires me to see from a young developer
Nitin Bhaiya, simply amazing....... I am loving this❤❤. Can you make a video on Machine Learning and Data Science also? Would be really great.....
Thank you for the amazing content.
Bht mehnat ki hai bhai.
Thank you so much
Thanks alot
can u plz share a video covering complete sql for dba role?
Keep up the good work!
Excellent videos sir gbu 😊😊😊
Tqsm senior ❤️🤩🤩🤩🤩
this is a very good video kudos to you.
Very useful video Nitin!!
Thanks 🤗
Thank You.
Thank you so much
Thanks Bhaiya
Hellow -----
My self Abdullah from bangladesh .
I Watch your video regularly and now i complete django playlist.
i learn everything from your youtube ---
thank you ---
I have a request to you that please make a video how to use django custom admin panel instead django default admin templare....
please
please
please --------- i wait for your notification
bhai mene aapka abhi tak pura video dekh nhi he lkin aapko slam karta hun...aur subs bhi kar diya
Is your video enough to learn about SQL for Python developer job?
very nice explain.. but 28:57 select is DQL command...
Thankyou sir
the 2nd part of question number 9 ... why he used "inner join" while joining the same table? can't we use "self join" there ?
Waiting eagerly...
😍😍
Overall you explained well Thanks. One Correction - TRUNCATE is a DDL command.
Thanks. Yes yu r right!!!
@@NitManTalks Brother in questions ki google sheet ya PDF ka link dy do
Select is a DQL command right?
@@ravimalvathkar7028 Yes it is
great video........
Correction- Select is a DQL COMMAND not DML Command
Thank u sir i was waiting for this vedio ,please make vedio on oops concept also .
As soon as possible
bro CTE,stored procedure, triggers and cursor please iska bhi ek video banao
Perfect Interview question Answer. Can you provide pdf file of this video?
Link to PDF in pinned comment.
Please make a video on JAVA interview questions also
Its a huge request plz make a same video on mongodb 🙏🏻🙏🏻🙏🏻
Let me tell you all a fun fact. We can use having without using groupby also to filter aggregated and non ggregated data. But we cannot use where to filter aggregated data. There is a misconception that having is used to filter aggregated data. It can filter all kinds of data. We can use having without group by to behave it like where. Check it and Thank me Later.
Haven't used that way .. but will try this one.
Thanks
Sir CN and OS
OOP ke liye bhi videos banao pls bhaiyya ☺️
Bahut badhiya sir it's very useful for my interview and aap soringboot,microservices,hibernate,core java par bhi interview question banaye
Soringboot -springboot
Thank yoin
if i find last 5salary from a table,there might be duplicate salary what should we do in that case
these query not suitable for distinct value:
select * from employee
where ID > (select max(ID)-5
from employee);
I am a beginner pls tell most of commands are not working in Ms sql
Or these are for my SQL??
Apka jldi hi 1M ho jyega
these quires are not working while executing can please reply me whatis the problem
select * sal from emp2
order by sal desc limit 1 off set N-1
CREATE TABLE emp1 AS SELECT * FROM emp WHERE
create table emp select *from emp
select * from emp
create table emp1 as (select * from emp where 1=3);
Good afternoon sir ❣️
Goood Afternoo!!
can anybody explain me the logic of ques 4-using distinct keyword?
please nitman make a video SQL Database project 🙏🙏🙏
i have doubt in subquery about second and 3rd highest salary, the answer would be 65000 not 51000,
c1 c2 c3
4 2
2
c1/c3=c3 in etl testing query/
how to write?
Please
bhai ye database ka ko access kaise kare,open source,username and password ??
Please share the pdf notes. I have an interview tomorrow. It will be helpful for me.
Link to PDF in pinned comment.
Is it good for mysql?
Select is Drl command
From where we can get scanned copy of notes of these questions
Link to PDF in pinned comment.
Hi very informative video
Please share link to these question and answers so that they are easily readable
Will share this month. Stay connected.