Clean Data in SQL using MySQL Workbench

By the end of this project, you will clean up MySQL student data in a MySQL database using SQL commands in MySQL Workbench. MySQL is a widely used relational database. Often data is incorrectly formatted, duplicated and/or lacks the granularity to perform proper analysis of a database. MySQL workbench provides a User Interface to MySQL data that allows the data analyst to Perform queries to check data, repair data, create tables, and insert data to clean up a database. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions

• Use SQL REGEX to check and clean address fields
• Create queries to display atomic values within address fields
• Insert data into address table using existing data with SQL

• Basic familiarity with software or workflow used
• Ability to follow step-by-step instructions in English