SQL Interview Questions And Answers | SQL Interview Preparation | SQL Training | Simplilearn

Поділитися
Вставка
  • Опубліковано 27 лис 2024

КОМЕНТАРІ • 72

  • @SimplilearnOfficial
    @SimplilearnOfficial  Рік тому +1

    🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?L-URbfgxBMQ&Comments&UA-cam
    🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?L-URbfgxBMQ&Comments&UA-cam
    🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?L-URbfgxBMQ&Comments&UA-cam
    🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?L-URbfgxBMQ&Comments&UA-cam

  • @madhupincha7898
    @madhupincha7898 2 роки тому +15

    Always prefer simplilearn over other courses because of the way of teaching, simplicity and representation.
    Highly recommended ❤️

  • @sachinpujari63
    @sachinpujari63 Рік тому +1

    Thank You Sir. Your Explanatio is superb....

    • @SimplilearnOfficial
      @SimplilearnOfficial  Рік тому

      Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.

  • @unnatijaswani4832
    @unnatijaswani4832 2 роки тому +16

    For the query with 2 a's in each name cant we just give e_name like '%a%a%' ?

  • @manojkumar-hx4sm
    @manojkumar-hx4sm 3 роки тому +1

    This is very use full for all SQL learner !
    Thanks !

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

      Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!

  • @hemanthg5760
    @hemanthg5760 2 роки тому +1

    Thanks ...its really helps me a lot

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому

      We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!

  • @saadiyashaik4557
    @saadiyashaik4557 3 роки тому +5

    This channel is very underrated it's very useful 🙂🙂

  • @vaijayantigulve4883
    @vaijayantigulve4883 Рік тому

    Very very helpful.

    • @SimplilearnOfficial
      @SimplilearnOfficial  Рік тому

      We're so glad that you enjoyed your time learning with us! If you're interested in continuing your education and developing new skills, take a look at our course offerings in the description box. We're confident that you'll find something that piques your interest!

  • @shivenduvimal6784
    @shivenduvimal6784 Рік тому

    Select name from employees where name like '%A%A%' ; for question number 14

  • @snowguo1786
    @snowguo1786 2 роки тому +1

    Thank you!

  • @loganathanm6772
    @loganathanm6772 2 роки тому

    Thank you, you have explained it so nicely.....

  • @harishbabu8819
    @harishbabu8819 2 роки тому +1

    nice explanation

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

    Thanks for the video!

  • @c.d.premkumar6867
    @c.d.premkumar6867 3 роки тому +1

    EXCELLENT !

  • @LV-ni6tf
    @LV-ni6tf 3 роки тому +1

    Really nice explaining some where very well some where not understanding y u write extra clauses but good. If Hv share data set.

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

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

  • @unnatijaswani4832
    @unnatijaswani4832 2 роки тому +1

    Awesome video must say! 👍

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

    Very useful video. Thank you so much

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

      Glad it was helpful!

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

      Hello, thank you for watching our video. We are glad that you liked our video. Do subscribe and stay connected with us. Cheers :)

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

    Thanks, man! It is really helpful!

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

      Glad you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!

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

    Thanks for sharing!

  • @unnatijaswani4832
    @unnatijaswani4832 2 роки тому +2

    For query no 20, it did not ask u to add 10 or 20 to no, it said if n_id is 0, then n_id=10, elseif n_id=1, then n_id=20. Pls chk it once again.

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

    Thank you....you have explained it so nicely through out the video.. and one more request can you please share the dataset.

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

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

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

    Nice 👍👍👍❤️❤️

  • @shivarajnavalba5042
    @shivarajnavalba5042 2 роки тому

    that's really helpful thanks!😇

  • @muhammadsaaduddin674
    @muhammadsaaduddin674 2 роки тому +1

    Can you make a video or provide us real life database problems, and queries in the workplace??

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому +1

      Stick around as we have a tutorial on the same coming up soon.

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

    Thank you

  • @camjthompson12
    @camjthompson12 2 роки тому +1

    Great video but the data set in the link is different from the video. For example my employees table doesn't have an gender, Doj, dept or city column

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому

      Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better

  • @JATINKUMAR-qu4vi
    @JATINKUMAR-qu4vi 2 роки тому +1

    👍👍

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому

      Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )

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

    Nice job! Could you please share your data set

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

      Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.

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

      @@SimplilearnOfficial its razken@yahoo.com, thanks

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

      @@SimplilearnOfficial Thanks for the data set, highly appreciate

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

      @@SimplilearnOfficial Hi, your video really helps me to prepare for my interview. can I please also have the dataset?

  • @dddr5585
    @dddr5585 2 роки тому +1

    did the dataset get removed? because its not the same as the video?

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

  • @fequalsma42
    @fequalsma42 2 роки тому +1

    Could question 10 also be written with an OR statement and get the same result? (It was my first instinct so I just want to see if it's accurate as well)-
    Thx for the video! Cheers

  • @Flame_2314
    @Flame_2314 2 роки тому +1

    can u provide us ppt. or pdf of this video ?

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому +1

      We don't have any pdf of this particular video. For slides, you can check out our slideshare profile: www.slideshare.net/Simplilearn"

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

    Sir during import the SQL file you given in the description I got error:
    At line 50: incorrect parameter count in the call to native function instr
    What can I do now sir?

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

      "Hi ,
      The INSTR() function returns the position of the first occurrence of a substring within a string. Please make sure you pass the substring that you are searching for along with the original string."

  • @shamimishaari43
    @shamimishaari43 2 роки тому +1

    hi, can you share me the dataset?

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

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

    Can you share the SQL code file?

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

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

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

    Can u tell me from where I can practice more about these other than hackerrank?

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

      "Hi ,
      You can check out SQL Bolt and SQLZoo to practice SQL interview questions."

  • @ayaalkasrawi826
    @ayaalkasrawi826 2 роки тому

    Can you please share the dataset file?

    • @SimplilearnOfficial
      @SimplilearnOfficial  2 роки тому

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.