Learn SQL for FREE! ✅ Analysts Beginner to Pro Tutorial: The Fastest Way to Master SQL

Learning SQL, as an analyst, can be overwhelming if you do not know where to start with the number of different commands out there. That’s why in this video I cover what you need to know to get by using SQL, and feel comfortable tackling any requests that come your way.

📁 Dataset used and SQL Queries -
https://data.world/deanchereden/sql-j...

▶️ 7 BEST places for FREE DATASETS to analyse / projects/practice on -
   • 7 BEST places for FREE DATASETS to an...  

▶️ How to Practice SQL on ANY DATASET Online for FREE ✔ -
   • How to Practice SQL on ANY DATASET On...  

▶️ How to INSTALL SQL Server, Management Studio and IMPORT a database and CSV excel file -
   • How to INSTALL SQL Server, Management...  


🔖c h a p t e r s 🔖

00:00 - Intro
01:11 - data.world datasets
02:07 - Viewing tables to check data
02:57 - SELECT * FROM
04:34 - LIMIT / TOP
05:58 - ORDER BY
08:20 - Query table data you only need to export
09:02 - SELECT column name
09:47 - AS - Alias
11:37 - WHERE
14:43 - BETWEEN / NOT BETWEEN / AND / OR / IN / NOT IN
20:50 - LIKE / NOT LIKE
24:02 - IS NULL / IS NOT NULL
27:12 - Joins - Inner / Left / Right / Full
27:27 - JOIN / INNER JOIN example
30:38 - Join 2 additional tables
31:49 - Rename joined table columns with AS
35:16 - INNER JOIN
36:39 - LEFT JOIN
37:57 - RIGHT JOIN
39:19 - FULL JOIN
41:23 - Aggregation / Group By
41:46 - COUNT
43:03 - COUNT DISTINCT
43:48 - DISTINCT
44:45 - SUM
46:10 - GROUP BY
47:46 - YEAR
48:47 - AVG / MIN / MAX
52:04 - HAVING
52:44 - Ad hoc examples / interview questions
53:22 - CASE


💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter -   / deanchereden  

🎵 Music - Misha, Jussi Halme - Higher https://chll.to/4ec991f9

🙌 Follow Misha
・ SoundCloud: https://chll.to/386e721b
・ Spotify: https://chll.to/5f0bc9ba
・ Apple Music: https://chll.to/5a239af3
・ Chillhop: https://chll.to/2b2bc310

🙌 Follow Jussi Halme
・ Spotify: https://chll.to/dd4a82d2
・ Apple Music: https://chll.to/4961c878
・ Chillhop: https://chll.to/eb17b45e

🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felici...