• Online, Self-Paced
Course Description

Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.

Learning Objectives

Oracle Database 12c R2 SQL: Managing Schema Objects    

  • add a constraint
  • drop a constraint
  • delete child rows using the ON DELETE CASCADE and DELETE SET NULL clauses
  • use the CASCADE CONSTRAINTS clause
  • disable and enable constraints
  • describe indexes
  • create an index
  • retrieve index information using USER_INDEXES
  • create a temporary table
  • describe the benefits of external tables
  • create external tables using the CREATE TABLE statement
  • query external tables
  • work with database objects

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.