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-203010 ай бұрын
Fantastic way of expressing knowledge and practical aspects of using sql to clean the data. THANKS FOR VALUABLE GUIDANCE
@rodrigo100kk20 күн бұрын
8:04 Common SQL Queries - Practical coding starts here.
@amansaini7103 жыл бұрын
This is the amazing course I already enrolled in it 👍👍
@harshitgupta68543 жыл бұрын
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 😭
@eluxury22 жыл бұрын
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.
@oktoputra134411 ай бұрын
I love her smile
@antoniocarlosvieiracaetano32083 жыл бұрын
I'll definitely enroll in it!
@greenshadowooo Жыл бұрын
Very useful introduction
@lovelymelch35104 күн бұрын
how will we know if the table is clean or not? considering that there will be millions of rows of data.
@akin2420022 жыл бұрын
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.
@bretaddison41462 жыл бұрын
1 week to learn SQL !
@abdullahanwar16368 ай бұрын
0:00 use sql
@emmanuelmorris8122 жыл бұрын
Well understood.
@shatakarni44182 жыл бұрын
hey I dont know who you are.. thanks for this video. it cleared all my mind before interview.
@lindad14182 жыл бұрын
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
@joxa61192 жыл бұрын
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
@Tanhweiying2 жыл бұрын
Would like to know what is the speaker name? I like her way to present it ..
@eluxury22 жыл бұрын
Her name is Sally. I like her a lot too. She is very clear, but the course itself is kind of confusing.
@ompandey20122 жыл бұрын
whats the point of paying course.
@johnstoneolefa9132 жыл бұрын
To pay more attention since it's an investment
@bayou__9 ай бұрын
❤❤
@ribellaartwork64042 жыл бұрын
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.