MySQL Database Development: Manipulating Data
MySQL
| Beginner
- 12 videos | 52m 25s
- Includes Assessment
- Earns a Badge
Data Manipulation Language (DML) statements are used to manipulate the actual data in MySQL databases. Explore the syntax and use of the most common DML statements, including INSERT, UPDATE, and DELETE.
WHAT YOU WILL LEARN
-
Describe the use of the insert, update, and delete dml statements, and recognize their basic syntax
Work with the insert statement to add new data to your mysql tables
Work with the update statement to modify existing data in your mysql tables
Work with the delete statement to remove existing data from your mysql tables
Use additional insert options to add new data to your mysql tables
Use additional update options to modify existing data in your mysql tables -
Use mysql workbench to insert and delete data in your tables
Use mysql workbench to view and modify existing data in your tables
Use mysql workbench to retrieve data from your tables using filters
Use mysql workbench to export existing data in your tables to an external file
Use mysql workbench to import existing data into your tables
Manipulate data using the dml statements and mysql workbench
IN THIS COURSE
-
4m 40sAfter completing this video, you will be able to describe the use of the INSERT, UPDATE, and DELETE DML statements, and recognize their basic syntax. FREE ACCESS
-
5m 3sFind out how to work with the INSERT statement to add new data to your MySQL tables. FREE ACCESS
-
3. Basic UPDATE Statements3m 6sDuring this video, you will learn how to work with the UPDATE statement to modify existing data in your MySQL tables. FREE ACCESS
-
4. DELETE Statements3m 56sIn this video, you will learn how to use the DELETE statement to remove existing data from your MySQL tables. FREE ACCESS
-
5. Advanced INSERT Statements5m 6sIn this video, you will learn how to use additional INSERT options to add new data to your MySQL tables. FREE ACCESS
-
6. Advanced UPDATE Statements4m 48sDuring this video, you will learn how to use additional UPDATE options to modify existing data in your MySQL tables. FREE ACCESS
-
7. Inserting and Deleting Data4m 57sIn this video, you will learn how to use MySQL Workbench to insert and delete data in your tables. FREE ACCESS
-
8. Viewing and Editing Data1m 58sIn this video, find out how to use MySQL Workbench to view and modify data in your tables. FREE ACCESS
-
9. Filtering Data3m 18sIn this video, you will learn how to use MySQL Workbench to retrieve data from your tables using filters. FREE ACCESS
-
10. Exporting Data4m 53sDuring this video, you will learn how to use MySQL Workbench to export data from your tables to an external file. FREE ACCESS
-
11. Importing Data5m 1sFind out how to use MySQL Workbench to import data into your tables. FREE ACCESS
-
12. Exercise: Using DML Statements and MySQL Workbench5m 41sIn this video, you will learn how to manipulate data using the DML statements and MySQL Workbench. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
