Basic Course
How to INSERT, UPDATE, or DELETE Data in MySQL
Have 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.
4.66
1,010 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 8 h
Coding challenges 70
Skills you will gain
- Use SQL DML (Data Manipulation Language) commands.
- Work with SQL UPDATE, INSERT, and DELETE commands
- Deal with auto-filling values
- Combine SQL DML commands with NULLs and JOINs
- Modify data using columns’ default values
Last reviews
Description
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.
What Do You Need to Take This Course?
- A web browser and an Internet connection.
- Basic knowledge of SQL
This Course Will Teach You How To:
- Use SQL DML (Data Manipulation Language) commands.
- Work with SQL UPDATE, INSERT, and DELETE commands
- Deal with auto-filling values
- Combine SQL DML commands with NULLs and JOINs
- Modify data using columns’ default values
Who Should Take This Course?
- Users who completed the SQL Basics in MySQL course
- Aspiring Database Administrators (DBAs)
- Software testers
- Programmers working with databases
- Business professionals who use MySQL
- MySQL enthusiasts
- Anyone who’d like to improve their MySQL DML skills.
What's In It for Me?
- 70 interactive exercises. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
- Lifetime access to the course. When you purchase this course, you’ll get instant personal access to all of its content.
- Certificate of completion. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
- 30-day money-back guarantee. If you’re not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
- Hints and help. There are hints available in the exercises to help you if you get stuck. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line – we’ll be more than happy to answer! 😉
Table of contents
Course progress 0%
Exercises completed 0/70
-
Learn the basic data manipulation operations in MySQL: INSERT, UPDATE, and DELETE
-
Practice the advanced version of data manipulation operations in MySQL.
-
Learn how you can use default values in a database.
-
Learn to use other tables in INSERT, UPDATE, and DELETE operations in MySQL.
-
Do you remember how to insert, delete, and update in MySQL?
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills