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 )
You also need the Awesome Chocolates Dataset.
See 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 -
⏱ 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 -
3) Get one or two SQL books. My recommendations are here -
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 👉
😎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.
💻 WEBSITE -
📃 WEEKLY DATA TIPS NEWSLETTER -
📷 INSTAGRAM -
🐤 TWITTER -
~
Select “good day“ from days
where person = “you“ 😃
#sql #tutorial
10 views
794
225
3 months ago 00:01:11 1
Commercial Carpet Cleaning Cost Per Sq Ft Hua Hin Commercial Carpet Cleaning Near Me Hua Hin
4 months ago 00:16:49 1
COMPUTER SCIENCE explained in 17 Minutes
4 months ago 00:09:15 1
Установка MySQL 8 на Windows 10 – пошаговая инструкция для начинающих
4 months ago 20:47:05 1
Tableau Ultimate Full Course for Beginners - From Zero to HERO
4 months ago 00:13:10 1
How to Connect to Oracle Database in IntelliJ IDEA
4 months ago 00:11:28 1
Установка Microsoft SQL Server 2019 Express на Windows 10 – пошаговая инструкция для начинающих
4 months ago 00:00:49 1
every productivity and finance guru ever...
4 months ago 15:57:48 38
Harvard CS50’s Introduction to Programming with Python – Full University Course
4 months ago 00:08:28 10
Лучшие бесплатные курсы и книги по Python в 2024 год.
4 months ago 00:07:34 1
What is MES? Manufacturing Execution Systems
4 months ago 00:28:24 1
Best practices for using KEEPFILTERS in DAX
4 months ago 00:21:49 1
Как стать Java Junior с нуля / Как стать программистом с нуля / Полный план
4 months ago 02:49:35 1
Inventory Management System(C# Full Project using SQL server with source code)
4 months ago 00:09:42 1
SQL Tutorial #13 - SQL EXISTS and NOT EXISTS Operator
4 months ago 00:05:36 1
crypto traders be like...
4 months ago 01:20:31 1
Create A REST API with FastAPI, SQLAlchemy and PostgreSQL.
5 months ago 00:06:27 2
What Are KPIs? 5 TOP TIPS For Defining YOURS. BI For Beginners
5 months ago 17:07:42 1
Database Systems - Cornell University Course (SQL, NoSQL, Large-Scale Data Analysis)
5 months ago 00:57:55 1
Data Analyst Portfolio Project (Exploratory Data Analysis With Python Pandas)
5 months ago 01:01:21 1
Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
5 months ago 00:53:41 1
Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard
5 months ago 00:44:43 1
Data Analyst Portfolio Project #1 | Build a Database | Develop SQL | Create a Dashboard
5 months ago 00:40:50 1
Full Project in Excel | Excel Tutorials for Beginners