Data Cleaning in SQL | Google Data Analytics Certificate

Learn about the different data cleaning functions in spreadsheets and SQL, and how SQL can be used to clean large datasets. See how to develop basic search queries for databases and how to apply basic SQL functions for transforming data and cleaning strings.
0:00 Use SQL to Clean Data
0:28 Understanding SQL Capabilities
3:49 SQL vs. Spreadsheets
8:04 Common SQL Queries
14:15 Cleaning String Variables Using SQL
27:03 Advanced Data Cleaning Functions
33:25 Advanced Data Cleaning Functions Pt. 2
This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.
The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.
Take the Certificate HERE: goo.gle/3YZJx1Z
Subscribe HERE: bit.ly/Subscri...
#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics
Why earn a Google Career Certificate?
► No experience necessary: Learn job-ready skills, with no college degree required.
► Learn at your own pace: Complete the 100% online courses on your own terms.
► Stand out to employers: Make your resume competitive with a credential from Google.
► A path to in-demand jobs: Connect with top employers who are currently hiring.

[@inhlam5909]

0:00 Use SQL to Clean Data 0:28 Understanding SQL Capabilities 3:49 SQL vs. Spreadsheets 8:04 Common SQL Queries * SELECT, FROM, WHERE 14:15 Cleaning String Variables Using SQL * SUBSTR, LENGTH 27:03 Advanced Data Cleaning Functions * CAST, TRIM 33:25 Advanced Data Cleaning Functions Pt. 2 * CAST, CONCAT, COALESCE

[@SBS-2030]

Fantastic way of expressing knowledge and practical aspects of using sql to clean the data. THANKS FOR VALUABLE GUIDANCE

[@rodrigo100kk]

8:04 Common SQL Queries - Practical coding starts here.

[@amansaini710]

This is the amazing course I already enrolled in it 👍👍

[@harshitgupta6854]

you have joined paid course ?

[@abhinav8160]

How to join this course

[@amaebarnes]

I learned R Studio for my economics degree. I want to transition to a data analyst career. I was afraid to learn a new language but SQL looks like a breeze compared to R

[@magdalenekimani8549]

R is just tears everywhere 😭

[@eluxury2]

I was very confused at the end of this class. I love the instructor but the cleaning process has not been well-explained. For instance, how do I get a clean table when all cleaning results are saved separately?

[@ChristopherKaiJensen]

If you want the table cleaned, you would either need to be in a position where you have permission to clean that table yourself, or alert your DBA or the team with the ability to clean the table to do so. This may be done using updating table values which is simple, or updating table schema, which can affect any and all tables and/or systems that interact with that table. This is why she says to not update the table if you didn't create it. What she really means is don't update it if you do not have permission or authority to do so. There are certainly cases where your role as a data analyst will involve express permissions from your manager to update table data or even schema. Generally though, schema especially is handled by the DBA (Database Administrator), not Data Analysts.

[@eluxury2]

@@ChristopherKaiJensen Thank you for the info! So does that mean as an data analyst, I don't have to clean data?

[@bunnyboops8875]

@@ChristopherKaiJensen so a data analyst needs to clean results for pretty much every query and analysis? That seems inefficient.

[@oktoputra1344]

I love her smile

[@antoniocarlosvieiracaetano3208]

I'll definitely enroll in it!

[@greenshadowooo]

Very useful introduction

[@lovelymelch3510]

how will we know if the table is clean or not? considering that there will be millions of rows of data.

[@akin242002]

1 week to learn SQL isn't reasonable, but glad it worked for you.

[@ChristopherKaiJensen]

She is likely referring to learning basic querying.

[@kamleshsatpaise]

TQ for giving your time for us GOOGLE #sally

[@user-si6iz9fj1f]

Good

[@CrazyWatcher670]

Thank you.

[@bretaddison4146]

1 week to learn SQL !

[@abdullahanwar1636]

0:00 use sql

[@emmanuelmorris812]

Well understood.

[@shatakarni4418]

hey I dont know who you are.. thanks for this video. it cleared all my mind before interview.

[@lindad1418]

i am confused on why we put TRIm in the where statement to update but put CAST in the select statement to update...anyone know? TIA

[@joxa6119]

CAST() is for converting data-type. ie; the actual data is in number, but the table showing that is a STRING. hence use CAST() to convert the data into a float.

[@mini-thegingercat.1175]

Because we are not filtering out purchase but we want it as float so we use it in SELECT whereas we want to filter data by trimming it So, we use it in WHERE.

[@sadiqpeter9294]

nice content and thanks for uploading this. can I update my resume indicating I took this course without having to pay for the course after finishing the free version here in KZbin. I do love to to take the paid version of the course but I don't have the financial capacity to pay currently.

[@olawalejunior7940]

I do not think that's an advisable thing to do...

[@shaquillabrown8216]

You can take it for free on the direct site

[@Tanhweiying]

Would like to know what is the speaker name? I like her way to present it ..

[@eluxury2]

Her name is Sally. I like her a lot too. She is very clear, but the course itself is kind of confusing.

[@ompandey2012]

whats the point of paying course.

[@johnstoneolefa913]

To pay more attention since it's an investment

[@bayou__]

❤❤

[@ribellaartwork6404]

Please don't say more "underscore" it's killin me...

[@MountRushCollymore]

The way she says 'dada' instead of 'data' hurts my English ears but very good course and overall very good explanations.

[@SephiaSkiesChannel]

she's cute 😘