• Online, Self-Paced
Course Description

Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.

Learning Objectives

Oracle Database 12c R2 SQL: Data Definition Language (DDL)

  • provide an overview of DLL, and describe the DDL database objects and the associated naming rules
  • use the CREATE TABLE SQL command to create new tables in the database
  • identify the different Oracle database data types used when creating a table
  • define a default value to be assigned to a column when creating a table
  • identify the different types of constraints and how these are used to enforce rules at a table level
  • define constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK
  • create a new table and insert rows by combining CREATE TABLE and AS in a SQL statement
  • change the definition of a table using the ALTER TABLE SQL command
  • mark columns as unused with the SET UNUSED statement
  • remove unused columns
  • use the DROP TABLE SQL command to delete a table from the database
  • create and work with tables using DDL

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.