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 SQL
add rows to a table in the database by using the INSERT SQL statement
work with NULL values during the INSERT SQL statement when adding rows to a table
work with SPECIAL values during the INSERT SQL statement when adding rows to a table
work with specific DATE and TIME values during the INSERT SQL statement when adding rows to a table
save commands with substitution variables to a file and execute the commands in the file
use the INSERT SQL statement to copy rows from one table to another -
change data in a table using the UPDATE SQL statement
change data into two columns using a subquery to update the two columns using the UPDATE SQL statement
change the rows in a table based on a different table using the UPDATE SQL statement
remove rows from a table using the DELETE SQL statement
remove rows from a table based on a different table using the DELETE SQL statement
use the TRUNCATE SQL statement to delete all rows from a table
insert and update rows in a table
IN THIS COURSE
-
1. Data Manipulation Language2m 26sIn this video, you will learn about the Data Manipulation Language in SQL. FREE ACCESS
-
2. Adding New Rows to Tables using the INSERT Statement5m 9sIn this video, you will add rows to a table in the database by using the INSERT SQL statement. FREE ACCESS
-
3. Inserting Rows with Null Values5m 18sFind out how to work with NULL values during the INSERT SQL statement when adding rows to a table. FREE ACCESS
-
4. Inserting Rows with Special Values2m 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
-
5. Inserting Specific Date and Time Values2m 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
-
6. Creating a Script4m 7sLearn how to save commands with substitution variables to a file and execute the commands from the file. FREE ACCESS
-
7. Copying Rows from Another Table5m 55sLearn how to use the INSERT SQL statement to copy rows from one table to another. FREE ACCESS
-
8. Updating Rows in a Table7m 1sIn this video, you will learn how to change data in a table using the UPDATE SQL statement. FREE ACCESS
-
9. Updating Two Columns with a Subquery5m 28sFind out how to change data into two columns using a subquery. Update the two columns using the UPDATE SQL statement. FREE ACCESS
-
10. Updating Rows Based on Another Table4m 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
-
11. Deleting Rows from a Table4m 55sIn this video, find out how to remove rows from a table using the SQL DELETE statement. FREE ACCESS
-
12. Deleting Rows Based on Another Table3m 3sIn this video, you will remove rows from a table based on a different table using the DELETE SQL statement. FREE ACCESS
-
13. TRUNCATE Statement3m 7sIn this video, find out how to use the TRUNCATE SQL statement to delete all rows from a table. FREE ACCESS
-
14. Exercise: Manipulate Data in a Table6m 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.
