• Online, Self-Paced
Course Description

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

  • process a transaction using explicit transaction control statements

 

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.