SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 ก.ย. 2019
  • In this video, we’ll solve sql queries for practice. Important SQL interview queries.
    ✨Work related mails can be sent on:
    work.sadiasiddiqui@gmail.com
    ✨If you appreciate my work and would like to donate to support our channel, you can do so here:
    paypal.me/sadia1702

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

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

    ✨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)

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

    It feels like when a friend of urs is explaining all this to you just before 5mins and boom you rock that exam.... Explanation with such an ease..... Woww....

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

    Concepts explained with such simplicity. Truly awesome.

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

    Hi Ma'am,
    Your videos are really helpful for interview preparation. Now we need not to waste precious time browsing confusing contents on net. Keep uploading more contents. :)

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

    Your videos are life saver! The explanations are easy to understand. Subscribed!

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

    I like the way she explains the problems and very good way to explain on papers by writing them self

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

    Very useful and helpful videos !!! To the point and time savers !!!

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

    Clean,Simple and precisely explained :) . Good work.

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

    super job .
    god bless you.
    nice job. In 5 min only i got more information.

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

    Very Well Explained, and a nice practice for my learning.

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

    Would be good to include the questions/Queries in your description summary so that we can also practice once without having to run the video again

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

    Give more questions like this.
    It is helpful when we practice this Looking at your questions at one place.
    If I don't practice sql for 3 4 days, i forget basics of SQL like insert, update, delete drop with where etc

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

    I am watch many vedio about SQL in TH-cam but I have not get man think about SQL Query question solving in easy way but after watching your vedio every think clear about SQL and I think you have too much knowledge about SQL Query and thanks for providing this type of think by the help of vedio...

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

    I have been looking for such vedios for long. Short ,simple and easy.

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

    Thank you so much 👍🏻. It was a great brief coverage of DML statements.

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

    Creative explanation. Another way of Quick Learn SQL. Keep Going 👍👍👍

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

    I'm watching after 4 years , still it is so helpfull and i will always be helpfull in/for future ❤❤

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

    Thank you so much for all the efforts you are making to provide this information smoothly .

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

    Learnt SQL topics and queries few days back Just a beginner quite impressed by your q and a

  • @shubhamgupta-ur3hf
    @shubhamgupta-ur3hf 3 ปีที่แล้ว

    I have watched many video for SQL tutorials but I understand ur video properly thanks for the help

  • @user-rr9lo4wc8g
    @user-rr9lo4wc8g 10 หลายเดือนก่อน +10

    1. UPDATE emp
    SET salary = salary * 1.05; --This approach is easier to remember.

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

    Hello, i hope u r dng well ,good job and plz post some a little complex queries..

  • @AnshSharma-lw6rz
    @AnshSharma-lw6rz ปีที่แล้ว

    Great work and explanation Sadia feels like a friend of mine is teaching me 👍🏻👍🏻

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

    3 question I think we need to use having for aggregate functions

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

    Simple sample of sql queries with simple pen and awesome musical voice.. 💐

  • @mr.x6499
    @mr.x6499 3 ปีที่แล้ว +27

    Awesome voice..

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

    Query 4,select * from employees where first_name like '%A' and LENGTH(first_name) =6;

    • @sajani6609
      @sajani6609 9 หลายเดือนก่อน +1

      Yes thank you!

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

    Awesome voice, I guess you must be full time singer

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

    To the point !!!🔥🔥

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

    WHAT AVERY NICE AND CLEAR PRESENTETION KEEP IT UP!!!!!!!

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

    Thankyou Mam ....This helped me a lot...

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

    Thank you. I love that you do it on papaer. That's my way of getting in everything.

  • @SM-hw3yi
    @SM-hw3yi ปีที่แล้ว +1

    Explained in simple and beautiful way. Thanks

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

    Hey thanks for sharing and your efforts, well explained. You're awesome 👏😁

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

    These situation based queries are a great way to learn faster , please make a Long video or comple your other in one...thanks

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

    Good tutorial. Please keep making these beautiful Tutorials.

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

    excellent miss, and im sure about to follow your all videos and please keep going on.....

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

    Concepts explained with such simplicity & sweet voice

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

    Great work 😅 Simple and sorted 👌

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

    Am beginning to learn SQL, I can't wait to master it.

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

    Sissy it's just amazing and usefull.

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

    Thanks for helping me.. Tomorrow is my offline practical exam, i am searching for this from morning i cant but in this video i was cleared about it.. Thanks a lot.. And by the way your voice is so sweet😌❤

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

    Howww she is explaining over paper. To be honest it's more understandable than most of the channel who is on PC. Loved your channel ♥️

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

    Perfect and easy to understand 👌

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

    Thanks a lot for all of your videos..helped me a lot. Best wishes to you. And keep making videos.

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

    Nice explanation.very helpful.easily understanding.

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

    Absolutely brilliant. I would like to see more query.

  • @AdityaKumar-jy7zc
    @AdityaKumar-jy7zc 3 ปีที่แล้ว

    I like the way you teach.
    I have one confusion?
    structure of the table is retained in Truncate or in delete?

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

    Hi sister,
    Thanks for your videos..it helped me to land SQL developer job..

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

    Nice explanation......TQ for sharing the knowledge

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

    such a nice quick video , tq so much

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

    Thank you so much ...please make more videos on SQL interview questions

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

    Amazing explanation easy to understand tq u for making easy👍🏻👌🏻👏

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

    Very good saadhiya

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

    Thanks mam for explaining it in a simple manner.

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

    Great explanation with beautiful voice

  • @khushbooshivhare5530
    @khushbooshivhare5530 4 ปีที่แล้ว +5

    Thank you so much, this 5 min video idea is very helpful

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

    Very concise and explicit

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

    Thank you a lot for your efforts , and greeting from Morocco 🇲🇦❤

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

    in this video if you show the table also, then it becomes very easy to understand for beginners

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

    Keep us the good work mam, very helpful, can u plz tell, name starting with a should be capital letter how can we do, or small letter, where should we put upper and lower

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

    Sister can we use at a time comparison and logical statements in the syntax. What is the syntax format please tell me

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

    Nice voice and good explanation ❤️

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

    Very helpfull. can you upload more videos on sql.

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

    Hi, in your third query, i remember somewhere in your other video you mentioned, if an 'aggregate function' is used, we can't use 'WHERE' clause rather 'HAVING' clause is to be used, however you have used COUNT with WHERE, kindly enlighten me, Thanks in advance

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

      Please watch my latest video on WHERE VS HAVING IN SQL
      you’ll understand it properly

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

    mesmerizing voice and to the point video

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

    Hi i really like the way you solved the queries
    .As of now i get ol the solution of this video.. Could you please taught me personally for my interview..

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

    Very helpful thank you ma'am 😀

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

    Bhut acha pda rhe ho mam. Thnku.

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

    please give us some lecture on How to get odd and even number from the given table, thank you so much

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

    Aapki writing meri tarha hai :D
    Good content and explanation btw.
    I am a working professional.

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

    i am glad i found this......thankyou verymuch

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

    Nicely explained video tqu😊

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

    Very well explained .... thank you mam ...

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

    Thank you.. Helpful video 🙌

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

    That was very helpful thank you

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

    Voice is so cute 🤩

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

    I realy like ur voice and ur knowledge.

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

    Perfect 👌

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

    Nice explanation with a beautiful voice

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

    its Really Helpful.thank u mam

  • @billhaqshaik563
    @billhaqshaik563 3 หลายเดือนก่อน

    Thanks for your SQL query explanation sister 👍

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

    Thank you maam! Very easy to understand

  • @user-cf8oi4hh2p
    @user-cf8oi4hh2p 3 หลายเดือนก่อน +1

    My Exam is there and i was having much doubts in my sql. 😢Thankyou for clarifying my doubts 😊🎉

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

    precise explanation

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

    Nice, please put more videos

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

    Nice explanation 👏, your new Subscriber 🎉

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

    Great explanation thank you!!

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

    You explain in that way like if anyone didn't know about SQL then also he can understand and get the idea about what is happening and how the queries are written👌👌 thank-you soo much

  • @VikramSingh-fl4qe
    @VikramSingh-fl4qe 3 ปีที่แล้ว

    Amazing Thanks for the information

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

    Great video!

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

    4th one - select *from employees where firstname like '%A' and len(Firstname)=6
    I think this should also work

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

      Yes, as long as you're using the right reserved words like "length" vs "len". I think of "len" when using almost all other languages.

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

    Well explained sis 👏👏👏

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

    The voice 😍

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

    So easy to understand

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

    Nice explaination ma'am*

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

    Thank you and keep it up 👍🏼

  • @sunilSunil-lm5ck
    @sunilSunil-lm5ck 6 หลายเดือนก่อน

    We can also use another method
    Select salary +5% as increment from employee

  • @kttvenkat
    @kttvenkat 6 หลายเดือนก่อน

    Thank you..Easy way to understand 😊

  • @EE-pw1hf
    @EE-pw1hf 3 ปีที่แล้ว

    Would print in question 4 and 5 mean you should use returning?