Data Manipulation Language
Oracle 12c
| Beginner
- 14 videos | 1h 3m 26s
- Earns a Badge
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.
WHAT YOU WILL LEARN
-
Define the data manipulation language in sqlAdd rows to a table in the database by using the insert sql statementWork with null values during the insert sql statement when adding rows to a tableWork with special values during the insert sql statement when adding rows to a tableWork with specific date and time values during the insert sql statement when adding rows to a tableSave commands with substitution variables to a file and execute the commands in the fileUse the insert sql statement to copy rows from one table to another
-
Change data in a table using the update sql statementChange data into two columns using a subquery to update the two columns using the update sql statementChange the rows in a table based on a different table using the update sql statementRemove rows from a table using the delete sql statementRemove rows from a table based on a different table using the delete sql statementUse the truncate sql statement to delete all rows from a tableInsert and update rows in a table
IN THIS COURSE
-
2m 26sIn this video, you will learn about the Data Manipulation Language in SQL. FREE ACCESS
-
5m 9sIn this video, you will add rows to a table in the database by using the INSERT SQL statement. FREE ACCESS
-
5m 18sFind out how to work with NULL values during the INSERT SQL statement when adding rows to a table. FREE ACCESS
-
2m 35sIn this video, you will learn how to work with special values during the INSERT SQL statement when adding rows to a table. FREE ACCESS
-
2m 52sIn this video, you will work with specific date and time values during the insert SQL statement when adding rows to a table. FREE ACCESS
-
4m 7sLearn how to save commands with substitution variables to a file and execute the commands from the file. FREE ACCESS
-
5m 55sLearn how to use the INSERT SQL statement to copy rows from one table to another. FREE ACCESS
-
7m 1sIn this video, you will learn how to change data in a table using the UPDATE SQL statement. FREE ACCESS
-
5m 28sFind out how to change data into two columns using a subquery. Update the two columns using the UPDATE SQL statement. FREE ACCESS
-
4m 35sIn this video, learn how to change the rows in one table based on data from another table using the UPDATE SQL statement. FREE ACCESS
-
4m 55sIn this video, find out how to remove rows from a table using the SQL DELETE statement. FREE ACCESS
-
3m 3sIn this video, you will remove rows from a table based on a different table using the DELETE SQL statement. FREE ACCESS
-
3m 7sIn this video, find out how to use the TRUNCATE SQL statement to delete all rows from a table. FREE ACCESS
-
6m 55sIn this video, you will learn how to insert and update rows in a table. 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.YOU MIGHT ALSO LIKE

Channel
Database Core Concepts