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
I really love the way she was happy during the session and explaining concepts in such a beautiful way . Google career videos gives us a sneak peek of how is exactly the thought process of google employees. Thankyou
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?
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.
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
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.
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.
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 UA-cam. I do love to to take the paid version of the course but I don't have the financial capacity to pay currently.
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
Fantastic way of expressing knowledge and practical aspects of using sql to clean the data.
THANKS FOR VALUABLE GUIDANCE
I really love the way she was happy during the session and explaining concepts in such a beautiful way . Google career videos gives us a sneak peek of how is exactly the thought process of google employees. Thankyou
8:04 Common SQL Queries - Practical coding starts here.
This is the amazing course I already enrolled in it 👍👍
you have joined paid course ?
How to join this course
Very useful introduction
I'll definitely enroll in it!
1 week to learn SQL isn't reasonable, but glad it worked for you.
She is likely referring to learning basic querying.
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?
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.
@@ChristopherKaiJensen Thank you for the info! So does that mean as an data analyst, I don't have to clean data?
@@ChristopherKaiJensen so a data analyst needs to clean results for pretty much every query and analysis? That seems inefficient.
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
R is just tears everywhere 😭
@@magdalenekimani8549 are you and a data analyst in KE?
I love her smile
0:00 use sql
hey I dont know who you are.. thanks for this video. it cleared all my mind before interview.
TQ for giving your time for us GOOGLE #sally
1 week to learn SQL !
how will we know if the table is clean or not? considering that there will be millions of rows of data.
Good
Thank you.
Well understood.
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
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.
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.
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 UA-cam. I do love to to take the paid version of the course but I don't have the financial capacity to pay currently.
I do not think that's an advisable thing to do...
You can take it for free on the direct site
Would like to know what is the speaker name? I like her way to present it ..
Her name is Sally. I like her a lot too. She is very clear, but the course itself is kind of confusing.
whats the point of paying course.
To pay more attention since it's an investment
❤❤
The way she says 'dada' instead of 'data' hurts my English ears but very good course and overall very good explanations.
Please don't say more "underscore" it's killin me...
she's cute 😘