Data Cleaning in SQL Google Data Analytics Certificate

Learners: 81,157

Instructor: Google Career Certificates

Duration:

Learn how to use SQL to clean data and develop basic search queries for databases with the Google Data Analytics Certificate. Get job-ready skills in about 6 months and stand out to employers with a credential from Google. Start or advance your career in data analytics today! Visit https://goo.gle/2NCbbSc to learn more. ▼▲

Course Feature Course Overview Pros & Cons Course Provider Discussion and Reviews

Go to class

Course Feature

Cost:

Free

Provider:

Youtube

Certificate:

No Information

Language:

English

Start Date:

2021-06-11 00:00:00

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 20th, 2023]

This course provides an overview of data cleaning in SQL and spreadsheets. Learners will gain an understanding of the capabilities of SQL and how it can be used to clean large datasets. They will learn how to develop basic search queries for databases and how to apply basic SQL functions for transforming data and cleaning strings. Additionally, learners will explore advanced data cleaning functions. By the end of the course, learners will have the skills to clean data in SQL and spreadsheets.

Pros & Cons

Pros Cons

Comprehensive coverage of SQL data cleaning techniques: Users appreciate that the course covers various SQL capabilities and queries for data cleaning. They find the content useful for understanding and implementing data cleaning tasks.
Free availability and accessibility: Users express gratitude for the course being available for free on YouTube. They find it beneficial to have access to such valuable content without the need for financial investment.

Lack of clarity in explaining the cleaning process: One user mentions being confused about the cleaning process and how to obtain a clean table when the cleaning results are saved separately. This indicates a potential lack of clarity in explaining the concepts and steps involved in data cleaning.
Confusion regarding the usage of SQL functions: Another user expresses confusion about the usage of different SQL functions, specifically questioning why TRIM is used in the WHERE statement for updating, while CAST is used in the SELECT statement for updating. This confusion suggests that the course may not adequately address the rationale behind using specific functions in different contexts.