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.

  • @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 UA-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?

  • @InterviewDOT
    @InterviewDOT 3 роки тому +1

    very nice thanks for sharing

  • @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. 🤝🏻

  • @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

  • @burelasekhar4044
    @burelasekhar4044 3 роки тому +3

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

  • @venkataraomandadi7434
    @venkataraomandadi7434 3 роки тому +2

    Really appreciated and thank you , it helps us a lot

  • @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

  • @itsarsh4421
    @itsarsh4421 3 роки тому

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

  • @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

  • @dd0078
    @dd0078 3 роки тому

    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 👍

  • @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 !