Navigate Select ESC Close

Data Cleaning in MySQL | Full Project

2024-04-16 Education
422.7k
8.9k
1.2k
Alex The Analyst
Alex The Analyst
1.4m subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to be building a data cleaning project in MySQL! Download Dataset: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/layoffs.csv GitHub Code: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Portfolio%20Project%20-%20Data%20Cleaning.sql ____________________________________________ SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________ RESOURCES: 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 ____________________________________________ *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*

Top Comments (10)

@anyamunkh1787 2024-04-21

Watched all the ads without even skipping, that's how much I am grateful for your work and time you put into this.

273 4 replies
@prominentmedia6329 2025-06-01

I’m happy to share with you guys I started my data analyst journey on May 4 and from then I don’t relent and don’t get tired I was able to cover Excel and MySQL class and I landed my first client on upwork for data cleaning and I’m moving forward with the class … wish me success guys moving to power Bi class

193 9 replies
@clarke6814 2025-01-29

16:49 If anyone is having trouble here, I had an error code 1175. You just need to go to Edit-> Preferences-> SQL Editor -> and deselect the option "Safe Edits". You then have to exit and open again (save before you exit) and then run again. Edit: Alex explains this at 18:52

66 6 replies
@Dj__bigboy 2026-01-19

Im Happy to share that I got hired as a Business Intelligence Analyst 😍😍😍 Thank you so much for those videos, it's really motivated to get hired👍

61 14 replies
@10cutie207 2024-04-16

Alex! This is why I subscribed, thank you so much for doing this in MySQL!!

39
@fernandasubekti 2024-10-14

"Deleting data is a very interesting thing to do, you have to be confident. Am i 100 confident? not really", LOL 😂

29
@avilagustin 2024-08-12

Hola Alex, soy de Argentina y estoy viendo todo el Bootcamp con subtítulos. Eres una persona maravillosa a la hora de explicar las cosas, siento como que un amigo me está explicando los temas. Muchas gracias por lo que hiciste.

14
@mohammadusmanali-v4j 2026-02-13

I want to sincerely thank Alex for his incredible work. This MySQL project has been a revelation, and his humble, clear teaching is a breath of fresh air—especially when compared to the arrogance we often see from some of our local professors. His generosity in sharing knowledge is truly inspiring.

6
@karencc6107 2026-01-31

I just finished this project and it took me several hours to complete because when I ran the scripts, there were some errors that it didn't detect, but I learned a lot. Thanks, Alex!

6
@الكاشفللروحانيات 2026-05-18

This is why I subscribed thank you so much for doing this in MySQL!!

1

Unlock the Data Inside
Turn Videos into Knowledge

  • Get FREE 10/day: transcripts, summaries, chats
  • Chat with videos, export text & PDF
  • $1 free API credit for RAG, chatbots & research

Free forever plan • All features unlocked

App screenshot