💻Take my Full MySQL Course Here: Download MySQL: Download Datasets: ____________________________________________ RESOURCES: 💻Analyst Builder - 📖Take my Full MySQL Course Here: 📖Take my Full Python Course Here: 📖Practice Technical Interview Questions: Coursera Courses: Google Data Analyst Certification: Data Analysis with Python - IBM Data Analysis Specialization - Tableau Data Visualization - Udemy Courses: Python for Data Science - Statistics for Data Science - SQL for Data Analysts (SSMS) - Tableau A-Z - *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! ____________________________________________ Websites: 💻Website: 💾GitHub: 📱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*