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

Sdílet
Vložit
  • čas přidán 5. 09. 2024

Komentáře • 137

  • @SimplilearnOfficial
    @SimplilearnOfficial  Před rokem +1

    🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-analytics-certification-training-course?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
    🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-professional-certificate-course-data-analytics?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
    🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-analytics-bootcamp?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
    🔥Data Analyst Masters Program (Discount Code - YTBE15): www.simplilearn.com/data-analyst-masters-certification-training-course?SQlAdvancedTutorial-M-55BmjOuXY&Comments&

  • @StarContract
    @StarContract Před 2 lety +22

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety +1

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

  • @narcisabarbu6560
    @narcisabarbu6560 Před rokem +7

    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 Před 2 lety +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  Před 2 lety

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

  • @karanchilwal9431
    @karanchilwal9431 Před 2 lety +10

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety +1

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

    • @Skk572sk
      @Skk572sk Před 2 lety +2

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

  • @praweengupta6272
    @praweengupta6272 Před rokem +1

    Really appreciate the tutorial for making it short and simple,

  • @100srecordwarehouse6
    @100srecordwarehouse6 Před 4 měsíci

    simple easy to understand and well made .thank you

  • @prachibehl270
    @prachibehl270 Před rokem +1

    The video was amazing and on point. Thank you!

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před rokem

      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.

  • @yoshidasan4780
    @yoshidasan4780 Před rokem +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před rokem

      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.

  • @heroicmuffin9972
    @heroicmuffin9972 Před rokem +2

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před rokem

      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.

  • @tesss_tequila
    @tesss_tequila Před 2 lety +4

    Thanks so much for the tutorial, learnt alot..

  • @user-gr5pl5sh8m
    @user-gr5pl5sh8m Před rokem +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.

  • @AvitaD1
    @AvitaD1 Před 3 lety +4

    Very knowledgeable session and clear concept explanation !

  • @BlazeVibeGaming
    @BlazeVibeGaming Před 2 lety +1

    Thnk yousir u clear my douts

  • @SQL
    @SQL Před 2 lety +1

    It's a great lecture. Thank you! 🥰

  • @user-iq5zg4hd6r
    @user-iq5zg4hd6r Před rokem

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

  • @vyshnaviyoj8802
    @vyshnaviyoj8802 Před rokem

    Thank you for the wonderful video!🤞

  • @JOSEPHKARYEE
    @JOSEPHKARYEE Před 7 měsíci

    this lesson is indeed teachible

  • @AkramKhan-ei5gx
    @AkramKhan-ei5gx Před 11 měsíci

    Amazing video sir thankyou for this video

  • @saqlainshaikh5483
    @saqlainshaikh5483 Před 3 lety +2

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

      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!

  • @HimanshuGupta-jx4nk
    @HimanshuGupta-jx4nk Před 3 lety +1

    Thanks & long live youtubers

  • @janetikuenobe1505
    @janetikuenobe1505 Před 2 lety +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  Před 2 lety +1

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

  • @hibasyed7646
    @hibasyed7646 Před 2 lety +1

    Amazing content with superb explanation

  • @Juan-Hdez
    @Juan-Hdez Před 2 lety

    Very useful. Thank you very much!

  • @ritikabali6466
    @ritikabali6466 Před rokem +1

    very informative

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před rokem

      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 Před 2 lety +2

    Ready to learn

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @rosisneupane
    @rosisneupane Před 2 měsíci

    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?

  • @deandassa9228
    @deandassa9228 Před 2 lety +1

    Great Video Thank You!

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @sashikiran2991
    @sashikiran2991 Před 2 lety +1

    Should have explained all the triggers with examples.

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @shivashreerajasekaran503
    @shivashreerajasekaran503 Před 3 lety +1

    Really helpful, Thanks

  • @anurodhkumar792
    @anurodhkumar792 Před 11 měsíci

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

  • @chernormajujalloh9680
    @chernormajujalloh9680 Před 2 lety

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @lingxu9697
    @lingxu9697 Před 3 lety +1

    Great materteral, thanks

  • @shubhammaini3921
    @shubhammaini3921 Před 2 lety +1

    Hello, nyc explanation can i get the dataset ?

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @senthilmuruganr234
    @senthilmuruganr234 Před 3 lety

    Excellent explanation

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

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

  • @dindidandi5615
    @dindidandi5615 Před 2 lety +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @krishanukundu4089
    @krishanukundu4089 Před 2 lety +1

    Please share the database with the tables and relations created file

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @BhanuPratapSingh-fb5dq
    @BhanuPratapSingh-fb5dq Před 2 lety +1

    Hi can you please share dataset used in video

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @apurva2278
    @apurva2278 Před 2 lety

    Amazing content can I have the dataset used in this video

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @vinaypahelani6456
    @vinaypahelani6456 Před 2 lety +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  Před 2 lety

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

  • @ridohconcepts8868
    @ridohconcepts8868 Před 3 lety +1

    Nice video! can I please get the dataset?

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

      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.

  • @priteshnarkhede5460
    @priteshnarkhede5460 Před 2 lety +2

    From where I can download the sql_iq database ???

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @ashleyruygrok9610
    @ashleyruygrok9610 Před rokem

    where can I find the dataset? I only see dml

  • @pveeranjireddy8959
    @pveeranjireddy8959 Před 3 lety

    Industry using advanced queries

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety +1

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

  • @nishantm1924
    @nishantm1924 Před 3 lety +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

      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 Před 3 lety

      nishantmotghare2013@gmail.com

    • @4ushivang
      @4ushivang Před 3 lety

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

    • @hitiknegi6808
      @hitiknegi6808 Před 2 lety

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

  • @sachinsarange2282
    @sachinsarange2282 Před 3 lety +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety +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 Před 3 lety

      @@SimplilearnOfficial ashitoshsingh46@gmail.com

    • @harshagupta1546
      @harshagupta1546 Před 3 lety

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

  • @anmolsrivastav7103
    @anmolsrivastav7103 Před rokem

    very nice

  • @sirikilohit2077
    @sirikilohit2077 Před 3 lety +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

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

    • @vladimirputin7443
      @vladimirputin7443 Před 2 lety +1

      @@SimplilearnOfficial There is no such data set

  • @googlehead1143
    @googlehead1143 Před 3 lety +2

    would you provide me files that i can practice.

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

      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 Před 3 lety

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

  • @aditig1654
    @aditig1654 Před 3 lety +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

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

    • @kseniabieliakova690
      @kseniabieliakova690 Před 3 lety +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.

  • @raaghaviravisankar1853
    @raaghaviravisankar1853 Před 3 lety +1

    could you share the database?

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety +1

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

  • @swetasuman98
    @swetasuman98 Před 3 lety +1

    Windows function is not completely clear

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

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

  • @chirantanlonkar8188
    @chirantanlonkar8188 Před 2 lety

    Hi, please give the data set link

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @SHUBHAMJADHAV-lo5kb
    @SHUBHAMJADHAV-lo5kb Před 3 měsíci

    Why using MySQL while title is SQL 🙄🙄🙄

  • @prbi2780
    @prbi2780 Před 3 lety

    how can i find the dataset?

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

      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 Před 3 lety

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

  • @snaziruddin
    @snaziruddin Před 3 lety +1

    Where is database files ?

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety +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 Před 3 lety

      @@SimplilearnOfficial shaikhhaya09@gmail.com

  • @chernormajujalloh9680
    @chernormajujalloh9680 Před 2 lety +1

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 2 lety

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

  • @FreshBitesKitchen_official

    SQLS not SQL

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

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

  • @gorbeh88
    @gorbeh88 Před 3 lety +12

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

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety +9

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

  • @user-nb8vr5qj4l
    @user-nb8vr5qj4l Před měsícem

    can u share sql_intro dataset the same which is used in the video ?
    @SimplilearnOfficial

  • @muhammadkhuzain8826
    @muhammadkhuzain8826 Před 3 lety +1

    would you provide me files that i can practice.

    • @SimplilearnOfficial
      @SimplilearnOfficial  Před 3 lety

      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 Před 3 lety

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

    • @animeshkumar1060
      @animeshkumar1060 Před 3 lety

      animeshbonny@gmail.com, thanks in advance.