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.

• 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

‣

Recall: The difference between spreadsheet and SQL: ‣

Learn basic SQL queries

‣