SQL Basics for people with no prior knowledge 🤷♀️🤷♂️
Vložit
- čas přidán 2. 07. 2024
- 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 CZcams, 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 - Věda a technologie
💥💥💥 The Detailed SQL video is now LIVE!!! Check it out here 👉 czcams.com/video/l8DCPaHc5TQ/video.html
What count(*) indicates.
I am a beginner in SQL . Can anyone please reply
@@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.
@@Vinaykumar-yb7cd thank you so much
WOW! Finally someone explains SQL in a way that humans can understand it!!!! Thank you so much!!!!!
Glad it was helpful!
this is one of the best introductions I have ever seen for SQL , thank you
I must say you are the best tutor ever. You always create ways of simplifying your teaching. Thank you for all you do.
Honestly speaking I haven't seen like this informative video in such simply manner.
I learned the SQL fundamentals & still found this video useful. Thank you, Chandoo, for always teaching!
Great work Chandoo! Love the no BS approach and the visualisation with lego works really well!
Consistently outstanding videos. The content, pace,and the tone are pitch perfect for learning. Thanks. I am new and now a big fan.
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. 👍
This is the best and simplest tutorial I have seen.Very beginner friendly
Very nice example To Visual your amazing teaching
Well done - You made this simple to understand. Looking forward to seeing the next video.
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!
Teaching can be fun and simple for learners..the best tutorial for 2023 . Thank you.
Very innovative way to teach "SQL"! Thank you!!!!
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 😀
Chandoo sir you're a genius. I went thru your SQL courses and I feel so confident. Thank you for making it so simple. 😇
Very out of the box demonstration! I'm a big fan of your videos. 😊🤗👍
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.
Love the use of Lego - really makes the concept clear!
Thank you so much the way you explaining us with great example and Ideas.
This is really awesome learning on SQL basics.
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 🙏
SUPERB illustrations! So very easy-peasy to VISUALIZE instantaneously!! Way to go Sir!!!
Cant wait for the next vídeo!!!!!! Thank you!
This is great intros to SQL. A suggestion to create a Part 3 for the advance stuff like windows or subqueries.
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
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.
Love when there's visual learning mixed with detailed information also, ty sir
Very simple to understand explanation. Thank you for this!
Thank you so much, I will stay tune and would be open to a full class if you offer that
Yes yes, love ypur teaching style as always!!! Was waiting for this and also will be waiting for videos to combine sql and excel!
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 !!
Thank you Chandoo, I'm currently learning SQL, I've enabled the notifications for more beginner videos :)
a masterpiece of explaining and learning !
Wow crazy chandoo another master blaster concept from you
Great work you are doing for humanity. God bless you loads
Your analogy was refreshing and understandable for a beginner like me.
Thank god SQL from your teaching style now my all doubt will be cleared. I am waiting for your complete video.
Maaaan, such a unique way for explanation! Great job!
im so glad that i found your youtube channel
Such a wonderful and simplified explanation! 💯👌
Interesting way to teach SQL!!
Your teaching man is just 💪💪💪. Thank you.
congratulations...this is amazing !!! thank you so much !!!
Amazing way to explain! Hats off👍
Excellent ..... waiting for the next one
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 ❤️❤️❤️❤️
what a grt creativity chandoo
lego with sql - concept well drilled into everyones mind
excellent thanks a lot
This helps to beginners to understand what actually we are doing in SQL !!..... Thank you @Chandoo ✨
Chandoo!!! You’re incredible. Please keep up the good work
Very innovative Sir.Hats Off to you !
Incredbile video, Thank you!
Very informative video on SQL. Thank you, Chandoo
I've just started learning SQL. This is amazing ❤️ thank you Chandoo
This is AWESOME!!!!
@Chandoo how you are so much capable to teach us like that. I really inspire with your teaching style.
Very nice introduction about SQL sir,
We are waiting for more SQL vidoes in same simplest way
Thanks in advance
Nyc Tutorial 🎉..
He is the beast in Explaining stuff 🔥🔥 🙏
Outstanding 🎉🎉❤
Waiting for your next video💥
Thanks for this truly visual video. I meant that the way you explained is very easy to remember the SQL statements...
This is an amazing teaching technique
Thank you do much, waiting for more videos on SQL
You have a very Innovative mind,. Please do it more. Thanks for your teaching 💗
very simple and easy to understand SQL for Data People. please make videos like this.
Very nice idea to teach.. You are a great teacher
Great video
Explanation is very helpful to understand concepts thank you sir.....👌👌👍
Outstanding Chando Sir! the example and trying to understand the thing is fabulous for beginners !!!!
Perfect 👌
Please do more videos like this
Brilliant Explanation Chandoo!!! Congratz for this wonderful channel!!!
Great...! 👍 👍
one of the best way to explain love it
very interesting and informative ). Thank you Chandoo 👍
Directly pushing the content to 🧠..Super 👌
Very innovative way to teach "SQL"! Thank you Chandoo, you always succeed with a surprise approach to teach concepts! Keep them coming! 🙂
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 😀
@@chandoo_ Sure it did!
@chandoo_ surely it worked for me and you managed to demystify the discomfort in me towards SQL
Very informative video with the Beautiful visualization concept using Legos, Can't wait for the in depth video of SQL ✌🏻
Really amazing way of explaining the concepts. Thank you sir. I would love for more videos on SQL
thanks, you convey my message to Sir Chandoo in simple words. again thanks
Brooo... may god bless you for this..
Thank you soo much
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 .
Very usefull explanation, thanks
Great sir
Much needed one. Thank you 🙏 please upload full course so that we can learn and use in data analysis.
Awesome introduction. Please make more videos on SQL for beginners and Non-tech guys.
Wow amazing, u r a wonderful teacher thank you so much
Excellent explanation on a interesting topic!
Thank you Chandoo, you're a great teacher... Looking forward to the join lesson
Very good and easy to follow
Awesome teaching bro....
some real-world examples and presentations will be an excellent initiative for beginners like me. Thanks, Chandoo
Really thank you so much, your content is very useful for me :)
Excellent. Waiting for next class..
The most perfect introduction to SQL, as the title says.
This is what I was looking for..... ❤ thank u so much
Very interesting video
Very nice explanation👏👏👏
Super useful man
Thank you so much
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.