Validate Data in SQL using MySQL Workbench

Offered By
Coursera Project Network
In this Guided Project, you will:

Create a Trigger to check for the existence of SQL data in an insert command.

Use a Trigger with SQL REGEXP to check for the exact data pattern.

Use an SQL Exists command within a trigger to check for existing data.

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will validate MySQL data in a MySQL database using SQL Triggers in MySQL Workbench. MySQL is a widely used relational database. Often data is validated by applications before being inserted into a database. It is a good idea to validate data at the database level, since applications may use inconsistent validation leaving the data at risk. MySQL workbench provides a User Interface to MySQL that allows the creation of triggers to perform validation before an insertion or update is performed.

Skills you will develop

  • SQL Triggers
  • Mysql Workbench
  • SQL REGEXP
  • SQL Validation
  • 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:

  1. Analyze an existing employees database table to Validate.

  2. Create a SQL Trigger to check for the null data.

  3. Use a Trigger decision construct with SQL to check for required strings.

  4. Use a Trigger with SQL REGEXP to check for the exact data pattern.

  5. Use an SQL Exists command within a trigger to check for existing data.

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

Frequently Asked Questions

More questions? Visit the Learner Help Center.