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 https://dev.mysql.com/downloads/installer/ )
You also need the Awesome Chocolates Dataset.
See https://chandoo.org/wp/learn-sql-for-data-analysis/ 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 – https://youtu.be/yfWcZ6eot4g

⏱ 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 – https://chandoo.org/wp/learn-sql-for-data-analysis/
3) Get one or two SQL books. My recommendations are here – https://chandoo.org/wp/learn-sql-for-data-analysis/
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 👉https://youtu.be/PiFAa_jjaEI

😎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.
👇
https://youtu.be/uwe8C7K8fXY

~

😍FOLLLOW ME

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

💻 WEBSITE – https://chandoo.org/wp/
📃 WEEKLY DATA TIPS NEWSLETTER – https://chandoo.org/wp/subscribe/
📷 INSTAGRAM – https://www.instagram.com/chandoo.xlsx/
🐤 TWITTER – https://twitter.com/r1c1/

~

Select “good day” from days
where person = “you” 😃

#sql #tutorial