Working with DDL

Oracle 12c    |    Beginner
  • 18 videos | 1h 10m 10s
  • Earns a Badge
Rating 4.7 of 182 users Rating 4.7 of 182 users (182)
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

  • Locked
    1.  Database Objects and their Naming Rules
    4m 18s
    After completing this video, you will be able to describe the DDL database objects and the associated naming rules. FREE ACCESS
  • Locked
    2.  Creating Tables
    4m 39s
    In this video, find out how to use the CREATE TABLE SQL command to create new tables in a database. FREE ACCESS
  • Locked
    3.  Data Types
    4m 26s
    In this video, you will identify the different data types used in Oracle databases when creating a table. FREE ACCESS
  • Locked
    4.  Specifying DEFAULT Option for Columns in a Table
    2m 45s
    Learn how to set a default value to be assigned to a column when creating a table. FREE ACCESS
  • Locked
    5.  Constraints and Constraint Guidelines
    2m 55s
    In this video, you will identify the different types of constraints and how these are used to enforce rules at a table level. FREE ACCESS
  • Locked
    6.  Defining Constraints
    4m 27s
    Upon completion of this video, you will be able to describe the syntax for defining constraints when creating a table. FREE ACCESS
  • Locked
    7.  NOT NULL and PRIMARY KEY Constraints
    4m 8s
    After completing this video, you will be able to describe the use of the NOT NULL and PRIMARY KEY constraints when creating a table. FREE ACCESS
  • Locked
    8.  UNIQUE Constraint
    4m 22s
    After completing this video, you will be able to describe the use of the UNIQUE constraint when creating a table. FREE ACCESS
  • Locked
    9.  Foreign Key Constraint
    4m 19s
    After completing this video, you will be able to describe the use of the FOREIGN KEY constraint when creating a table. FREE ACCESS
  • Locked
    10.  CHECK Constraint
    3m 31s
    After completing this video, you will be able to describe the use of the CHECK constraint. FREE ACCESS
  • Locked
    11.  Violating Constraints
    3m 40s
    Upon completion of this video, you will be able to describe the conditions when a constraint is not met. FREE ACCESS
  • Locked
    12.  Creating a Table Using a Subquery
    4m 43s
    Learn how to create a new table and insert rows by combining the CREATE TABLE and AS subquery options in a SQL statement. FREE ACCESS
  • Locked
    13.  ALTER TABLE Statement
    1m 40s
    During this video, you will learn how to change the definition of a table using the SQL command ALTER TABLE. FREE ACCESS
  • Locked
    14.  Working with Columns
    5m 50s
    To change the definition of a table, use the ALTER TABLE SQL command to add, modify, or drop columns in the table. FREE ACCESS
  • Locked
    15.  SET UNUSED Option
    3m 55s
    During this video, you will learn how to use the "SET UNUSED" option to mark columns as unused using the "ALTER TABLE" SQL command. FREE ACCESS
  • Locked
    16.  Read-only Tables
    2m 31s
    In this video, you will use the ALTER TABLE SQL command to set a table to read-only. FREE ACCESS
  • Locked
    17.  Dropping a Table
    2m 39s
    Learn how to use the DROP TABLE SQL command to delete a table from the database. FREE ACCESS
  • Locked
    18.  Exercise: Create and Work with Tables Using DDL
    5m 23s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 86 users Rating 4.7 of 86 users (86)
Course Oracle Database 12c R2 SQL: Restricting & Sorting Data
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 74 users Rating 4.6 of 74 users (74)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SELECT Statement, Expressions, & Operators
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)
Course Customizing Output
Rating 4.7 of 168 users Rating 4.7 of 168 users (168)
Course Data Conversion
Rating 4.6 of 203 users Rating 4.6 of 203 users (203)