Oracle Database 12c R2 SQL: Managing Schema Objects
Oracle SQL 12c
| Beginner
- 13 videos | 1h 11m 46s
- Includes Assessment
- Earns a Badge
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 constraintdrop a constraintdelete child rows using the ON DELETE CASCADE and DELETE SET NULL clausesuse the CASCADE CONSTRAINTS clausedisable and enable constraintsdescribe indexescreate an index
-
retrieve index information using USER_INDEXEScreate a temporary tabledescribe the benefits of external tablescreate external tables using the CREATE TABLE statementquery external tableswork with database objects
IN THIS COURSE
-
6m 44s
-
3m 36s
-
5m
-
3m 15s
-
6m 52s
-
5m 36s
-
6m 56s
-
4m 9s
-
6m 38s
-
5m 20s
-
7m 47s
-
3m 1s
-
6m 53s
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.