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

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ธ.ค. 2024

ความคิดเห็น • 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&TH-cam
    🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?M-55BmjOuXY&Comments&TH-cam
    🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?M-55BmjOuXY&Comments&TH-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.

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

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

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

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

    Thanks so much for the tutorial, learnt alot..

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

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

    Really appreciate the tutorial for making it short and simple,

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

    simple easy to understand and well made .thank you

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

    It's a great lecture. Thank you! 🥰

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

    Very knowledgeable session and clear concept explanation !

  • @rosisneupane
    @rosisneupane 5 หลายเดือนก่อน +2

    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?

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

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

    Thank you for the wonderful video!🤞

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

    Amazing content with superb explanation

  • @HimanshuGupta-jx4nk
    @HimanshuGupta-jx4nk 3 ปีที่แล้ว +1

    Thanks & long live youtubers

  • @AkramKhan-ei5gx
    @AkramKhan-ei5gx ปีที่แล้ว

    Amazing video sir thankyou for this video

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

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

  • @Juan-Hdez
    @Juan-Hdez 2 ปีที่แล้ว

    Very useful. Thank you very much!

  • @JOSEPHKARYEE
    @JOSEPHKARYEE 10 หลายเดือนก่อน

    this lesson is indeed teachible

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

    Thnk yousir u clear my douts

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

    Really helpful, Thanks

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

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

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

  • @CanAytekin-p7b
    @CanAytekin-p7b ปีที่แล้ว

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

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

    Great materteral, thanks

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

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

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

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

    Hello, nyc explanation can i get the dataset ?

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

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

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

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

    Ready to learn

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    where can I find the dataset? I only see dml

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

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

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

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

    very nice

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

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

    Hi, please give the data set link

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

      Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. 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 : )

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

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

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

    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

  • @SHUBHAMJADHAV-lo5kb
    @SHUBHAMJADHAV-lo5kb 7 หลายเดือนก่อน

    Why using MySQL while title is SQL 🙄🙄🙄

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