The Ultimate Guide to Data Cleaning in SQL

  Рет қаралды 10,555

Team Acho

Team Acho

Күн бұрын

Learn how to clean your data in this Ultimate Guide to Data Cleaning in SQL! Read more about it here: acho.io/blogs/the-ultimate-gu...
Visit our site: acho.io/
Find us on LinkedIn: / teamacho
Follow us on Twitter: / team_acho
Join our Discord Channel: / discord
Contact us via Email: contact@acho.io
Chapters:
0:00 Intro
1:02 Step 1: Remove Irrelevant Data
1:47 Step 2: Remove Duplicate Data
2:48 Step 3: Fix Structural Errors
3:26 Step 4: Convert Types
4:43 Step 5: Handle Missing Data
6:19 Step 6: Deal with Outliers
7:54 Step 7: Standardize/Normalize Data
8:35 Step 8: Validate Data

Пікірлер: 12
@jenkinsade2111
@jenkinsade2111 14 күн бұрын
You just earned a follow. Great video, straightforward and concise. 👍🏿
@rareflower88
@rareflower88 10 ай бұрын
Thanks so much! Excellent, concise video showing useful functions, and a starting standard for cleaning data. Thank you!
@eduardobueno578
@eduardobueno578 10 ай бұрын
This tutorial was amazing!
@loganphillips7749
@loganphillips7749 8 ай бұрын
Straight to the point 👌🏻
@SandeepGurjar-ko5ju
@SandeepGurjar-ko5ju Жыл бұрын
Excellent Content, Your grasp on SQL is amazing.
@teamacho926
@teamacho926 Жыл бұрын
Thank you, there's more to come. Stay tuned!
@manishareddy968
@manishareddy968 9 ай бұрын
plz help me to treat outliers
@jarvis7057
@jarvis7057 3 ай бұрын
please share the dataset or source link if possible
@manishareddy968
@manishareddy968 9 ай бұрын
Approx_quantiles is not showing as inbuilt function, what should I do to treat outliers
@manishareddy968
@manishareddy968 9 ай бұрын
plz help me to treat outliers
@gmehz9605
@gmehz9605 Жыл бұрын
Though you provide a good explanation you are way too fast in your demonstration and for people who have only started to learn SQL it is not helpful at all. Had to pause multiple times to re-read and understand.
@johnvak7390
@johnvak7390 5 ай бұрын
dang ur cute
Data Cleaning in SQL | Google Data Analytics Certificate
42:16
Google Career Certificates
Рет қаралды 119 М.
Data Cleaning in MySQL | Full Project
51:11
Alex The Analyst
Рет қаралды 103 М.
Fast and Furious: New Zealand 🚗
00:29
How Ridiculous
Рет қаралды 17 МЛН
WHAT’S THAT?
00:27
Natan por Aí
Рет қаралды 14 МЛН
Summer shower by Secret Vlog
00:17
Secret Vlog
Рет қаралды 9 МЛН
Master Data Cleaning Essentials on Excel in Just 10 Minutes
10:16
Kenji Explains
Рет қаралды 533 М.
The ONLY Data Analytics Portfolio You Need (GUARANTEED Job)
9:18
Learn with Lukas
Рет қаралды 146 М.
Data Cleaning in SQL
1:48:54
Wisabi Analytics
Рет қаралды 2,4 М.
Cleaning Data in Excel | Excel Tutorials for Beginners
21:04
Alex The Analyst
Рет қаралды 510 М.
Data Modeling in the Modern Data Stack
10:14
Kahan Data Solutions
Рет қаралды 96 М.
Understanding Data Cleaning | Google Data Analytics Certificate
1:06:05
Google Career Certificates
Рет қаралды 177 М.
Data Cleaning Tutorial - Practical SQL & Python Tips
13:04
Lore So What
Рет қаралды 3,2 М.
SQL Beginner to Advanced in One Hour | CareerFoundry Webinar
1:08:28
Alex The Analyst
Рет қаралды 209 М.
НЕ БЕРУ APPLE VISION PRO!
0:37
ТЕСЛЕР
Рет қаралды 348 М.
Я купил первый в своей жизни VR! 🤯
1:00
Вэйми
Рет қаралды 2,6 МЛН