Clean Data in SQL using MySQL Workbench

4.7
stars

12 ratings

Offered By
In this Guided Project, you will:
2 hours
Intermediate
No download needed
Split-screen video
English
Desktop only

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.

Skills you will develop

  • Mysql Workbench

  • MySQL Database Cleaning

  • MySQL REGEXP

  • MySQL Normalization

  • MySQL

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently Asked Questions