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 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
-
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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
