You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on May 23, 2024. It is now read-only.
Seongjoo Brenden Song edited this page Jul 10, 2021
·
2 revisions
Knowing a variety of ways to clean data can make an analyst’s job much easier. In this part of the course, you’ll check out how to clean your data using SQL. You’ll explore queries and functions that you can use in SQL to clean and transform your data to get it ready for analysis.
Learning Objectives
Describe how SQL can be used to clean large datasets
Compare spreadsheet data-cleaning functions to those associated with SQL in databases
Develop basic SQL queries for use with databases
Apply basic SQL functions for use in cleaning string variables in a database
Apply basic SQL functions for transforming data variables