4.3.Cleaning data with SQL - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

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

---

• Using SQL to clean data
• Learn basic SQL queries
• Transforming data
• Weekly challenge 3