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

Oracle SQL 12c    |    Beginner
  • 12 videos | 1h 2m 43s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 30 users Rating 4.7 of 30 users (30)
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

  • 5m 42s
    After completing this video, you will be able to provide an overview of DLL, and describe the DDL database objects and the associated naming rules. FREE ACCESS
  • 4m 51s
    In this video, learn how to use the CREATE TABLE SQL command to create new tables in a database. FREE ACCESS
  • Locked
    3.  Data Types
    6m 30s
    In this video, you will learn how to identify the different Oracle database data types used when creating a table. FREE ACCESS
  • Locked
    4.  Specify the DEFAULT Option for Columns in a Table
    6m 27s
    In this video, learn how to set a default value to be assigned to a column when creating a table. FREE ACCESS
  • Locked
    5.  Overview of Constraints
    8m 26s
    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.  Working with Constraints
    7m 18s
    In this video, you will learn how to define constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK. FREE ACCESS
  • Locked
    7.  Creating Tables Using Subqueries
    3m 34s
    To create a new table and insert rows, combine the CREATE TABLE and AS keywords in a SQL statement. FREE ACCESS
  • Locked
    8.  ALTER TABLE Statement
    4m 28s
    In this video, you will learn how to change the definition of a table using the SQL command ALTER TABLE. FREE ACCESS
  • Locked
    9.  Marking Columns as Unused
    4m 25s
    In this video, you will learn how to mark columns as unused with the SET UNUSED statement. FREE ACCESS
  • Locked
    10.  Removing Unused Columns
    3m 54s
    In this video, you will remove any unused columns. FREE ACCESS
  • Locked
    11.  DROP TABLE Statement
    1m 55s
    In this video, find out how to use the DROP TABLE SQL command to delete a table from your database. FREE ACCESS
  • Locked
    12.  Exercise: Create and Work with Tables Using DDL
    5m 15s
    In this video, you will learn how to create and work with tables using DDL. FREE ACCESS

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 503 users Rating 4.4 of 503 users (503)
Rating 4.4 of 1302 users Rating 4.4 of 1302 users (1302)
Rating 4.5 of 153 users Rating 4.5 of 153 users (153)