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 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
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.
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 RUclips. 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
This is the amazing course I already enrolled in it 👍👍
you have joined paid course ?
How to join this course
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 😭
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 love her smile
I'll definitely enroll in it!
how will we know if the table is clean or not? considering that there will be millions of rows of data.
1 week to learn SQL isn't reasonable, but glad it worked for you.
She is likely referring to learning basic querying.
Very useful introduction
TQ for giving your time for us GOOGLE #sally
8:04 Common SQL Queries - Practical coding starts here.
Good
hey I dont know who you are.. thanks for this video. it cleared all my mind before interview.
Thank you.
Well understood.
1 week to learn SQL !
0:00 use sql
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 RUclips. 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 😘