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
-
1.Adding a Constraint6m 44s
-
2.Dropping a Constraint3m 36s
-
3.Deleting Child Rows5m
-
4.Cascading Constraints3m 15s
-
5.Disabling and Enabling Constraints6m 52s
-
6.Indexes5m 36s
-
7.Creating Indexes6m 56s
-
8.Index Information4m 9s
-
9.Temporary Tables6m 38s
-
10.External Tables5m 20s
-
11.CREATE TABLE Statement7m 47s
-
12.Querying External Tables3m 1s
-
13.Exercise: Work with Database Objects6m 53s
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.