Working with DDL

Oracle 12c    |    Beginner
  • 18 Videos | 1h 15m 10s
  • Earns a Badge
Likes 57 Likes 57
There's a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.

WHAT YOU WILL LEARN

  • 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
    describe the syntax for defining constraints when creating a table
    describe the use of the NOT NULL and PRIMARY KEY constraints when creating a table
    describe the use of the UNIQUE constraint when creating a table
    describe the use of the FOREIGN KEY constraint when creating a table
  • describe the use of the CHECK constraint
    describe the conditions when a constraint is violated
    create a new table and insert rows by combining the CREATE TABLE and the AS subquery option in a SQL statement
    change the definition of a table using the ALTER TABLE SQL command
    change the definition of a table by adding, modifying, and dropping columns in a table using the ALTER TABLE SQL command
    use the SET UNUSED option to mark columns as unused using the ALTER TABLE SQL command
    use the ALTER TABLE SQL command to set a table to read only
    use the DROP TABLE SQL command to delete a table from the database

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

COURSE SQL Developer
Likes 285 Likes 285  
Likes 223 Likes 223  
Likes 37 Likes 37