Oracle Database 12c R2 SQL: Managing Schema Objects

Oracle SQL 12c    |    Beginner
  • 13 videos | 1h 11m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)
Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.

WHAT YOU WILL LEARN

  • Add a constraint
    Drop a constraint
    Delete child rows using the on delete cascade and delete set null clauses
    Use the cascade constraints clause
    Disable and enable constraints
    Describe indexes
    Create an index
  • Retrieve index information using user_indexes
    Create a temporary table
    Describe the benefits of external tables
    Create external tables using the create table statement
    Query external tables
    Work with database objects

IN THIS COURSE

  • 6m 44s
    During this video, you will learn how to add a constraint. FREE ACCESS
  • 3m 36s
    In this video, you will remove a constraint. FREE ACCESS
  • Locked
    3.  Deleting Child Rows
    5m
    In this video, find out how to delete child rows using the ON DELETE CASCADE and DELETE SET NULL clauses. FREE ACCESS
  • Locked
    4.  Cascading Constraints
    3m 15s
    In this video, you will learn how to use the CASCADE CONSTRAINTS clause. FREE ACCESS
  • Locked
    5.  Disabling and Enabling Constraints
    6m 52s
    In this video, you will learn how to enable and disable constraints. FREE ACCESS
  • Locked
    6.  Indexes
    5m 36s
    After completing this video, you will be able to describe indexes. FREE ACCESS
  • Locked
    7.  Creating Indexes
    6m 56s
    In this video, you will learn how to create an index. FREE ACCESS
  • Locked
    8.  Index Information
    4m 9s
    Learn how to retrieve index information using the USER_INDEXES view. FREE ACCESS
  • Locked
    9.  Temporary Tables
    6m 38s
    In this video, you will create a table that will only exist for the duration of the session. FREE ACCESS
  • Locked
    10.  External Tables
    5m 20s
    After completing this video, you will be able to describe the benefits of external tables. FREE ACCESS
  • Locked
    11.  CREATE TABLE Statement
    7m 47s
    In this video, you will learn how to create external tables using the CREATE TABLE statement. FREE ACCESS
  • Locked
    12.  Querying External Tables
    3m 1s
    In this video, you will learn how to query external tables. FREE ACCESS
  • Locked
    13.  Exercise: Work with Database Objects
    6m 53s
    In this video, you will learn how to work with database objects. 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.

YOU MIGHT ALSO LIKE

Book Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization's Data, Fourth Edition
Course Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Rating 4.7 of 30 users Rating 4.7 of 30 users (30)
Book DBA Essentials for 21c: Installing Oracle Database 21c on OCI Compute

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)
Course Backing Up & Recovering Data
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)
Course Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Rating 4.7 of 42 users Rating 4.7 of 42 users (42)