Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)

SQL is one of the most important skills to have for data people. In this comprehensive video, learn how to use SQL to perform common data analysis tasks. You will learn:
◈ How to use SELECT statement to answer business questions
◈ Working with WHERE clause
◈ Using AND, OR, NOT and combining them to create complex queries.
◈ Sorting query results using ORDER BY
◈ Combining data from two or more tables using JOINS
◈ Creating reports with GROUP BY
◈ More than 50 example queries, tips and ideas
🚨 PRE-REQUISITES:
You need any SQL console (I am using the FREE MySQL Community Edition and you can download it from dev.mysql.com/downloads/insta... )
You also need the Awesome Chocolates Dataset.
See chandoo.org/wp/learn-sql-for-... for the sample files, instructions on data import and other SQL resources for you.
😃 Basic intro:
If you want a simple introduction to SQL (for an interview or to brush up), see this video instead - • SQL Basics for people ...
⏱ IN THE VIDEO:
0:00 - Introduction
0:43 - Data setup, explanation & basic queries
6:24 - Adding calculated columns in SELECT
8:39 - Our first WHERE clause
10:28 - Ordering query results with ORDER BY
13:24 - More Where clause examples
16:42 - Between conditions
19:06 - Working with Dates
21:50 - Using other tables
23:47 - IN clause
24:36 - Pattern matching in SQL
26:30 - CASE operator and branching logic
30:30 - JOINS
36:32 - LEFT Join vs. RIGHT Join ~ EXPLAINED
38:28 - More Join examples
42:10 - Adding conditions to Joins
47:30 - GROUP BY and creating reports with SQL
54:50 - Showing Top 10 Products by Amount
57:12 - Closing remarks & next steps for you
📚 RESOURCES TO LEARN MORE SQL:
1) Practice the problems and scenarios discussed in the video with the awesome chocolates dataset.
2) Solve homework problems listed here - chandoo.org/wp/learn-sql-for-...
3) Get one or two SQL books. My recommendations are here - chandoo.org/wp/learn-sql-for-...
4) Consider going for an SQL course. Check the same page for my course suggestions.
5) PRACTICE, PRACTICE, PRACTICE!
🙄SQL ALTERNATIVES:
If you don't want to learn SQL but still wish to work with data, then consider learning POWER QUERY, which offers similar capabilities as SQL.
See this video 👉 • Power Query Tutorial -...
😎WATCH NEXT:
Now that you know a bit of SQL, why not use it with Power BI to do visual data analysis?
If you are new to Power BI, see my Power BI video to get started with that.
👇
• Beginner to PRO Data A...
~
😍FOLLLOW ME
Apart from KZbin, I regularly share content on below places. Feel free to check them out and give a follow.
💻 WEBSITE - chandoo.org/wp/
📃 WEEKLY DATA TIPS NEWSLETTER - chandoo.org/wp/subscribe/
📷 INSTAGRAM - / chandoo.xlsx
🐤 TWITTER - / r1c1
~
Select "good day" from days
where person = "you" 😃
#sql #tutorial

[@pgkannan]

Thanks!

[@chandoo_]

Thanks Kannan for the super and love 😍

[@Bhoomi-ux4hv]

Hi bro...can i get the information of Oracle SQL with installation n practising.....as I want to try for the job which it is useful for my career..can u pls suggest me

[@christianowusu9764]

I have watched several videos on SQL and have never understood the concept of it until I came across this video. This was well explained in the simplest way possible. You are an exceptional instructor. Thanks for the help.

[@zeeshanrafique5348]

Most Productive 60 mins I have spent on KZbin. Great to the point video.

[@BKSDA1]

Fantastic video! I cannot stress enough how much these types of videos help. Thank you man for taking the time to explain all these basic SQL concepts. LEGEND!

[@hazeldoshi8442]

Hi. It was a great class. Can I request you to have a Masterclass for SQL covering everything from basics to advance? That will be very very helpful.

[@vijayarjunwadkar]

Thanks Chandoo for this awesome SQL video! I know SQL and regularly using Oracle and SQL Server, but now you have helped me understand usage of MySQL as well, and it's a value addition for sure! 🙂

[@ushakirandhoke7352]

I saw various videos on SQL but this one is the best. No confusions everything is up to the mark thank you for sharing it 😊👏

[@alfonsobarreiro3777]

Thank you, Chandoo! This is a great video to understand the basics of SQL. I've also been watching your Excel videos.

[@daviddiazsanchez7292]

Thank you Chandoo! You are my favorite teacher and Data Analyst instructor. I love all of your videos and contents.. many many thanks

[@carolinateran5851]

Muy claro video! Muchas Gracias...Me encantó esta parte: Select "good day" from days where person = "you" 😃

[@nimraali7145]

This is my favorite SQL tutorial on youtube. Thanks for making it so easy to understand. Looking forward to more SQL tutorial from your end!

[@chandoo_]

Glad it was helpful!

[@mattbilliot7627]

This is by far the best tutorial on SQL that I have seen. I've taken a few SQL courses and was getting confused towards the middle of the course, but this short and straight to the point showed me a lot. I would love to see you make a full tutorial on this subject from beginner to advanced level. Thank you for doing this video on SQL and I look forward to watching and learning more from you. Have a great day!

[@flickhunter8900]

is it for beginners? I am a complete beginner

[@AltafAnsari-tf9nl]

I had gone through many videos on youtube for SQL but this one tops them all . Simple,easy and hands-on. Great Work !!!

[@chandoo_]

Glad it helped!

[@nareshsaplabs]

Thanks a lot Chandoo for this video. This is exactly what I was looking for - to the point, crisp n clear with that too with practicals which is cherry on top... Thanks again :)

[@charlessosu638]

words can't quantify how much of a lifesaver you are. keep doing what you do best

[@buddhahat]

Chandoo, this is a spectacularly helpful video mate, thank you so much. I will absolutely be sharing this video with colleagues. What you have managed to demonstrate in less than one hour is a lot more than some instructors on paid sites manage to achieve in hours. You've really outdone yourself. I am just about to start a new role which will require this skill, so your upload is perfectly timed. Thank you very much!

[@chandoo_]

Wow.. thanks Buddhahat. I first learned SQL in '96-97 and have used it for first 6 years of my professional life. Then fast forward a decade or two, now I am back on SQL again. I am glad you loved this :)

[@Unknown-ng8me]

​@@chandoo_ Plz make video on window function and cte

[@priyavarshanrg700]

@@chandoo_ Bro i face this type of error "0 7 18:38:12 use awesome chocolates Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'chocolates' at line 1 0.000 sec" what can i do

[@niggszo]

Thanks a lot, Chandoo! Your discourses are always so clear and concise. So appreciative to you for helping people.

[@raquelheleno4676]

I'm so grateful for this video Chandoo and for your time spent making then. You helped me a lot. The best SQL video ever!

[@salahderdar5148]

The best tutorial I've ever seen about SQL, Thank you Chandoo, We will be very grateful if you could make an advanced tutorial treating a real data analytic project using SQL Thank you a very much Chandoo

[@SnowFaceChamcham]

Not that you need the same thing repeated to you again, but this was insanely helpful. I'm thinking I may be studying to be a data analyst soon but I didn't want to make a huge financial commitment without knowing how the tools worked and this was exactly what I needed to know that I'll love learning all I can about it

[@HYP3WOLF]

there is little financial commitment just take courses online through coursera and earn a certificate through there for data and sql

[@martinjob2246]

This is the best SQL tutorial so far on internet

[@prathyupa]

This is a great effort for people who wanted to understand SQL. Thankyou Chandoo!!!!!

[@mohammedshabaaz9625]

Thank you so much Chandoo for this video. Can clearly see how much of effort you put into making these videos with full end to end information with resources and homeworks for better understanding. Your videos are becoming an addiction to me😅❤️ Glad to have found this channel. God bless You

[@manveersingh8627]

+1

[@sarfrazakhtar9887]

You watched his videos after having any course? I'm new and I'm not getting anything what i need to start with basics ?

[@nilufarnosirjonova1399]

The class was very clear and easy to follow. Thank you!

[@Tiaggus]

Thanks. This tutorial is so helpful. In my case, I'm in the middle of a career transition to Data Analytics. So, thank you again.

[@nimraali7145]

Genuinely excited to practice SQL with this video!

[@guillermoag7722]

@Chandoo. I loved this tutorial. You have a way to explain difficult concepts and make them seem very easy. Thank you!!!

[@myarchitecturallife4643]

thank you it was really helpfull, i was actually getting confused when i was trying to analyse data with sql, nbut now my all doubts are solved thank you again!!!!!!!!!!!

[@sparklingtravellers]

Your video and my learning path are quite similar.. I first learn and become a pro in Excel but was in dilemma to learn SQL and power BI .. this video is a perfect guide and valuable material for both... You are absolutely awesome 😎😎

[@shravanpandey4501]

I m unable to import database pls help

[@suprasannakarsabankar222]

Thank you chandoo. It is very useful for beginners to become expert in SQL. You are my god of career. I really follows all your videos. 🙏🙏

[@jiayili437]

Amazing no-fuss video for SQL beginners, thank you!

[@agkalyan]

Sir are greatest mentor in youtube. Who like to share your knowledge to needy people and thanks give clarity on each concept. Wishing to reach sooner 1 million subscribers 🙏 ❤️ 🙌 💙 ♥️ 💕

[@flyeagle320]

Thank you Chandoo sir , for making SQL look simple with your video . I am so confident to learn more by practicing the same .

[@chandoo_]

Thanks FlyEagle for the love and SUPER 😍

[@ambikareddy21]

Hi sir i have just started to change my career path to data analytics and after going through various platforms i came across your videos and they are so amazing, thankyou for putting things in such a beautiful way, happy student 😃

[@ShailendraKumar-hx5mq]

same here

[@donkey8206]

Is the data analyst carrier has good scope, r more jobs available out side ,I am in a plan to switch over from KPO Medical billing sector to Data analyst Pls share ur experience

[@shivampal6058]

Great work Sir, The clarity of concept you have is just outstanding.

[@KulwinderKaur-kd3bk]

This is so far the BEST SQL video , along with real time practice that I have come across. A big thanks to you sir. Sir please make a video on the how to use LinkedIn for applying job as a data analyst.

[@harinimeenakshi7321]

The most honest channel that I have found on KZbin. Thank you so much for the data sets😃

[@chandoo_]

I appreciate that!

[@christopherk7920]

I am studying Google's certified DA course and this is very useful prep ! Thank you bro 🙏

[@tjguruguru4525]

Hi chandoo sir I am new to your channel but I saw your video really great ☺️ kindly upload full course of python in data analytics ....🙏🏻🤝

[@ogunsanyamayowa3736]

I love this content so much better than several contents on the internet talking about SQL

[@kavyasree9885]

Thanks Chandoo! I could able to revise my basics with this video.

[@abigail9457]

What perfect timing Sir! Was struggling with sql and this came up.....Thank you so much👍🏻🤩

[@chandoo_]

I guess I "SELECT"ed the right time to publish it then 😃

[@giorgimodebadze1869]

I am starting learning SQL and sure this video tutorial will be very helpful for me 🎯

[@MrEocran]

I started this yesterday and I am really glad I found your video.

[@ritaashz3107]

Such a appropriate tutorial for all types of learners. Thanks man!!

[@cwnmaster]

Could you please provide next level of SQL starting from HAVING clause? I love the way you explain. I also love your your humour and your native tone.

[@yankoshuan6225]

Chandoo , i ve been a fan since i learned excel from your videos. thank you for your time in producing such a high quality video. hope u doing amazing . wish u the best

[@luckyfin4572]

Nice effort, Chandoo. Very helpful especially for beginners ❤

[@emilisayev6279]

Thank you so much for your hard work and for explaining everything very clearly.

[@sarimhussain6095]

My man, this was one hell of a video. Thanks !

[@rumekegbe2]

All I can say is I love your work Chandoo. You are the best at what you do. ❤️

[@chandoo_]

Thank you Rume.

[@anishshipping7200]

Such a crisp and up to the point content.. being Non IT guy, I am able to grasp it. Thanks bro for making this. Regards Anish

[@laxshmikanthboya2835]

Absolutely nice way of Explanation Chandoo Anna, for Beginners like us it's more useful and informative

[@iqraazhar11]

Really helpful in revising SQL concepts . Much appreciated 👏

[@sourabhsharma5275]

the best thing is you have shared the same data set. Thanks alottttt chandoo sir

[@HananelGez]

Finally SQL makes sense!!!!!!!!!! Thank you so much!!!!!!

[@mashoodahmed8734]

So much covered in just one video. Extremely helpful and amazing 🔥

[@sarfrazakhtar9887]

What you studied it before? Because I'm not getting anything

[@simonoganga9535]

Amazing tutor, making hard concepts easy and flow effortlessly like water

[@agraligarhian8045]

Much needed video man!!! 😂 Was sitting for placements this week.

[@rahulminhas572]

Which college are you from?

[@agraligarhian8045]

@@rahulminhas572 Bundelkhand Institute of engineering and technology, Jhansi, Uttar Pradesh

[@rahulminhas572]

@@agraligarhian8045 ohh Are you sitting for internships or placement?

[@agraligarhian8045]

@@rahulminhas572 both

[@rahulminhas572]

@@agraligarhian8045 are you in 4th year or 3rd year?

[@aminenidmhan9654]

Mister Chandoo, i just reviewed sql in 1 hour with this course, many thanks to you my friend

[@akshaykadam7992]

You are the best gift youtube gave us... Thank you so much 😊

[@ImrulKabir-hb3lq]

The ultimate teacher = Mr. Chandoo. I love you Sir. You are making my everyday of learning. May Allah bless you in all sense.

[@Justcallmerita]

Thank you for sharing your knowledge with the 🌏!

[@chandoo_]

Wow. Thanks Rita for the love and super 😍

[@justinedema6266]

Thanks Chandoo! You made it look so easy...

[@MamunRashid-er8yz]

Thank you so much Chandu. This video is just awesome for SQL learner with practice. Your work is super

[@vaijayantigulve4883]

Excellent teaching... Thank you once again... 🙏🙏

[@MVETDivyaTA]

It was very fun and learnt a lot in very easy way couldn't stop myself from watching during 'joins' session.Thanks

[@manishaprasad9146]

Thank you for your informative and articulate videos. Since discovering them, I have been consistently drawn to watch more. Highly informative!! Recommend 10/10

[@chandoo_]

Welcome aboard Manisha. :)

[@omharne1386]

It was a great class. Thank you so much Chandoo for this video

[@newday8074]

Thank you very much. May Allah rewards you. It's the first that i could understand sql clearly

[@xoichien9927]

Great video. Looking forward to the part 2

[@fajrieyulio6492]

Always love to learn from indian teacher. thank you so much Sir, u r the best

[@evilpapa6013]

Thank you for all these videos. It is a great help to us who are just looking into Data Analytics

[@chandoo_]

Good luck with your learning and career EP :)

[@AliMateen]

I am your student since you were on excel only. You are outstanding! Love from Pakistan.

[@thejourney4154]

I just fall in love with you the way you deliver the knowledge... Just amazing. My youtube searching just stuck at your channel.

[@chandoo_]

So nice of you TJ. 😍😍😍

[@RatikantWallapure]

Thank you for sharing great SQL knowledge😊🙏.

[@dileepkumarreddy9556]

Super explanation Sir, Thanks for the brief explanation.

[@kunalkumaraiml2365]

Thank you so much for such nice and incredible videos. It is really helpful for us 🙏.

[@TheOana]

This is fantastic!thank you!

[@goodviber4136]

Best Video in this SQL journal !!!

[@riyat777]

you are such a talented teacher.. thank-you so much for teaching us 🙏🙏🙏🙏

[@chandoo_]

You are welcome Riya :)

[@PoojaGupta-om1pv]

Thank you so much sir for putting so much effort 😊 also one of the best SQL video available on youtube

[@chandoo_]

You are welcome Pooja.

[@asif_786]

That is what I'm looking for. Thanks, chandoo sir from my bottom of my heart love from India

[@chandoo_]

You are welcome Asif.

[@layzaduco5546]

Thank you Chandoo, it was my first time on SQL but I have some knowledge on excel, it is really helpful specially to those starter people like me 😍 Got big understanding on SQL, Again thank you!

[@chandoo_]

Glad to hear that

[@ahmedhelal920]

Thanks for this good training , awesome , i am using SQL as a data analyst and i make refresh with these awesome queries with a cup of tea .

[@agkalyan]

Thanks you for wonderful explanation on the sql concept, You video help me to crack interview in data analyst. Thanks again , Request continue similar videos

[@Jamesmichael312]

Thanks a ton. Very well explained.🙏

[@wgalloPT]

This IIS GOLD !!!!!! THANK YOU SO MUCH FRIEND!!!

[@phoenixkomben-ie9xq]

Even college professors can't explain like this guy🎉

[@arjunkrishnakj507]

Big shoutout to you..Chandoo sir..all the aspects are crisp and clear. This is cool❤🎉

[@HeManojWorld]

Awesome content. Thank you Chandoo👍

[@monishpilla4137]

Sir Thank u for the video it is really very helpful. Please continue this series and cover the remaining topics . Waiting for the next video.

[@saswatkumar2517]

best video on sql i have watched on youtube

[@vaijayantigulve4883]

Learning a lot from all your videos...!! Thanks a ton. Will contribute more once I get a job. 🙏🙏

[@chandoo_]

Thanks for this lovely gesture @vaijayantigulve4883. 😍

[@flickhunter8900]

I had no idea what sql is, still I am learning from this vide. Just amazing. Thanks Chandoo

[@chandoo_]

Glad you liked it!

[@flickhunter8900]

@@chandoo_ yes bro. I m watching your videos to become a business analyst

[@enzocaroli]

Amazing video! Thank you so much, Chandoo!

[@vinodchand1987]

Thanks for teaching in a simple way

[@Spider-911]

Excellent thanks for sharing knowledge

[@theshadowofclouds]

this is pretty boss, man. thank you kindly for the upload

[@sharathchandra4812]

Hey Chandoo, @chandoo In MySQL, the weekday() function returns the day of the week as an integer value, where Sunday is 0 and Saturday is 6. Therefore, to get the data for Friday, which is the fifth day of the week, you would need to filter the results based on weekday(saledate) = 5. This is what I observed while going through your class..

[@Obito847]

No, it starts with Monday for 0. 0 = Monday, 1 = Tuesday, 2 = Wednesday, 3 = Thursday, 4 = Friday, 5 = Saturday, 6 = Sunday. Correct me if am wrong... Thank you