Validate Data in SQL using MySQL Workbench

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 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:

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