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

Oracle SQL 12c
  • 12 Videos | 1h 8m 13s
  • Includes Assessment
  • Earns a Badge
Likes 19 Likes 19
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE