SQL Interview Question and Answers | Optimize/Fine Tuning Queries | SQL Best Practices | Code Decode

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

КОМЕНТАРІ • 88

  • @shreeram_kulkarni
    @shreeram_kulkarni 2 роки тому +10

    Great kickstarter for devs who don't want spend unnecessary time on the web. Straight to the point. You guys have to continue with this series. It's a request. Thanks alot !

    • @CodeDecode
      @CodeDecode  2 роки тому +4

      That's a rare comment we find now a days. People are more like let's just code leaving performance, fine tune as secondary thing. Good too see still few developers focus on performance improvement ways 🙂👍

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

    What a compilation! You are doing great job! Keep it up!

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

      Thanks Mitul. M glad u understand the usefulness of best practices n performance. Rarely people pay heed to these concepts 👍👍

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

    Very informative video, the performance improvement of an API timing is one of the biggest challenge for a backend developer. Thank you for sharing this knowledge 🙏

  • @vikasbhardwaj1502
    @vikasbhardwaj1502 3 місяці тому

    best and concise i encouraged you to finish what you have started .its really helpful we always to try find solution for bigger problem and forgot about small things can also make impact

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

    Please continue this series. Even I have the idea of SQL but there are some good concept that I was not aware of it.

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

      M glad you understood depth of the video 🙂👍Thanks Anant 🙂👍

  • @sankeerthpulyala4225
    @sankeerthpulyala4225 3 роки тому +6

    The way you explain the concepts was amazing & crystal clear ..
    Could you Please make vedios on how to write junit test cases

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

      Thanks Sankeerth. Sure we will upload video on junits soon. 👍🙂

  • @nancysingh2056
    @nancysingh2056 4 місяці тому

    Please continue this series it will help million's of developers .Thanks

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

    Please yeeees, create a second part of it ASAP, ur explaining things in a very veryyy crystal clear manner, thank u alot

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

      Thanks Selim. M glad u understood the importance of best practices and performance while coding. It means you not just code and write queries, you also try to write it efficiently . Good job 👍 I can see many people just running behind writing query and getting the work done. Good to see you are not one of them!!! Good job 👍👍👏👏

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

      @@CodeDecode Thank u very much, i do really care about best practices, especially when working with companies... u know, resources are not quite alot talking about these important concept, but ur r doing suchhhh GREAT job!! im learning from u and thank u very veryy much

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

      M glad Selim. Great going👍👍keep learning keep shining ⭐✨⭐✨

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

    It was very much needed
    Tomorrow I'm going to have a small discussion with Oracle (probably pre interview)
    This might help

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

      All the very best Parul 🙂👍 keep learning keep growing 🙂

  • @kiranchoudhary8475
    @kiranchoudhary8475 3 роки тому +3

    This is so informative.. SO MUCH.. Please do make a part 2. Would love to know the rest of the points as well 🙂

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

      Glad to see your comment Kiran. Our trust remains intact with such comments that people still believe in good performance code base rather than just scribbling around
      Thanks Kiran 🙂👍

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

    Pls create rest of question also in separate video...... Your videos are very useful thanks for sharing your knowledge..... We are waiting for you next video 😊

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

      sure sarada we will create it soon

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

    You have done magic again with your explanation 👌👌..keep posting more videos..

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

      Thanks Ravindra 🙂👍

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

    Thank you so much for sharing this video. Please share the second part also. Really helpful for interview preperations.

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

      Sure Shiksha. We will do that 🙂👍

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

      is the second part out. please share the link

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

    Great efforts team, keep up the good work , explaining the things never be the easy task, you guys are making it in a best possible way, Hope to see more videos from you..! , As well as with part - 2

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

      Thanks veera 👍👍 sure we will upload soon 👍👍

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

    Thank you so much for this video. It would be appreciated if you can make a video on stored procedures and the interview questions on them!.

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

    Thank you once again salute to your job, very helpful great learning from all videos please make next part of SQL

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

      Thanks for the nice words and we will create it soon

  • @niteshdewan1812
    @niteshdewan1812 8 місяців тому +1

    Need more sql videos
    Thanks a alot for these type of videos.

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

    Thankyou for sharing this. It helped a lot. Please create the second part of this.

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

    Very good tutorial, please upload next part and have a detailed discussion of cursors and other advance topics . Thank you

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

      Thanks Akash 🙂👍 sure we will do that

  • @crazeeealgorithms3236
    @crazeeealgorithms3236 6 місяців тому

    Please continue this series Thank You.

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

    Great hard work, Please create next parts, its really useful...

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

    Thanks good stuff... Hope part 2 comes soon.

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

    This content is very good. Please create second part of it.

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

      sure joseph we will create it soon

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

    Thank you so much for making such kind of video's keep it up and I am waiting for your next part

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

    Maa'm thanks for creating informative videos. You are giving very relevant information in a short time. Please do create second video to cover all the topics

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

      Sure Pragati. Good to see your comment on such videos 🙂👍

  • @Priyankapatel-zm2vq
    @Priyankapatel-zm2vq 7 місяців тому +1

    Need more SQL video for preparation of interview 4+ experience

    • @CodeDecode
      @CodeDecode  7 місяців тому

      Sure we will upload it soon

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

    Ma'am your work awesome ❤️

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

    Nice informative tutorial. Thank you!

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

      Thanks Vengatesh 🙂👍

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

    Kindly make the 2nd part. Would be of great help to everyone

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

      Sure we will do that Abhishek 🙂👍

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

    Very Easy to understand...I wonder how these easy concepts I was not able to understand these many days...
    Thanks for the Videos. I am an active follower of your channel... Keep posting videos on the next part of SQL concepts and tips..

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

      Yeah these are simple stuff if understood properly.
      Thanks a lot. 🙂🙂👍

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

    fantastic video please upload the next video that would be helpful.🙂

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

    Thanks for explanation, please create part 2

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

    Really great video please make more videos

  • @siddharthshinde9630
    @siddharthshinde9630 3 роки тому +3

    Thanks a lot for your dedication towards making this easy to understand.Please upload the second video as well eagerly waiting 👏👏

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

      Sure Siddharth, we will upload next part soon🙂👍

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

    Very nice but not complete without second part. Not able to find next video.. plz share link here for second part.

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

    Very nice

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

    Please create video on most asked sql queries in interviews

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

      Ok Amit we will exclude best practises in sql and will include only interview questions 👍

  • @ParthPandey-vl3wj
    @ParthPandey-vl3wj Рік тому +1

    Performing joins is also a Cartesian product in itself

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

    Please do make a part 2.

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

    Pls do create second part of this video.

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

    Please create more videos on SQL

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

      sure chetan we will create more

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

    next part please 🙂

  • @amitthakur-yo6xw
    @amitthakur-yo6xw 3 роки тому +1

    Thanks

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

    Pls cover.. Thanks😊

  • @ManvendraSingh-xh2ry
    @ManvendraSingh-xh2ry 2 роки тому +1

    where is the next video ???????Cant find :(

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

    Please create next video in it

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

      Sure Deepali. We will do that 🙂👍