• Online, Self-Paced
Course Description

Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.

Learning Objectives

Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language

  • define the Data Manipulation Language in SQL
  • add rows to a table in the database by using the INSERT SQL statement
  • insert rows with NULL values
  • insert a special value in a table
  • change data in a table using the UPDATE statement
  • remove rows from a table using the DELETE and TRUNCATE statement
  • use the COMMIT and ROLLBACK statements
  • use the SAVEPOINT statement
  • describe a statement level rollback
  • guarantee consistent view of data at all times
  • demonstrate when to use the FOR UPDATE and LOCK table statements
  • insert and update rows in a table

Framework Connections

Specialty Areas

  • Data Administration
  • Systems Administration