• Online, Self-Paced
Course Description

Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.

Learning Objectives

Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries

  • specify explicit default values in INSERT and UPDATE statements
  • describe when to use multitable INSERT statements
  • use the unconditional INSERT statement
  • use the conditional INSERT ALL statement
  • use the conditional INSERT FIRST statement
  • use the pivoting INSERT statement
  • use the MERGE statement
  • use the FLASHBACK TABLE statement
  • track changes in data
  • use the VERSIONS BETWEEN Clause
  • perform advanced queries

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.