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 also need the Awesome Chocolates Dataset.

😃 Basic intro:

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

😎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.
👇

~

😍FOLLLOW ME

Apart from YouTube, I regularly share content on below places. Feel free to check them out and give a follow.

~

Select "good day" from days
where person = "you" 😃

#sql #tutorial

[tipumusicstudio]

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

[christianowusu]

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.

[mattbilliot]

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!

[fahmidaahmed]

I've tried watching many videos on YouTube, but most of them tend to be a bit dry and make it hard to stay interested. However, your videos are beautifully explained in clear steps that make complex topics much easier to understand, even for someone who isn't very tech-savvy but is eager to learn. Thank you so much for that! Your Lego video, in particular, really helped me grasp how the command function works. I love your content—please keep making more!

[AltafAnsari-tfnl]

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

[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

[ambikareddy]

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 😃

[carolinateran]

Muy claro video! Muchas Gracias...Me encantó esta parte:

Select "good day" from days
where person = "you" 😃

[flyeagle]

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

[MonikaLimma-pjvq]

This 1hr video taught me much more than the paid class I was in for days..really thankful ..great video sir

[hazeldoshi]

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.

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

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

[phoenixkomben-iexq]

Even college professors can't explain like this guy🎉

[mohammedshabaaz]

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

[nimraali]

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!

[BKSDA]

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!

[myarchitecturallife]

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

[secret_step]

Sir kamal ka session tha. 1-hour full power-packed session. Thank you soo much. Aisa hi kuch session complex queries pe a jaye to bhut acha hoga

[Justcallmerita]

Thank you for sharing your knowledge with the 🌏!