Course
BasicHave you already learned the basics of SQL? Now it's time for the next step: adding, changing, and removing data in MySQL using the INSERT, UPDATE and DELETE statements.
In this course you will learn how to modify data in a MySQL database: how to add, change, or remove data. It’s a required skill if you want to be fluent in SQL.
As a beginning SQL user, you most likely already know the SELECT statement. But working with data is much more than just getting data from a database. In this MySQL course, you'll learn the INSERT, UPDATE, and DELETE statements, which let you modify the data in a database. Mastering these commands is essential to becoming an SQL expert.
How to INSERT, UPDATE, or DELETE Data in MySQL is interactive. You practice by writing real SQL code and solving exercises directly in your web browser. Our online platform runs your code and verifies your solution. You don't need to install any software on your computer.
This track uses MySQL 8. However, users working with MySQL 5 and earlier can also take it. The features that are only available in MySQL 8 are clearly marked.
Course progress
Exercises completed
1.
Learn the basic data manipulation operations in MySQL: INSERT, UPDATE, and DELETE
2.
Practice the advanced version of data manipulation operations in MySQL.
3.
Learn how you can use default values in a database.
4.
Learn to use other tables in INSERT, UPDATE, and DELETE operations in MySQL.
5.
Do you remember how to insert, delete, and update in MySQL?