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


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

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



Expected Duration (hours)
1.0

Lesson 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

    • Course Number:
    it_dfosfd_09_enus

    Expertise Level
    Beginner