No video

53 SQL Interview Questions Answers [Hindi+English] | Written Scanned Notes | My 200+ Interviews

  Рет қаралды 201,422

NitMan Talks

NitMan Talks

Күн бұрын

Пікірлер: 253
@NitManTalks
@NitManTalks Жыл бұрын
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
@ashutosh.kaushik
@ashutosh.kaushik 2 жыл бұрын
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.
@NitManTalks
@NitManTalks 2 жыл бұрын
Great to hear! Actually I made the content for this video as per my 200+ interviews, Glad you Liked!!!
@ashutosh.kaushik
@ashutosh.kaushik 2 жыл бұрын
@@NitManTalks great work indeed
@preranagowda6689
@preranagowda6689 2 жыл бұрын
Please provide notes
@ashutosh.kaushik
@ashutosh.kaushik 2 жыл бұрын
@@preranagowda6689 Now you will ask to give interview in place of you...work hard and get the things rather than mugging up
@okbhai9261
@okbhai9261 2 жыл бұрын
@@NitManTalks where is the notes bro
@journey_towards_krishna
@journey_towards_krishna Жыл бұрын
No words to express my gratitude to u sir. Krishna bless u. Thanks a lot for your efforts and time. 😇
@mk-ov4js
@mk-ov4js 2 жыл бұрын
Its 53 again 🙏 .Now a days channel is growing very fast . I am happy to see that .
@NitManTalks
@NitManTalks 2 жыл бұрын
🙏🙏🙏🙏🙏✌️
@WhoamI-me3ee
@WhoamI-me3ee 3 ай бұрын
finally, I get the best video on SQL.
@jaiKumar-sx9xv
@jaiKumar-sx9xv Жыл бұрын
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.
@ajinxRGB
@ajinxRGB Жыл бұрын
Awesome video!! covers almost all the queries that are asked in the interviews in just 1 hr. Great job wonderful content !!
@KisaanTuber
@KisaanTuber 2 жыл бұрын
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.
@sanket565
@sanket565 Жыл бұрын
38.13 min : Truncate is not a DML command, its a DDL command which is faster than delete.
@minakshi_119
@minakshi_119 Жыл бұрын
Thank you so so much, Sir. You have no idea how much your lectures are benefiting us.
@madhusmittaacharya
@madhusmittaacharya Жыл бұрын
Your video helped me get a job.. thanks a lot
@supriyapatil422
@supriyapatil422 2 жыл бұрын
One of the best video for the preparation of SQL.. Thanks for this video
@rkrrkumar511
@rkrrkumar511 5 ай бұрын
Great video! Referring before every interview. One correction create comes under DQL(Data Query language).
@anonsiya1176
@anonsiya1176 2 ай бұрын
Select comes only under dql, create comes under ddl
@MilindBabar
@MilindBabar 2 жыл бұрын
Thank you so so much for all your videos. Keep posting, guiding us. God bless you. Best wishes.
@aviralsaxena06
@aviralsaxena06 Жыл бұрын
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❤❤❤
@sakshisaini1230
@sakshisaini1230 Жыл бұрын
Complete topics of sql in one video..💯👍🏻
@shubhamjain7668
@shubhamjain7668 2 жыл бұрын
Bhai mere dil jeet liya .Thanks for sharing slides.
@naveenkumarnaravala
@naveenkumarnaravala 2 жыл бұрын
Thanks @NitMan Talks, indeed a best video. Request you have a complete video in English
@NitManTalks
@NitManTalks 2 жыл бұрын
Thanks. That will gonna take a while.
@nehapuri761
@nehapuri761 Жыл бұрын
You put lots of efforts in this video .. your video should have more likes. 👍
@user-jy8mt2om6g
@user-jy8mt2om6g 4 ай бұрын
best video ever on interview questions sir, thanks a lot
@NitManTalks
@NitManTalks 4 ай бұрын
Glad you liked it. Thanks
@vishalbobde326
@vishalbobde326 2 жыл бұрын
Your content very helpful freshers and also Experience, Thank you.
@nishantargade4579
@nishantargade4579 Жыл бұрын
Most easy way explaination Thank you bro 😊
@surajchahande2803
@surajchahande2803 2 жыл бұрын
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
@aniketdhale7510
@aniketdhale7510 2 жыл бұрын
Bhai ..what a Information.....iske aage interviewer bhi kya puchega 🙏🙏🙏🙏🙏🙏 thanks Bhai .. 🙏😎
@MEENA-SUITS-KOLKATA
@MEENA-SUITS-KOLKATA 2 жыл бұрын
bhai mene aapka abhi tak pura video dekh nhi he lkin aapko slam karta hun...aur subs bhi kar diya
@firozalam2749
@firozalam2749 2 жыл бұрын
maja aaya ... almost everything covered.
@Trendz-w5d
@Trendz-w5d Жыл бұрын
Bht mehnat ki hai bhai. Thank you so much
@kedandu4209
@kedandu4209 2 жыл бұрын
Amazing explanation. God bless you. Keep the good work
@kashyaphitesh4386
@kashyaphitesh4386 2 жыл бұрын
Overall you explained well Thanks. One Correction - TRUNCATE is a DDL command.
@NitManTalks
@NitManTalks 2 жыл бұрын
Thanks. Yes yu r right!!!
@zeeshanraza1393
@zeeshanraza1393 2 жыл бұрын
@@NitManTalks Brother in questions ki google sheet ya PDF ka link dy do
@ravimalvathkar7028
@ravimalvathkar7028 Жыл бұрын
Select is a DQL command right?
@dhakshayani737
@dhakshayani737 Жыл бұрын
@@ravimalvathkar7028 Yes it is
@luckyreddy7023
@luckyreddy7023 2 жыл бұрын
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
@AKASHKUMAR-zz5rm
@AKASHKUMAR-zz5rm Жыл бұрын
Bhutt masst video hai sir jabardast 🔥
@bsivakeshava15
@bsivakeshava15 Жыл бұрын
Superb bro ..no words about your explanation
@IrfanKhan-fz8ju
@IrfanKhan-fz8ju Жыл бұрын
lovely its really helpful for every one
@Sanvibhagat937
@Sanvibhagat937 2 жыл бұрын
Perfect Interview question Answer. Can you provide pdf file of this video?
@MohammadImran-rn1vg
@MohammadImran-rn1vg Жыл бұрын
Link to PDF in pinned comment.
@nikhilv8048
@nikhilv8048 2 жыл бұрын
Thanks for the information, it inspires me to see from a young developer
@dollyaggarwal8144
@dollyaggarwal8144 Жыл бұрын
this is a very good video kudos to you.
@ankitac4994
@ankitac4994 2 жыл бұрын
very helpful videos.... Thanks NITMAN!!!!!
@sayarasayyad3730
@sayarasayyad3730 Жыл бұрын
Really nice video. Covered almost everything. Well done. Please prepare video on Unix interview Questions as well..
@rahulgautam511
@rahulgautam511 2 жыл бұрын
Great Source..Thanks Buddy
@naturevideos8029
@naturevideos8029 11 ай бұрын
thanks so much nitman. you are amazing.
@vinitshirke7032
@vinitshirke7032 Жыл бұрын
Excellent videos sir gbu 😊😊😊
@sushmitha8247
@sushmitha8247 2 жыл бұрын
Tqsm senior ❤️🤩🤩🤩🤩
@Ji-yoon
@Ji-yoon 2 жыл бұрын
Thank you so much. Make one video for DBMS interview questions too ( like ER diagrams etc. )
@neeravsoanii9520
@neeravsoanii9520 2 жыл бұрын
very helpful and well explained. Thanks NitMan
@pranavsinha5700
@pranavsinha5700 2 жыл бұрын
Awesome video bhai. This is a lifesaver
@PUNEETCHATURVEDI-go1sb
@PUNEETCHATURVEDI-go1sb Жыл бұрын
way of explaination is excellent brother
@beingcheercool
@beingcheercool Жыл бұрын
Love you brother ❤️ Big hats off to you 🙌
@trisha-alittleangel8287
@trisha-alittleangel8287 Жыл бұрын
Thank you so much for this video..I have one request to you that kindly make video for Pyspark
@ratnambargupta8525
@ratnambargupta8525 2 жыл бұрын
Very Helpful.
@seemakanyawal5307
@seemakanyawal5307 2 жыл бұрын
Thank u sir i was waiting for this vedio ,please make vedio on oops concept also .
@NitManTalks
@NitManTalks 2 жыл бұрын
As soon as possible
@Pihu_09
@Pihu_09 Жыл бұрын
Apka jldi hi 1M ho jyega
@reena3119
@reena3119 Жыл бұрын
Thank you ❤ You are providing Notes 👍
@dhilip77
@dhilip77 2 жыл бұрын
Thank bhai. Helps a lot
@Soni01-k3s
@Soni01-k3s 7 ай бұрын
Thank u For Video
@Scientist_Ritik_Tiwari
@Scientist_Ritik_Tiwari 2 жыл бұрын
Thanks sir 👍😊🙏🏻
@kshamasathe3500
@kshamasathe3500 Жыл бұрын
Keep up the good work!
@lakshmireddy9952
@lakshmireddy9952 2 жыл бұрын
Excellent Sir
@moviesfun9898
@moviesfun9898 Күн бұрын
After 16:10,, 3rd query will fail if the inserted records don't have the ID's in a sequence (means it will only work if ID's are like 18,19,20,21,22 ) but if suppose last 5 inserted records having the ID's like 5,8,9,10,19 then it will print only 19 because it is greater than the count(*)-5
@MonkeyDLuffy4885
@MonkeyDLuffy4885 Жыл бұрын
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.
@abdullahamin4504
@abdullahamin4504 2 жыл бұрын
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
@abhishekchaudhari2344
@abhishekchaudhari2344 Жыл бұрын
great video........
@yashmathur5609
@yashmathur5609 Жыл бұрын
Thank you so much
@ankitmittal9458
@ankitmittal9458 2 жыл бұрын
Bahut badhiya sir it's very useful for my interview and aap soringboot,microservices,hibernate,core java par bhi interview question banaye
@ankitmittal9458
@ankitmittal9458 2 жыл бұрын
Soringboot -springboot
@ViruSahastrabuddhe
@ViruSahastrabuddhe 2 жыл бұрын
Waiting eagerly...
@NitManTalks
@NitManTalks 2 жыл бұрын
😍😍
@geethagautam2800
@geethagautam2800 Жыл бұрын
Thankyou sir
@chalivendri
@chalivendri Жыл бұрын
For 3rd Qn we can use select * into tablname2 from tablename1;
@NeverStopLearning56
@NeverStopLearning56 2 жыл бұрын
Vedio's are very good, But please try to explain in English which is a common language for everyone, Many of us don't understand Hindi...
@NitManTalks
@NitManTalks 2 жыл бұрын
Will add subtitles to each and every video!! Work in progress!!
@codewithdeepak45
@codewithdeepak45 2 жыл бұрын
Thanks Bhaiya
@78siddhesh
@78siddhesh 2 жыл бұрын
Correction- Select is a DQL COMMAND not DML Command
@shanmukhasrinivas9473
@shanmukhasrinivas9473 2 жыл бұрын
Great work brother
@Swapnil_Lifestyle
@Swapnil_Lifestyle 2 жыл бұрын
very informative video
@beingcheercool
@beingcheercool Жыл бұрын
Sir CN and OS OOP ke liye bhi videos banao pls bhaiyya ☺️
@ramanrajputindian5974
@ramanrajputindian5974 2 жыл бұрын
Good afternoon sir ❣️
@NitManTalks
@NitManTalks 2 жыл бұрын
Goood Afternoo!!
@arupparida5638
@arupparida5638 2 жыл бұрын
Thanks alot
@satyamsrivastava5468
@satyamsrivastava5468 2 жыл бұрын
nice work, good content
@smrutiranjanparida9766
@smrutiranjanparida9766 2 жыл бұрын
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);
@tteejjj
@tteejjj 2 жыл бұрын
Thank you legend
@nishantgholap5103
@nishantgholap5103 Жыл бұрын
very nice explain.. but 28:57 select is DQL command...
@priyankadas7914
@priyankadas7914 Жыл бұрын
Is your video enough to learn about SQL for Python developer job?
@05_jayachaubey86
@05_jayachaubey86 2 жыл бұрын
Is the first question applicable for Oracle-SQL too? Because I have not heard anything like "Create Database" over there.
@masheTyMasha
@masheTyMasha Жыл бұрын
Thank yoin
@swapnilkatkar590
@swapnilkatkar590 Жыл бұрын
Thank You.
@namitamehta8896
@namitamehta8896 2 жыл бұрын
Very useful video Nitin!!
@NitManTalks
@NitManTalks 2 жыл бұрын
Thanks 🤗
@PUNEETCHATURVEDI-go1sb
@PUNEETCHATURVEDI-go1sb Жыл бұрын
bro CTE,stored procedure, triggers and cursor please iska bhi ek video banao
@prashantprabhat4223
@prashantprabhat4223 2 жыл бұрын
From where we can get scanned copy of notes of these questions
@MohammadImran-rn1vg
@MohammadImran-rn1vg Жыл бұрын
Link to PDF in pinned comment.
@shahhussain56
@shahhussain56 Жыл бұрын
Its a huge request plz make a same video on mongodb 🙏🏻🙏🏻🙏🏻
@anmolpreetsingh3624
@anmolpreetsingh3624 2 жыл бұрын
Please make a video on JAVA interview questions also
@srd1705
@srd1705 2 жыл бұрын
Hi very informative video Please share link to these question and answers so that they are easily readable
@NitManTalks
@NitManTalks 2 жыл бұрын
Will share this month. Stay connected.
@HassanBinKamal
@HassanBinKamal Жыл бұрын
can u plz share a video covering complete sql for dba role?
@subhashdixit5167
@subhashdixit5167 2 жыл бұрын
Please share the pdf notes. I have an interview tomorrow. It will be helpful for me.
@MohammadImran-rn1vg
@MohammadImran-rn1vg Жыл бұрын
Link to PDF in pinned comment.
@priyankadey5617
@priyankadey5617 2 жыл бұрын
the 2nd part of question number 9 ... why he used "inner join" while joining the same table? can't we use "self join" there ?
@dexxxxxxxx
@dexxxxxxxx 2 жыл бұрын
1.Could you please upload PDF? 2. How to remember that command will come before FROM or after FROM?
@MohammadImran-rn1vg
@MohammadImran-rn1vg Жыл бұрын
Link to PDF in pinned comment.
@MilindBabar
@MilindBabar 2 жыл бұрын
Django orm pr bhi vdo banaiye na plz plz plz. If possible urgent 😉🙈
@NitManTalks
@NitManTalks 2 жыл бұрын
Sure. But already I created a video on Django Ques Answers, yu can refer that!
@MilindBabar
@MilindBabar 2 жыл бұрын
@@NitManTalks i watched almost all videos you posted. Really really thank u for such videos.
@MilindBabar
@MilindBabar 2 жыл бұрын
@@NitManTalks from your busy schedule if possible plz orm and drf pr videos upload kijiye.
@NitManTalks
@NitManTalks 2 жыл бұрын
Sure... Soon ..!!!!!
@MilindBabar
@MilindBabar 2 жыл бұрын
@@NitManTalks thank you
@ramakanthamshala2311
@ramakanthamshala2311 2 жыл бұрын
Sir Plz Maintain the git hub repository. So that we can easily read all the questions.
@ocean2738
@ocean2738 Жыл бұрын
I am a beginner pls tell most of commands are not working in Ms sql Or these are for my SQL??
@anishpawar8852
@anishpawar8852 2 жыл бұрын
bhai pdf bhi de dete btw grt video
@NitManTalks
@NitManTalks 2 жыл бұрын
Already shared hai bro! Checkout the comment section for that telegram link..
@ruhiscorner7318
@ruhiscorner7318 3 ай бұрын
can anybody explain me the logic of ques 4-using distinct keyword?
@videoeditorshiva
@videoeditorshiva Жыл бұрын
Very Helpful please provide the notes so we can also quickly go through the questions again
@NitManTalks
@NitManTalks Жыл бұрын
Already shared!
@videoeditorshiva
@videoeditorshiva Жыл бұрын
Why can't I see it in ur description
@MohammadImran-rn1vg
@MohammadImran-rn1vg Жыл бұрын
Link to PDF in pinned comment.
@NitManTalks
@NitManTalks Жыл бұрын
@@MohammadImran-rn1vg already done that! ✅
@nikhilchoudhary3608
@nikhilchoudhary3608 2 жыл бұрын
Is it good for mysql?
@PavanKumar-nh5fe
@PavanKumar-nh5fe 2 жыл бұрын
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);
Мы сделали гигантские сухарики!  #большаяеда
00:44
а ты любишь париться?
00:41
KATYA KLON LIFE
Рет қаралды 3,6 МЛН
If Barbie came to life! 💝
00:37
Meow-some! Reacts
Рет қаралды 78 МЛН
Мы сделали гигантские сухарики!  #большаяеда
00:44