SQL Basics for people with no prior knowledge 🤷‍♀️🤷‍♂️

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

КОМЕНТАРІ • 334

  • @chandoo_
    @chandoo_  2 роки тому +24

    💥💥💥 The Detailed SQL video is now LIVE!!! Check it out here 👉 ua-cam.com/video/l8DCPaHc5TQ/v-deo.html

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

      What count(*) indicates.
      I am a beginner in SQL . Can anyone please reply

    • @Vinaykumar-yb7cd
      @Vinaykumar-yb7cd Рік тому

      @@tbjapbtu10 astrisk or simple denoted as (*) means everything in the dataset, basically, count(*) results in counts all the information/ data in the given set based on the given condition.

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

      @@Vinaykumar-yb7cd thank you so much

  • @HananelGez
    @HananelGez Рік тому +48

    WOW! Finally someone explains SQL in a way that humans can understand it!!!! Thank you so much!!!!!

    • @chandoo_
      @chandoo_  Рік тому +4

      Glad it was helpful!

  • @anitaaigbomodion506
    @anitaaigbomodion506 Місяць тому +6

    I've been struggling with understanding the basis of SQL for the past two weeks. This is the only video I watched that helped me understand. I wrote down a lot too. Thank you so much.

  • @gameon550
    @gameon550 2 роки тому +17

    this is one of the best introductions I have ever seen for SQL , thank you

  • @nwosulucy8889
    @nwosulucy8889 Рік тому +7

    I must say you are the best tutor ever. You always create ways of simplifying your teaching. Thank you for all you do.

  • @kjot73
    @kjot73 Рік тому +5

    Chandoo sir you're a genius. I went thru your SQL courses and I feel so confident. Thank you for making it so simple. 😇

  • @vijayarjunwadkar
    @vijayarjunwadkar 2 роки тому +32

    Very innovative way to teach "SQL"! Thank you Chandoo, you always succeed with a surprise approach to teach concepts! Keep them coming! 🙂

    • @chandoo_
      @chandoo_  2 роки тому +6

      Thanks Vijay. SQL was the most requested topic by our viewers. I wanted to make something special and easy to comprehend. Looks like it worked 😀

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

      @@chandoo_ Sure it did!

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

      ​@chandoo_ surely it worked for me and you managed to demystify the discomfort in me towards SQL

  • @ShahnawazKhan-xl6ij
    @ShahnawazKhan-xl6ij 2 роки тому +1

    Honestly speaking I haven't seen like this informative video in such simply manner.

  • @PoojaGupta-om1pv
    @PoojaGupta-om1pv 2 роки тому +96

    can't thank you enough ❤️❤️❤️❤️ but chandoo can you please take into consideration how SQL & tableau or power bi work together and how cleaning and exception are made in dashboard.

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

      Even this question ruined everytime in my mind .. chandoo sir please loook after it .

    • @chandoo_
      @chandoo_  2 роки тому +38

      Good suggestion Pooja. I will add this to my list of videos. Stay tuned.

    • @PoojaGupta-om1pv
      @PoojaGupta-om1pv 2 роки тому +1

      @@chandoo_ Thank you so much sir 😊

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

      @@chandoo_ I also need it .
      Thanx in advance .

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

      Please do this video

  • @sasha1364
    @sasha1364 2 роки тому +9

    Thanks alot sir!!🙏 I have attended many other videos of SQL but the way you explain the concepts in such a simplified and interactive manner is outstanding 😀😀😀 Keenly waiting for the advance SQL videos 😀

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

    I remember studying this for my comp science undergrad.. never took real interest in it.. but now i do research and deal with millions of rows of data.. thinking maybe SQL will be my best friend... Thank you for an excellent explanation

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

      I learned SQL back in 1997. Can't believe it has been 25 years. But I use it every few months (more so in the last 5 years).

  • @JunaidKhan-gq8nw
    @JunaidKhan-gq8nw 2 роки тому

    my Respected Teacher, l Like Him and Love Him. He has a unique and most simple way of teaching. my all best wishes with Him.

  • @bandasainath8041
    @bandasainath8041 2 роки тому +5

    Really amazing way of explaining the concepts. Thank you sir. I would love for more videos on SQL

    • @JunaidKhan-gq8nw
      @JunaidKhan-gq8nw 2 роки тому

      thanks, you convey my message to Sir Chandoo in simple words. again thanks

  • @NINJA-yr6li
    @NINJA-yr6li 2 місяці тому +2

    u know what not knowing basics means thanku so much

  • @nicktobies
    @nicktobies 11 місяців тому

    Teaching can be fun and simple for learners..the best tutorial for 2023 . Thank you.

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

    Maaaan, such a unique way for explanation! Great job!

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

    Outstanding Chando Sir!! The way you explain the concept is really amazing. Eargly waiting for the next SQL Video.. Kindly Include Window Function and Subqueries also it will be very much helpful for all of us. The way you explain the concept is crystal clear it will help us to understand the complex topic in a simple way 👏.
    Thank you sir.!

    • @chandoo_
      @chandoo_  2 роки тому +7

      Thanks Aman. In my next video, I talk about real-world scenarios and get in to intermediate level stuff. I may talk about subqueries and windows in subsequent videos if there is enough interest.

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

      @@chandoo_ yes please!!! I am interested in it. Thank you for creating these videos, sir. This stuff is GOLD :)

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

    This is the best and simplest tutorial I have seen.Very beginner friendly

  • @vishalchakravarty3424
    @vishalchakravarty3424 2 роки тому +7

    My prayers have been answered, chandoo finally doing it SQL

  • @successfulvictorypublisher6090

    SUPERB illustrations! So very easy-peasy to VISUALIZE instantaneously!! Way to go Sir!!!

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

    Thank god SQL from your teaching style now my all doubt will be cleared. I am waiting for your complete video.

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

    Consistently outstanding videos. The content, pace,and the tone are pitch perfect for learning. Thanks. I am new and now a big fan.

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

    Very innovative way to teach "SQL"! Thank you!!!!

  • @abdulsami1450
    @abdulsami1450 27 днів тому

    Chandoo your way of teaching regarding data analytics is superb Big love from Pak

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

    I have udemy access by organization..but i have never seen suck a learning like you chandoo..good work and may god bless you..from 1 month i am scrolling your videos and now i dont need any udemy or learning platform
    Thankful

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

    OMG what way to execute the concept in innovative manner...Also make video on SQL Main Topic for Data Analyst...
    GBU From India ....Could you please make playlist of SQL

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

    Brilliant Explanation Chandoo!!! Congratz for this wonderful channel!!!

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

    what an wonderful strategy --- i wish every lesson or teacher use this visualize method with color ...it stuck stiff in my memory !! Thanks - a zillion !!

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

    You have a very Innovative mind,. Please do it more. Thanks for your teaching 💗

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

    It's a good lecture~ Thank you! 🥰

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

    I learned the SQL fundamentals & still found this video useful. Thank you, Chandoo, for always teaching!

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

    Sir, Non Tech Background guy also learn by Enjoying, Teaching skills is simply amazing sir,
    Keep making More videos

  • @kazmir_
    @kazmir_ 2 роки тому +5

    Love when there's visual learning mixed with detailed information also, ty sir

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

    Love the use of Lego - really makes the concept clear!

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

    Sir your ideas are mind-blowing. I believe teaching expertise is in your DNA, probably you would have a self-motivated teacher in your parents.

  • @keniawoniyi8486
    @keniawoniyi8486 11 місяців тому

    Very simple to understand explanation. Thank you for this!

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

    very simple and easy to understand SQL for Data People. please make videos like this.

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

    The most perfect introduction to SQL, as the title says.

  • @HaileysHomes-ix5yu
    @HaileysHomes-ix5yu 3 місяці тому

    You are literally the best on youtube, thank you so much.🙏

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

    Thank you so much for creating this channel and for preparing helpful videos. Your explanation is very clear and easy to understand. May you have more subscribers 🙏

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

    Great work you are doing for humanity. God bless you loads

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

    Your teaching man is just 💪💪💪. Thank you.

  • @cynthiahoz3948
    @cynthiahoz3948 2 роки тому +5

    Greetings Chandoo,
    I am currently learning SQL. Thank you for this rudimentary intro to SQL as it is so beneficial to visualize the physical data with the syntax for learning. I will be eagerly awaiting the next SQL training😊

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

      You are welcome Cynthia.

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

      What softwares are you using to practice SQL?

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

      Which one is better SQL server/Oracle

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

    Sir , I enjoy your video during the learning.. you teach best way

  • @concon264
    @concon264 10 місяців тому

    Great work Chandoo! Love the no BS approach and the visualisation with lego works really well!

  • @sanskarsharma5732
    @sanskarsharma5732 9 місяців тому +1

    Absolutely Amazing explanation sir.. Now these Basic Concepts of SQL is in my Veins. Thankyou so much sir🤗😍❤

    • @chandoo_
      @chandoo_  9 місяців тому +1

      Glad to hear that

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

    Please make more vedios on sql, the way you explained is just🔥🔥🔥🔥

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

    Explanation is very helpful to understand concepts thank you sir.....👌👌👍

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

    Relly your explanation is good and understandable difference from others ❤

  • @roymusic565
    @roymusic565 8 місяців тому

    Really Awesome. I understand this very well and it's like playing a game with any Data set.
    The way of explaining with an example like this and it is more effective. Thanks Chandoo...👌👌👌👌👌

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

    Very out of the box demonstration! I'm a big fan of your videos. 😊🤗👍

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

    Thanks sir! Looking forward for more learning 🙂 ee video baagundhi

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

    ❤❤❤❤❤ I dont know sequel 😎 im not a IT guy though, but one who works in excel data day in day out.😊 Appreciate It 👍 you are awesome makes me "Think Big" ❤😊👍

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

    He is the beast in Explaining stuff 🔥🔥 🙏

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

    This is amazing or awesome youtube channel for computer science and technology or coding language or programming language 🙏🙏 I also want to started teeching about this topic. Nobody don't miss any video from chandoo channel

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

    Your analogy was refreshing and understandable for a beginner like me.

  • @ashmitasharma5879
    @ashmitasharma5879 6 місяців тому +1

    Hey....... You're just amazing with the understanding and i thabk you soo soo soo much.......... Thabk you for teaching in a great manner ❤❤❤❤.........we all who see this video are greatful to you greatness 🎉🎉🎉🎉🎉 thank you again.

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

      You're very welcome!

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

    a masterpiece of explaining and learning !

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

    Edhey kadha anna maku kavalsindhi .. ❤️ waiting for upcoming video of SQL anna

  • @Prabhakaran-hp1to
    @Prabhakaran-hp1to 2 роки тому

    Thank you so much the way you explaining us with great example and Ideas.

  • @MxStory-ge4fk
    @MxStory-ge4fk 7 днів тому

    Sir i really like your way of learning.. it would be great help if you post a series of detailed sql as u do for Excel.. thank you.

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

    Best tutor ever!! ❤

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

    As a final level student of CMA, I want to be a financial analyst, but I was finding this types video from where I can learn as I want. really sir your technique is outstanding. god bless you

  • @anuradhabalasubramanian9845

    Very innovative Sir.Hats Off to you !

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

    Thanks for this truly visual video. I meant that the way you explained is very easy to remember the SQL statements...

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

    @Chandoo how you are so much capable to teach us like that. I really inspire with your teaching style.

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

    Very nice introduction about SQL sir,
    We are waiting for more SQL vidoes in same simplest way
    Thanks in advance

  • @stluke324
    @stluke324 11 місяців тому

    This is an amazing teaching technique

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

    Very nice idea to teach.. You are a great teacher

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

    I like the way you explain things with live eg. and also I agree with pooja gupta.

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

    Interesting way to teach SQL!!

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

    Thank you Chandoo, I'm currently learning SQL, I've enabled the notifications for more beginner videos :)

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

    Chala Baga use aendi e video. Thank u thank u chandoo. We need more SQL videos, please can u do it for us, please

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

    This is great intros to SQL. A suggestion to create a Part 3 for the advance stuff like windows or subqueries.

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

    Chandanna you are simply superb in explaining concepts. crystal clear 🙏🙏🙏🙏🙏🙏🙏🙏

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

    Thank you so much, I used to think it is not for me as it seemed complex. You made it so easy to understand. Great job on presentation and simplifed teaching with a great example. 👍

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

    Outstanding Chando Sir! the example and trying to understand the thing is fabulous for beginners !!!!

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

    Well done - You made this simple to understand. Looking forward to seeing the next video.

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

    one of the best way to explain love it

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

    As a backend Developer working with sql all day the simple explanation is just so good will definitely share this with some of my junior who are just starting with SQL

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

    Wow crazy chandoo another master blaster concept from you

  • @SAMO-PETS
    @SAMO-PETS Рік тому

    Thank you sooo much very helpful this video, they make me know the basics of sql that a i don't know it after this moment.
    Your explication with lego to give some idea of work with sql is very wonderful your smart bro keep it up .

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

    You dealt with Excel, You Crushed Power Bi, now Its time to Terminate Sql. You made me love Excel. Thanks.
    I love how you are breaking this sql. I am a fan of yours. Thanks CHANDOO.

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

    Brooo... may god bless you for this..
    Thank you soo much

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

    Chandoo on SQL!!😲 Looks like my little wish came through 💃💃💃. Lately I've been training myself with Python Data Analysis. Pandas and Numpy.

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

    Very informative video with the Beautiful visualization concept using Legos, Can't wait for the in depth video of SQL ✌🏻

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

    Very nice example To Visual your amazing teaching

  • @Arjun-Shah-b2r
    @Arjun-Shah-b2r 7 місяців тому

    Thanks Sir, understood the basics moving to the detailed one...

  • @Smile.4751
    @Smile.4751 6 місяців тому

    This is what I was looking for..... ❤ thank u so much

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

    Thank u very much sir....🙏, This video cleared all my confusion......😇

  • @Asurisagar
    @Asurisagar 8 місяців тому

    Directly pushing the content to 🧠..Super 👌

  • @Darshanam-Jatra
    @Darshanam-Jatra 2 роки тому

    what a grt creativity chandoo
    lego with sql - concept well drilled into everyones mind
    excellent thanks a lot

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

    This is really awesome learning on SQL basics.

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

    Thank you do much, waiting for more videos on SQL

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

    I was looking for a course to start learning SQL and you uploaded this video🤗

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

    I've just started learning SQL. This is amazing ❤️ thank you Chandoo

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

    very interesting and informative ). Thank you Chandoo 👍

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

    Very informative video on SQL. Thank you, Chandoo

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

    im so glad that i found your youtube channel

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

    I am supper happy I stumbled on your video. It's so simplified, can you coach me privately ?
    I want to learn more from you about SQL as I am upgrading myself for a career shift