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

SQL!!! If you work as a data engineer, scientist or analyst, then learning SQL is going to change how you view and handle data. SQL stands for Structured Query Language. In this easy to understand tutorial, let me give you all the basics of SQL. Right from SELECT to WHERE clause to Multiple conditions (AND / OR / NOT) to ORDER and GROUP BY.
WANT MORE?
Watch my detailed SQL Video with more than 50 example queries, full sample dataset and practical tips. 👉 • Learn SQL for Data Ana...
⏱ IN THIS VIDEO 👇
=================
0:00 - What is SQL?
0:58 - SQL Select Examples
1:39 - WHERE clause
2:11 - OR operator
2:55 - AND operator
3:26 - IN operator (vs. OR operator)
4:31 - * vs. specific columns
5:03 - ORDER BY
6:24 - NOT operator
7:12 - GROUP BY
8:58 - Wait, there is more!!!
LEARN MORE 📚💻
================
💥DETAILED SQL Video - • Learn SQL for Data Ana...
Meanwhile, also check out below videos:
Data Analysis with Excel (full course + examples) - • Beginner to Pro FREE E...
Power Query (it is like SQL, but you can use it from Excel or Power BI) - • Power Query Tutorial -...
Database vs. Data Warehouse vs. Data lake - • KNOW the difference be...
Data Cleaning in Excel - 10 PRO tricks - • Data cleaning in Excel...
5 skills you need to be a GREAT data analyst - • 5 key skills you need ...
😎 SAY HELLO 👋
===============
Apart from KZbin, I frequently post on,
my blog - chandoo.org/wp/
twitter - / r1c1
Instagram - / chandoo.xlsx
~
The waiter: "What is your order sir?"
The SQL developer: "Desc of course" 🤣
#SQL #database

[@chandoo_]

💥💥💥 The Detailed SQL video is now LIVE!!! Check it out here 👉 kzbin.info/www/bejne/ommndIOXfchoirM

[@Kiranmai30]

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

[@Vinaykumar-yb7cd]

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

[@Kiranmai30]

@@Vinaykumar-yb7cd thank you so much

[@HananelGez]

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

[@chandoo_]

Glad it was helpful!

[@kazmir_]

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

[@gameon550]

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

[@nwosulucy8889]

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

[@sasha1364]

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 😀

[@PaulasPicks]

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

[@ShahnawazKhan-xl6ij]

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

[@kjot73]

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

[@boringlyfactual6368]

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

[@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. 👍

[@concon264]

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

[@vijayarjunwadkar]

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

[@chandoo_]

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]

@@chandoo_ Sure it did!

[@Deogratias_Okello_Alumai]

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

[@nicktobies]

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

[@mohammedshabaaz9625]

Liked before watching...that's how much trust I have!!! Thank you for starting with SQL❤️🙏 PLEASE MAKE MORE VIDEOS ON SQL ADVANCED TOPICS. Your teaching are easy to understand ❤️❤️❤️❤️

[@namanjain5763]

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

[@ksp7582]

This helps to beginners to understand what actually we are doing in SQL !!..... Thank you @Chandoo ✨

[@labiii9968]

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

[@JunaidKhan-gq8nw]

Dear Sir, it was amazing way you show. During this video I think about more and advance videos about SQL you made for us but in the end you announced yourself. Thankful everytime. waiting curiously for upcoming videos of SQL.

[@nomahlubithunyiswa2761]

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

[@PoojaGupta-om1pv]

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]

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

[@chandoo_]

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

[@PoojaGupta-om1pv]

@@chandoo_ Thank you so much sir 😊

[@bansdeepkumar]

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

[@DPRATEEK18]

Please do this video

[@denisskorikov6234]

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

[@karimallahwala7022]

Very nice example To Visual your amazing teaching

[@bilalhashmi9377]

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.

[@richaagrawal376]

Yes yes, love ypur teaching style as always!!! Was waiting for this and also will be waiting for videos to combine sql and excel!

[@adityaanand1591]

thanks Chandoo for this wonderful explanation of SQL and it's concepts. It will be really helpful if you make some videos on " Data Cleaning through SQL" and one session on interview based questions of SQL.😊

[@JunaidKhan-gq8nw]

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.

[@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 🙏

[@canirmalchoudhary8173]

This is really awesome learning on SQL basics.

[@salehmuhammad6811]

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

[@JJ_TheGreat]

Thank you for the video! Even though I learned SQL before, this is a good summary and review video. I look forward to your next video on the topic!

[@bandasainath8041]

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

[@JunaidKhan-gq8nw]

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

[@nammibhargav9498]

Thanks for starting SQL Anna .. Please also explain the important topics in a single videos using real time scenario ..So we can refer them

[@edu1113]

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_]

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).

[@cynthiahoz3948]

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_]

You are welcome Cynthia.

[@adityabahuguna1132]

What softwares are you using to practice SQL?

[@Kishan_Nayak]

Which one is better SQL server/Oracle

[@titilolaolanrewaju3070]

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

[@manikandanr2954]

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

[@ru2979]

He is the beast in Explaining stuff 🔥🔥 🙏

[@successfulvictorypublisher6090]

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

[@GrainneDuggan_Excel]

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

[@rahuldifusa7]

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_]

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]

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

[@faliqzulkifli933]

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

[@shabchique7149]

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

[@keniawoniyi8486]

Very simple to understand explanation. Thank you for this!

[@sadhanach8711]

Hi Chandoo sir, This video on SQL queries is amazing! Can't wait for your next SQL video 🙂.

[@WhereTheMindisWithoutFear.]

The effort put to this video is amazing and the output value is priceless.. One more reason to feel proud to follow Chandoo Sir... !

[@chandoo_]

Thanks Rajiv. I am glad you enjoyed this.

[@Saumyagrow]

one of the best way to explain love it

[@reshmakanjani9433]

Such a wonderful and simplified explanation! 💯👌

[@vivianchioma3687]

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

[@obonebula6569]

Chandoo!!! You’re incredible. Please keep up the good work

[@mehernesa_kazi]

Much needed one. Thank you 🙏 please upload full course so that we can learn and use in data analysis.

[@roymusic565]

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...👌👌👌👌👌

[@stluke324]

This is an amazing teaching technique

[@muhammadobaidkhan4099]

some real-world examples and presentations will be an excellent initiative for beginners like me. Thanks, Chandoo

[@siddeshchandra8535]

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

[@dakshajethva614]

Thank you so much. I have been thinking of changing my field from health to IT. I have been struggling so much with all of these languages , you made it simple for me to understand. Please requesting you to make a video for a non tech person trying to enter into tech, having an option possible to be in the health department too. As i have been seeing all fields require IT.

[@vinayakkulkarni5407]

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

[@LearnChannelFox]

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

[@satishdhuttarge4009]

Hi Chandoo.. You have amazing teaching technique.. anyone can connect with this SQL content as beginners.🙂

[@namy1557]

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

[@vishalchakravarty3424]

My prayers have been answered, chandoo finally doing it SQL

[@itumelengmodise409]

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

[@terihandrick2333]

Thank you so much, I will stay tune and would be open to a full class if you offer that

[@Asurisagar]

Directly pushing the content to 🧠..Super 👌

[@wwisamm1411]

a masterpiece of explaining and learning !

[@maheshbhadane1520]

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

[@Prabhakaran-hp1to]

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

[@ramakantamohanty5854]

Awesome introduction. Please make more videos on SQL for beginners and Non-tech guys.

[@kindly_seven]

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

[@jhamca10]

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

[@ashmitasharma5879]

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_]

You're very welcome!

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

[@debanshub916]

Interesting way to teach SQL!!

[@lokeeeee]

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

[@muciobatista10]

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

[@fahimreza1377]

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

[@Jobin.Thomas]

Much awaited series.. thank you so much Chandoo

[@misbahsayeed8691]

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

[@kashisharora4563]

Sir, your explanation method is awesome , please make complete SQL series 🙏🏻🙏🏻🙏🏻❤️❤️

[@gayathrigayu5479]

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

[@kezeiah3644]

im so glad that i found your youtube channel

[@chinyerenwigwe5166]

Thank you Chandoo, you're a great teacher... Looking forward to the join lesson

[@trinashishmitra2587]

Amazing way to explain! Hats off👍

[@akshaypatil8155]

Thank you so much for every video. Your approach of teaching the concepts is simple and you explain to us as if we are small kids. I love it. A very tough recipe to master. God bless you sir. Could you plz make a video on how data science dept. works? What is the flow of the work, how follow ups happen, how communication happens, how is the work distributed, when and which role comes into the picture, no one is making video on thsi topic....

[@wgalloPT]

congratulations...this is amazing !!! thank you so much !!!

[@francesdobbins2964]

Very informative video on SQL. Thank you, Chandoo

[@aashishmalhotra]

Wow Chandoo it was like i got back into primary school where teacher explaining everything visually. Can u make this kind of video for more complex SQL topic like windows functions, types of join and usecases

[@vipuljhaveri3884]

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

[@ajvlogs1059]

Hey chandlo , can you please make a video on end to end project where questions arrises and ( including > Excel >python > sql >powerbi )start from scratching data to create dashboard and till final review 🙏 that gives us a brief live knowledge and overall insight about data analyst ( you can also create videos in parts for that , as you like ) which gives benefits to all of us..

[@alexrosen8762]

Excellent explanation on a interesting topic!

[@pedrovic12]

Cant wait for the next vídeo!!!!!! Thank you!

[@tracybryant7906]

Very good and easy to follow

[@skincaretips3357]

Nyc Tutorial 🎉..

[@abhishekgangurde9054]

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

[@arupmca]

Excellent. Waiting for next class..

[@keepgoing313]

Just wow🎉

[@Tapan-lc6he]

Thank you so much, sir🙏

[@Smile.4751]

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

[@equiwave80]

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

[@suhailmik3713]

👏👏👏👏 That's an wonderful teaching ❣eagerly waiting for the videos on Joins