SQL Advanced Tutorial | Advanced SQL Tutorial With Examples | SQL For Beginners | Simplilearn

Поділитися
Вставка
  • Опубліковано 7 лют 2025

КОМЕНТАРІ • 136

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

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

  • @StarContract
    @StarContract 3 роки тому +23

    Superb tutorial, thanks for not wasting time and getting straight to the points.

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

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

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

    Super vedio bro. First Time i am watching complete depts concept of advance sql query. I think this is my first advance sql vedio . tanks for giving for valuable wonderful vedio ,

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

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

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

    Really appreciate the tutorial for making it short and simple,

  • @100srecordwarehouse6
    @100srecordwarehouse6 9 місяців тому

    simple easy to understand and well made .thank you

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

    this lesson is indeed teachible

  • @narcisabarbu6560
    @narcisabarbu6560 Рік тому +6

    Check out at 11:00 the query result should list price less than 100, however it is not, can you please review and confirm?

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

    The video was amazing and on point. Thank you!

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

      We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.

  • @rosisneupane
    @rosisneupane 7 місяців тому +3

    There's no dataset in the description.
    all you've put is few commands that you are using in the video.
    where's the dataset?
    how am i supposed to practice it without dataset?
    the first line in the txt file in the link is a select statement.
    how am i going to run a select statement if i don't have the tables?

  • @AkramKhan-ei5gx
    @AkramKhan-ei5gx Рік тому

    Amazing video sir thankyou for this video

  • @karanchilwal9431
    @karanchilwal9431 3 роки тому +11

    In 'partition by' example, it was total salary by department not the highest salary of some employee in that department.

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

      Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

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

      Yeah you're correct, came to see if anyone commented this.

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

    Thnk yousir u clear my douts

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

    Thank you for the wonderful video!🤞

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

    very informative

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

      We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.

  • @tesss_tequila
    @tesss_tequila 3 роки тому +4

    Thanks so much for the tutorial, learnt alot..

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

    It's a great lecture. Thank you! 🥰

  • @HimanshuGupta-jx4nk
    @HimanshuGupta-jx4nk 3 роки тому +1

    Thanks & long live youtubers

  • @AvitaD1
    @AvitaD1 3 роки тому +4

    Very knowledgeable session and clear concept explanation !

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

    Ready to learn

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

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

  • @heroicmuffin9972
    @heroicmuffin9972 Рік тому +2

    Nice video. Would be nicer if your workbench wasn't zoomed in 300%

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

      We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. We thrive to improve with your suggestions. If you're interested in further expanding your knowledge, check out our course offerings in the description box.

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

    The video is very informative sir,the concepts are very clear ...thanks a lot!!! (P.S- please improve your typing accuracy :"))

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

  • @CanAytekin-p7b
    @CanAytekin-p7b Рік тому

    You are awesome!!! Please provide the db because the link is broken. Thanks!!

  • @bisolabankole-b9d
    @bisolabankole-b9d Рік тому +4

    Thanks for this Video. It would be nice if you added scripts to create the databases in the google drive link available in the description, as it only contains the dml syntax.
    Please look into this to enable us to practice along with you.

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

    Amazing content with superb explanation

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

    Great Video Thank You!

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

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

  • @Juan-Hdez
    @Juan-Hdez 2 роки тому

    Very useful. Thank you very much!

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

    Really helpful, Thanks

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

    Great materteral, thanks

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

    very nice

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

    Excellent explanation

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

      Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

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

    sir this total salary is highest salary or sum of the all employees salary working in same department please comment

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

    Hello, nyc explanation can i get the dataset ?

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

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

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

    Thanks for such educating tutorial
    Please send us the required dataset used in this tutorial

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

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

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

    can you please come with statistical query such us lead lag rank etc which are required for Data Analysis?

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

      Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!

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

    Should have explained all the triggers with examples.

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

      Hey ,We'll go into these implementations in detail in another video. Stay tuned!

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

    Amazing content can I have the dataset used in this video

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

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

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

    Hi!
    Thank you so much for such a powerful and explanatory video.
    Pls, how can I get the data set used for this tutorial?

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

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

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

    where can I find the dataset? I only see dml

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

    hi great tutorial, can you please send the database file, or share it in google drive

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

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

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

    Nice video! can I please get the dataset?

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

      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.

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

    Industry using advanced queries

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

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

  • @BhanuPratapSingh-fb5dq
    @BhanuPratapSingh-fb5dq 2 роки тому +1

    Hi can you please share dataset used in video

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

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

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

    Hi, could you please share the scripts for insert into table, for the tables which you are using in the database. It would be really helpful ,otherwise i have to create the tables manually.Also the file you have uploaded in description box, in that there is not insert into scripts.

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

      Thanks for the notification. We will update the required script in the description as soon as possible.

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

    Please share the database with the tables and relations created file

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

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

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

    Sir could you please share the databases which you have used in this course.

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

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

      @@SimplilearnOfficial ashitoshsingh46@gmail.com

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

      @@SimplilearnOfficial harshagupta2608@gmail.com send to me too

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

    Sir can you please provide the database you have used in this view?
    Thanks in Advance

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

      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.

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

      nishantmotghare2013@gmail.com

    • @4ushivang
      @4ushivang 3 роки тому

      @@SimplilearnOfficial shivangbelwariar1@gmail.com Can you please send all the files to this id too. Thank you

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

      Hi may i please have the dataset as well Thank you!!

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

    Hi, please give the data set link

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

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

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

    From where I can download the sql_iq database ???

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

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

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

    could you share the database?

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

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

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

    Hi Simplilearn! Can you please send me the database in a ZIP or BAK file, used in this course??

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

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

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

      @@SimplilearnOfficial There is no such data set

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

    Hi, Can you please provide the datasets over my email. Would like to keep my email hidden.

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

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

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

      @@SimplilearnOfficial Hi. There is no dataset in the link enclosed in the description. There is only a file with SQL code you perform on the video. Could you please share also Dataset to the Google Drive? Thank you in advance.

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

    how can i find the dataset?

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

      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.

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

      @@SimplilearnOfficial Hey can you please send the dataset to muzammildude@gmail.com?

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

    would you provide me files that i can practice.

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

      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.

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

      @@SimplilearnOfficial i too need data set can you send me to this email madhubala164@gmail.com

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

    Windows function is not completely clear

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

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

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

    Where is database files ?

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

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

      @@SimplilearnOfficial shaikhhaya09@gmail.com

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

    Please send me data set used in this tutorial
    Keep my email hidden please

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

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

  • @SHUBHAMJADHAV-lo5kb
    @SHUBHAMJADHAV-lo5kb 8 місяців тому

    Why using MySQL while title is SQL 🙄🙄🙄

  • @gorbeh88
    @gorbeh88 3 роки тому +15

    OMG, this guy makes too many mistakes when he is typing. It is really distracting. Thanks for the work tho

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

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

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

    SQLS not SQL

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

      Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

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

    would you provide me files that i can practice.

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

      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.

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

      @@SimplilearnOfficial please email me to cerol.dwen@gmail.com
      Thank you

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

      animeshbonny@gmail.com, thanks in advance.