💻Take my Full MySQL Course Here: https://www.analystbuilder.com/courses/mysql-for-data-analytics

Download MySQL: https://dev.mysql.com/downloads/installer/

Download Datasets: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series
____________________________________________ 

RESOURCES:

💻Analyst Builder - https://www.analystbuilder.com/

📖Take my Full MySQL Course Here: https://bit.ly/3tqOipr
📖Take my Full Python Course Here: https://bit.ly/48O581R
📖Practice Technical Interview Questions: https://bit.ly/46pDqqL

Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN

Udemy Courses:
Python for Data Science - https://bit.ly/3Z4A5K6
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvN

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________ 

BECOME A MEMBER - 

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join
____________________________________________ 

Websites: 
💻Website: AlexTheAnalyst.com
💾GitHub: https://github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:52 Installing MySQL and Setting up Database
11:19 Select Statement
21:47 Where Clause
33:54 Group By
44:18 Having vs Where
47:41 Limit and Aliasing
51:10 Joins
1:08:04 Unions
1:15:10 String Functions
1:26:39 Case Statements
1:35:16 Subqueries
1:45:58 Window Functions
1:58:55 CTEs
2:09:07 Temp Tables
2:16:34 Stored Procedures
2:28:51 Triggers and Events
2:42:46 Data Cleaning Project
3:32:14 Exploratory Data Analysis Project

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

YouTube

This post provides a comprehensive SQL tutorial, covering everything from setting up the MySQL environment to fundamental and advanced SQL topics. It includes exercises on data selection, querying, data cleaning, and exploratory data analysis, with two practical projects at the end. The tutorial is designed for beginners and progresses to advanced topics such as CTEs and temp tables.

Learn SQL Beginner to Advanced in Under 4 Hours