MUST DO INTERVIEW QUESTIONS IN SQL | MOST IMPORTANT QUESTIONS IN SQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ต.ค. 2024
  • Hello everyone,
    In today's video, we'll see the most important interview questions for SQL.
    Do check the video to ace any SQL interview.
    If it helped you then share it with your friends, juniors and anyone who might find it helpful.
    Do subscribe to the channel.
    Thank you!
    If you need personal help in SQL, Mock interviews, You can contact me on work.sadiasiddiqui@gmail.com, Please note it will be a paid.

ความคิดเห็น • 213

  • @crackconcepts
    @crackconcepts  ปีที่แล้ว +2

    ✨Link to my SQL e-book: imojo.in/rkajq9
    ✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
    (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

  • @vinothkannans1910
    @vinothkannans1910 3 ปีที่แล้ว +30

    Great. This will be helpful for full stack developer role also. Please include relationships (one - one, one - many, many- many) concepts also

  • @prathmeshshinde8420
    @prathmeshshinde8420 2 ปีที่แล้ว +6

    great video helped me lot for interview but you should have given link of your videos in description

  • @shalinigupta3209
    @shalinigupta3209 3 ปีที่แล้ว +26

    Your tutorials are very helpful.
    Just a request.. can you please help with doc file or scan copies of your notes to quickly revise it. Also, can you share the list if all videos for SQL .

    • @k.l3447
      @k.l3447 2 ปีที่แล้ว

      Sss

    • @AnshulKumbhare
      @AnshulKumbhare 2 ปีที่แล้ว

      Please share pdf file in description that you teach us on paper for revise us quickly 🙏

  • @nikkunshu
    @nikkunshu 3 ปีที่แล้ว +5

    I get all these questions all the time and forget what they were. Thanks a lot.

    • @OracleLand_Official
      @OracleLand_Official 3 ปีที่แล้ว +1

      Checkout here full interview questions for Oracle....

  • @anbesivam7686
    @anbesivam7686 3 ปีที่แล้ว +8

    This is really useful. But if you give answer for those questions. it would be very nice.

    • @funny-bz1xv
      @funny-bz1xv 3 ปีที่แล้ว

      Thora mehnat khud se bhi kr lo

    • @rreeband
      @rreeband 3 ปีที่แล้ว

      @@ug1880 Could you please link to it? I didn't find it

    • @rreeband
      @rreeband 3 ปีที่แล้ว

      @@ug1880 Thank you very much! :)

  • @supjena9890
    @supjena9890 2 ปีที่แล้ว +1

    This was really helpful. I prepared these questions and these were the mostly asked questions in interview. Thank you

  • @pratikroy2448
    @pratikroy2448 3 ปีที่แล้ว +14

    For creating the copy of only the schema(not the data within), we can also use,
    Create Table Students_Copy As Select * from Students
    Where 1=2

  • @jayakrishna-miriyam
    @jayakrishna-miriyam 3 ปีที่แล้ว +41

    @Crack Concepts : Please provide list of the video's link you made according to the above mentioned Levels order. That may be very useful to watch from their.

    • @poojav2585
      @poojav2585 2 ปีที่แล้ว +2

      You can check that in the playlists option on her TH-cam page. Where videos are sorted based on the concepts like SQL, python etc anyways it's been an year now and you might not need this comment anymore 😅

    • @jayakrishna-miriyam
      @jayakrishna-miriyam 2 ปีที่แล้ว +1

      @@poojav2585 Thankyou :)

    • @AnshulKumbhare
      @AnshulKumbhare 2 ปีที่แล้ว

      Please provide list of the video's link you made according to the above mentioned orders.
      It is deficult to pause then go to playlist for cheak it out. Then again come to previous video to watch next imp question then again go to playlist..
      Hope you will understand what i am trying to...

  • @saifali4107
    @saifali4107 ปีที่แล้ว +1

    Very useful video.
    It will be helpful if you could include the links to the solution videos in the description.
    Thanks.

  • @ShubhamSingh-lh1nl
    @ShubhamSingh-lh1nl 3 ปีที่แล้ว +7

    I am a SQL developer and these are some really good questions ,keep going kudos to the hardwork!!!

    • @syedahmad4466
      @syedahmad4466 3 ปีที่แล้ว

      Is ETL or SQL developer are same ?

    • @ShubhamSingh-lh1nl
      @ShubhamSingh-lh1nl 3 ปีที่แล้ว +1

      @@syedahmad4466 ETL stand for Extract Transition and Load(of data) SQL is a very important part of doing that SQL developer is a person who is good with SQL language and one SQL IDE (like SSMS) ETL Developer other than knowing SQL also know about few tools or software which help in extraction and loading of data like SSIS .

    • @syedahmad4466
      @syedahmad4466 3 ปีที่แล้ว

      What will be the future of ETL developr as a fresher and after 2 year experience

    • @ShubhamSingh-lh1nl
      @ShubhamSingh-lh1nl 3 ปีที่แล้ว

      @@syedahmad4466 It is good as it lays foundation for being data engineer or data scientist.

    • @shivarajhalageri2513
      @shivarajhalageri2513 3 ปีที่แล้ว

      @Shubham Singh can you please tell how can I get into a SQL domain as a career

  • @Manishkumar-od1cs
    @Manishkumar-od1cs 3 ปีที่แล้ว +3

    Waw... Good👍. I have faced same question in my interview..

  • @muhammadsameedaffan9894
    @muhammadsameedaffan9894 3 ปีที่แล้ว +2

    Delivery of words, Flow of topic, and information shows how much you did hard work to make this video! can't have words to admire!!!!!!
    Thanks!!!

  • @malice112
    @malice112 2 ปีที่แล้ว +3

    what about tabular and scalar functions? are they commonly asked about during SQL interviews?

  • @pallavivarma4481
    @pallavivarma4481 3 ปีที่แล้ว +7

    Very nice ...very informative...make more interview questions as it helps alot ...thanku for this video ....god bless 🌟🌟🌟

  • @Soouuize
    @Soouuize 2 หลายเดือนก่อน

    1) select * from emp
    order by sal desc
    limit 1
    offset 3

  • @aashiqashu2636
    @aashiqashu2636 3 ปีที่แล้ว +1

    Yeah its very helpful to all whose don't know about the question ⁉️ ask in interview to freshers ... But u ill try to give little bit of deep explanation and ur voice is very low... And keep going like this to help us mam... Thanks

  • @yuvrajoberoi7834
    @yuvrajoberoi7834 4 ปีที่แล้ว +9

    Great compilation of questions. Thank you.

  • @pratikkulkarni4929
    @pratikkulkarni4929 2 ปีที่แล้ว

    Thank n sadiya ur videos are really really imp for me specially the second highest salary one

  • @LubulaChikwekwe
    @LubulaChikwekwe 3 ปีที่แล้ว +2

    This was clear and insightful. I liked it

  • @markslima1557
    @markslima1557 2 ปีที่แล้ว

    This video was really awesome and I learned a couple things thank you

  • @parthasarathyraja8917
    @parthasarathyraja8917 3 ปีที่แล้ว +2

    Very good teaching the logical ideas and it's explanation madam. Thank you. Pls the volume of audio to be increased.

  • @saga3273
    @saga3273 3 ปีที่แล้ว

    just 10 secs into this video.
    First Impression : lovely and sweet Voice . Really

  • @cletusdsouza7276
    @cletusdsouza7276 3 ปีที่แล้ว +2

    Thank you ma'am 👍 it helped in sql questions all out of this set

  • @vishnusvlog6117
    @vishnusvlog6117 ปีที่แล้ว

    Very nice thankyou...
    Can u please tell be how to create an user defined function , which will multiply the given number by 10?

  • @kalyanipriyadarsini
    @kalyanipriyadarsini 3 ปีที่แล้ว +1

    Yes true these types of question are asked but i always failed at the nth salary finding...

    • @rejingunasekaran
      @rejingunasekaran 3 ปีที่แล้ว

      Don't worry, now you know the answer right?, Good luck for the next time. 🤝🏻

  • @InterviewDOT
    @InterviewDOT 3 ปีที่แล้ว +1

    very nice thanks for sharing

  • @itdp.warangal
    @itdp.warangal 2 ปีที่แล้ว

    Ok mam I will learn from level 1 for interview

  • @aarthiboopalan
    @aarthiboopalan 8 หลายเดือนก่อน

    excellent video pls put data analyst interview questions

  • @venkataraomandadi7434
    @venkataraomandadi7434 3 ปีที่แล้ว +2

    Really appreciated and thank you , it helps us a lot

  • @burelasekhar4044
    @burelasekhar4044 3 ปีที่แล้ว +3

    Please provide PDF files also.
    Below provide PDF links it will be useful for everyone. Thank you

  • @nehal93
    @nehal93 3 ปีที่แล้ว +3

    would have been good if you had example query of each for Level 1 & 2 :)

    • @suchitraeliballi9555
      @suchitraeliballi9555 3 ปีที่แล้ว

      True

    • @nikkunshu
      @nikkunshu 3 ปีที่แล้ว

      But then this video would have been enough for most

    • @SriRamTrading
      @SriRamTrading 3 ปีที่แล้ว

      Keep your idea on your brain

    • @allinonebyakk7878
      @allinonebyakk7878 2 ปีที่แล้ว

      Those are all explained in her SQL interview questions playlist.
      Please go through.... U should have basic knowledge to understand her examples.

  • @shrutishetye1963
    @shrutishetye1963 2 ปีที่แล้ว

    Great video....but it will be have more nice if u have provided questions

  • @gauravwalapkar4534
    @gauravwalapkar4534 3 ปีที่แล้ว +2

    I don't looking for a video of for level 1 first two question.. You will give it to in your video descriptions... then their much better to discover the content.. that you said it.. the way you are teaching is much better.. I respect ... keep it up...✌

  • @rajashekar6811
    @rajashekar6811 3 ปีที่แล้ว

    I like your explaination.....very clear...very helpful....immidiately i subscribed ur channel....

  • @lakshmis5854
    @lakshmis5854 2 ปีที่แล้ว

    Great video with lot of questions covered in depth

  • @gyani4914
    @gyani4914 3 ปีที่แล้ว +1

    Great information! Thank you 👍🙏

  • @akankshasingh4725
    @akankshasingh4725 3 ปีที่แล้ว

    Very nice and simple video. thanks a lot

  • @runningbees7152
    @runningbees7152 2 ปีที่แล้ว

    helpful video ...more on sql and job opportunities please

  • @Bdlover-24
    @Bdlover-24 2 ปีที่แล้ว

    Thank you sadia ❤️❤️it's helpful for us

  • @humushaikh4462
    @humushaikh4462 3 ปีที่แล้ว

    Thank u very much. Simple n understandable.

  • @sadiqraza1658
    @sadiqraza1658 3 ปีที่แล้ว +6

    Hello Sadia, I am Sadiq :). These are really good selected questions and widely asked, and very useful for revision purpose. It would really help even more if you could explain the answers as well in your next videos, so that we can find everything in one place..Thanks for sharing this

  • @itsarsh4421
    @itsarsh4421 3 ปีที่แล้ว

    Please mention those videos link in the description which you said to watch later. Thanks !

  • @dd0078
    @dd0078 4 ปีที่แล้ว

    Good knowledge information. All video are best explain.

  • @girisringeri
    @girisringeri 5 หลายเดือนก่อน

    Character manipulation and String functions are same ?

  • @sainathg3339
    @sainathg3339 4 ปีที่แล้ว +2

    Hi...can you please provide pictures of the papers...that could be helpfull to go through easily

  • @NISAR0402
    @NISAR0402 2 ปีที่แล้ว

    excellent mam.
    I need your help to crack the interview of 3+ yrs of experience in PL/SQL.To be frank i have basic knowledge but not experienced.help me to attend the online technical round.

  • @pratikthakare415
    @pratikthakare415 3 ปีที่แล้ว +10

    Mam Do you take offline classes as well?

  • @umap7086
    @umap7086 3 ปีที่แล้ว

    Excellent teaching. KEEP Making more videos

  • @prreeeee
    @prreeeee 2 ปีที่แล้ว

    Best for last minute preparation ✨

  • @sameerbharti5705
    @sameerbharti5705 3 ปีที่แล้ว

    Thanks a lot for the presicse data...

  • @shafikkhatib9119
    @shafikkhatib9119 3 ปีที่แล้ว

    Hello mam nice explaination. My question is can we have parameters in view like stored procedure

  • @amitchauhan1505
    @amitchauhan1505 3 ปีที่แล้ว +2

    very specific to imp ques, relevant.

  • @prasangisrinivasarao1862
    @prasangisrinivasarao1862 2 ปีที่แล้ว

    PLEASE PROVIDE ALL QUATIONS ANSWERS ALSO

  • @antonyjayaraj95
    @antonyjayaraj95 3 ปีที่แล้ว

    Thank you for the information

  • @Ray-1666
    @Ray-1666 3 ปีที่แล้ว

    Thank you so much... It really helped a lot

  • @sourabhpatil2361
    @sourabhpatil2361 2 ปีที่แล้ว

    One Question
    I want particular name at the top and that is placed at 3rd postion and then other names to be continued then how to fnd it

  • @vaibhavsingh3247
    @vaibhavsingh3247 2 ปีที่แล้ว

    Thanks a lot, Sadia ✌

  • @hmmer3471
    @hmmer3471 3 ปีที่แล้ว

    Thank you very much this is clear

  • @subramanyamreddypolamreddy2844
    @subramanyamreddypolamreddy2844 3 ปีที่แล้ว

    Have u made any video with Answers for these questions ..?

  • @puneethbe
    @puneethbe 3 ปีที่แล้ว

    Dear madam explain very good
    Can I get prented copy for your notes please

  • @abtfacts7987
    @abtfacts7987 4 ปีที่แล้ว

    Good one. Pls make videos topic wise. It is very helpful for us

  • @parth7450
    @parth7450 7 หลายเดือนก่อน

    Usefull collection

  • @satishKumar-bf9ey
    @satishKumar-bf9ey 3 ปีที่แล้ว

    Almost all questions were covered, thank you

  • @harikasekhar6638
    @harikasekhar6638 ปีที่แล้ว

    Thank you so much mach

  • @shubhampawar.7776
    @shubhampawar.7776 2 ปีที่แล้ว

    Ek number

  • @srinivasa5650
    @srinivasa5650 7 หลายเดือนก่อน

    You are dope
    Thnks for the content

  • @soumadas8967
    @soumadas8967 2 ปีที่แล้ว

    Thank you mam
    It's really helped a lot 😊

  • @relax9286
    @relax9286 2 ปีที่แล้ว

    Thank you.

  • @mubinshaik19
    @mubinshaik19 3 ปีที่แล้ว

    Ossem video sadiya👍

  • @ashutoshshinde5267
    @ashutoshshinde5267 3 ปีที่แล้ว

    This is really helpful. Thank you!!

  • @jitendraverma3783
    @jitendraverma3783 3 ปีที่แล้ว

    Very Informative
    Thankyou siooo much👍

  • @olajumokemolade4780
    @olajumokemolade4780 3 ปีที่แล้ว

    what is the differeence between union and intersect?

  • @allinonebyakk7878
    @allinonebyakk7878 2 ปีที่แล้ว

    those are all explained in her sql interview questions playlist.
    please go through.... u should have basic knowledge to understand her examples.

  • @amitsh5413
    @amitsh5413 2 ปีที่แล้ว

    Great coverage

  • @vishalsaxena5081
    @vishalsaxena5081 3 ปีที่แล้ว +1

    provide answers also of these questions

  • @riteshkavankar
    @riteshkavankar 2 ปีที่แล้ว

    Thanks sadiya 😊

  • @shashanktiwari3458
    @shashanktiwari3458 4 หลายเดือนก่อน

    It is very helpful 👍

    • @crackconcepts
      @crackconcepts  4 หลายเดือนก่อน

      Glad to hear that

  • @willturner3440
    @willturner3440 2 ปีที่แล้ว

    god has send you for help
    Thanks a lot god

  • @satishKumar-bf9ey
    @satishKumar-bf9ey 3 ปีที่แล้ว

    Simply superb

  • @sudeshsalvi8853
    @sudeshsalvi8853 3 ปีที่แล้ว

    Create video on function and stored procedures.

  • @marvinmachitar7229
    @marvinmachitar7229 2 ปีที่แล้ว

    5:54 MINUS is for oracle, EXCEPT for sql server. both have same purpose.

  • @borisf9496
    @borisf9496 3 ปีที่แล้ว +1

    Hi,
    Thank you for the video. I would like To know what kind of job you can when you know sql language. Which company hires ? Also, what courses To take To be Well prepared for job opportunities ? Thank you

  • @referearn6450
    @referearn6450 3 ปีที่แล้ว

    You should add video link of those video

  • @rajunagadasari1160
    @rajunagadasari1160 2 ปีที่แล้ว

    Excellent

  • @shobhitranjan3957
    @shobhitranjan3957 3 ปีที่แล้ว +1

    Very Helpful!

  • @JunaidStudios
    @JunaidStudios 3 ปีที่แล้ว

    Excellent!

  • @tanzzyreacts4798
    @tanzzyreacts4798 3 ปีที่แล้ว

    What about indexing....its too important topic for interview purpose.

  • @vikaspatel3548
    @vikaspatel3548 2 ปีที่แล้ว

    would you please provide the pdf of the sheet which you are using in the video?

  • @stutisinghal1514
    @stutisinghal1514 3 ปีที่แล้ว

    really nice video , keep making more such videos :)

  • @SureshG-ml5kv
    @SureshG-ml5kv 2 ปีที่แล้ว

    Really helped a lot

  • @kumarakumara3865
    @kumarakumara3865 4 ปีที่แล้ว

    your explanation good and your voice also good please increase your voice

  • @yogeshvedpathak8837
    @yogeshvedpathak8837 ปีที่แล้ว

    Awesome 😎 👍

  • @franklinnagralkar7256
    @franklinnagralkar7256 2 ปีที่แล้ว

    good thank you so mu h

  • @BhanuPrakash-mf7br
    @BhanuPrakash-mf7br 2 ปีที่แล้ว

    Hi,
    Thanks for your video, will you provide training for SQL.
    If yes can you please let me know.

  • @udhai4897
    @udhai4897 3 ปีที่แล้ว

    Very helpful....thanks a lot😊

  • @anilnerella3459
    @anilnerella3459 3 ปีที่แล้ว

    Super explanation and good stuff

  • @KrishnaArjun1996
    @KrishnaArjun1996 2 ปีที่แล้ว

    THANK YOU

  • @mrinalraj7166
    @mrinalraj7166 3 ปีที่แล้ว

    This is very good

  • @Faisal1504
    @Faisal1504 3 ปีที่แล้ว

    very helpful thank you !