Oracle Database 12c - Introduction to SQL: Data Manipulation Language from Skillsoft

Online, Self-Paced

Once an Oracle 12c relational database has been created with objects, the data in these objects need to be managed. In this course you will learn how to insert, update, delete, and truncate rows. The course will teach the concepts of database transaction control using COMMIT, ROLLBACK, and SAVEPOINT. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Learning Objectives

Managing Tables Using DML Statements

start the course
define the Data Manipulation Language in SQL
add rows to a table in the database by using the INSERT SQL statement

Inserting Rows

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

Updating Rows

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

Deleting Rows

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

Practice: Working with Data in Tables

insert and update rows in a table

Database Transactions

describe database transactions and how to ensure data consistency during DML, DDL and DCL activity on the database
describe the COMMIT and ROLLBACK SQL statements
describe the control of the logic within transactions
use the ROLLBACK SQL command to undo changes to a defined marker
describe the conditions in which an automatic COMMIT statement is issued and the impact on the database
describe the state of the database before and after a COMMIT SQL command within the database
describe the state of the database before a ROLLBACK SQL command within the database
describe read consistency and its role in the database
describe using the FOR UPDATE clause in a SQL statement

Practice: Working with Database Transactions