Data Cleaning in SQL | Google Data Analytics Certificate

Рет қаралды 117,412

Күн бұрын

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/SubscribeGCC
#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.

Пікірлер: 37

@Anacon2023 8 ай бұрын

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

@antoniocarlosvieiracaetano3208 3 жыл бұрын

I'll definitely enroll in it!

@emmanuelmorris812 2 жыл бұрын

Well understood.

@greenshadowooo Жыл бұрын

Very useful introduction

@inhlam5909 2 жыл бұрын

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

@CrazyWatcher670 Жыл бұрын

Thank you.

@oktoputra1344 10 ай бұрын

I love her smile

@amansaini710 3 жыл бұрын

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

@harshitgupta6854 3 жыл бұрын

you have joined paid course ?

@abhinav8160 Жыл бұрын

How to join this course

@kamleshsatpaise Жыл бұрын

TQ for giving your time for us GOOGLE #sally

@user-si6iz9fj1f Жыл бұрын

Good

@bretaddison4146 2 жыл бұрын

1 week to learn SQL !

@akin242002 2 жыл бұрын

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

@ChristopherKaiJensen Жыл бұрын

She is likely referring to learning basic querying.

@amaebarnes 11 ай бұрын

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 11 ай бұрын

R is just tears everywhere 😭

@bayou__ 8 ай бұрын

❤❤

@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.

@shatakarni4418 2 жыл бұрын

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

@lindad1418 2 жыл бұрын

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 2 жыл бұрын

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.

@abdullahanwar1636 7 ай бұрын

0:00 use sql

@Tanhweiying 2 жыл бұрын

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.

@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 KZfaq. 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