53 SQL Interview Questions Answers [Hindi+English] | Written Scanned Notes | My 200+ Interviews
Вставка
- Опубліковано 8 лип 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
Thank you so so much, Sir. You have no idea how much your lectures are benefiting us.
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.
No words to express my gratitude to u sir. Krishna bless u. Thanks a lot for your efforts and time. 😇
One of the best video for the preparation of SQL.. Thanks for this video
Awesome video!! covers almost all the queries that are asked in the interviews in just 1 hr. Great job wonderful content !!
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.
Bhai mere dil jeet liya .Thanks for sharing slides.
Your content very helpful freshers and also Experience, Thank you.
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❤❤❤
Complete topics of sql in one video..💯👍🏻
Your video helped me get a job.. thanks a lot
Most easy way explaination
Thank you bro 😊
Amazing explanation. God bless you. Keep the good work
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.
very helpful videos.... Thanks NITMAN!!!!!
Great Source..Thanks Buddy
Love you brother ❤️
Big hats off to you 🙌
Thank you ❤
You are providing Notes 👍
Superb bro ..no words about your explanation
maja aaya ... almost everything covered.
very helpful and well explained. Thanks NitMan
thanks so much nitman. you are amazing.
Thank bhai. Helps a lot
Awesome video bhai. This is a lifesaver
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
Very Helpful.
Its 53 again 🙏 .Now a days channel is growing very fast . I am happy to see that .
🙏🙏🙏🙏🙏✌️
Thanks sir 👍😊🙏🏻
lovely its really helpful for every one
Bhutt masst video hai sir jabardast 🔥
Tqsm senior ❤️🤩🤩🤩🤩
Really nice video. Covered almost everything. Well done.
Please prepare video on Unix interview Questions as well..
Excellent Sir
Thank you legend
You put lots of efforts in this video .. your video should have more likes. 👍
Thank You.
way of explaination is excellent brother
Thank you so much
Thanks for the information, it inspires me to see from a young developer
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
very informative video
For 3rd Qn we can use select * into tablname2 from tablename1;
Great work brother
Thank u For Video
Bht mehnat ki hai bhai.
Thank you so much
Thanks alot
Thanks Bhaiya
nice work, good content
Keep up the good work!
Thankyou sir
this is a very good video kudos to you.
Thanks @NitMan Talks, indeed a best video. Request you have a complete video in English
Thanks. That will gonna take a while.
Thank you so much. Make one video for DBMS interview questions too ( like ER diagrams etc. )
Bhai ..what a Information.....iske aage interviewer bhi kya puchega 🙏🙏🙏🙏🙏🙏 thanks Bhai .. 🙏😎
great video........
best video ever on interview questions sir, thanks a lot
Glad you liked it. Thanks
Thank you so much for this video..I have one request to you that kindly make video for Pyspark
Excellent videos sir gbu 😊😊😊
Sir Plz Maintain the git hub repository. So that we can easily read all the questions.
Is the first question applicable for Oracle-SQL too? Because I have not heard anything like "Create Database" over there.
Waiting eagerly...
😍😍
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.
Very useful video Nitin!!
Thanks 🤗
Thank yoin
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! Referring before every interview. One correction create comes under DQL(Data Query language).
Select comes only under dql, create comes under ddl
bhai mene aapka abhi tak pura video dekh nhi he lkin aapko slam karta hun...aur subs bhi kar diya
can u plz share a video covering complete sql for dba role?
Thank u sir i was waiting for this vedio ,please make vedio on oops concept also .
As soon as possible
Please make a video on JAVA interview questions also
Its a huge request plz make a same video on mongodb 🙏🏻🙏🏻🙏🏻
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
Bahut badhiya sir it's very useful for my interview and aap soringboot,microservices,hibernate,core java par bhi interview question banaye
Soringboot -springboot
Apka jldi hi 1M ho jyega
Sir CN and OS
OOP ke liye bhi videos banao pls bhaiyya ☺️
Good afternoon sir ❣️
Goood Afternoo!!
very nice explain.. but 28:57 select is DQL command...
Perfect Interview question Answer. Can you provide pdf file of this video?
Link to PDF in pinned comment.
Is your video enough to learn about SQL for Python developer job?
bro CTE,stored procedure, triggers and cursor please iska bhi ek video banao
the 2nd part of question number 9 ... why he used "inner join" while joining the same table? can't we use "self join" there ?
please nitman make a video SQL Database project 🙏🙏🙏
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
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);
Correction- Select is a DQL COMMAND not DML Command
Select is Drl command
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?
From where we can get scanned copy of notes of these questions
Link to PDF in pinned comment.
I am a beginner pls tell most of commands are not working in Ms sql
Or these are for my SQL??
c1 c2 c3
4 2
2
c1/c3=c3 in etl testing query/
how to write?
Please
Hi very informative video
Please share link to these question and answers so that they are easily readable
Will share this month. Stay connected.
can anybody explain me the logic of ques 4-using distinct keyword?
BRO I NEED THE DATAEST ALSO
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);
Django orm pr bhi vdo banaiye na plz plz plz. If possible urgent 😉🙈
Sure. But already I created a video on Django Ques Answers, yu can refer that!
@@NitManTalks i watched almost all videos you posted. Really really thank u for such videos.
@@NitManTalks from your busy schedule if possible plz orm and drf pr videos upload kijiye.
Sure... Soon ..!!!!!
@@NitManTalks thank you