Master SQL from Beginner to Expert in Just 4 Hours 🚀

💻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*