From the course: End-to-End SQL Database Design and Optimization Project
Join today to access over 25,500 courses taught by industry experts.
Implementing data validation - SQL Tutorial
From the course: End-to-End SQL Database Design and Optimization Project
Implementing data validation
- [Instructor] In the last chapter, we completed the ETL process and successfully loaded the transformed data into our MySQL database. Now it's crucial to validate this data to ensure it's accurate, complete, and ready for further use. Data validation is the process of checking your database to ensure that the data adheres to specific standards and rules. Now, this step is essential to maintain data quality and reliability. Let's now navigate back to our MySQL Workbench. To do so, you're going to go to finder, applications, and find MySQL Workbench if you're on a Mac like myself, or you're going to go to your Windows start menu, then select applications and find MySQL Workbench. Once you've done that, you're going to be greeted with a screen much like what you see in front of you here. You then want to go back to your connection that you established earlier, which is the e-commerce database setup. Once you've done that, you're going to see a screen like what you see here. Now, to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.