Oracle Database 12c R2 SQL: Managing Schema Objects

Oracle SQL 12c    |    Beginner
  • 13 Videos | 1h 11m 46s
  • Includes Assessment
  • Earns a Badge
Likes 31 Likes 31
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

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.

YOU MIGHT ALSO LIKE

COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Likes 28 Likes 28  
COURSE Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Likes 34 Likes 34  
COURSE Oracle Database 12c R2 SQL: Creating Other Schema Objects
Likes 23 Likes 23  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 285 Likes 285  
COURSE Oracle Database 12c R2 SQL: Restricting & Sorting Data
Likes 25 Likes 25  
COURSE Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Likes 39 Likes 39