Oracle Database 12c R2 SQL: Creating Other Schema Objects
Oracle SQL 12c
| Beginner
- 12 videos | 49m 36s
- Includes Assessment
- Earns a Badge
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
WHAT YOU WILL LEARN
-
describe viewsdifferentiate between simple and complex viewscreate a viewmodify a viewview information using USER_VIEWSdefine columns as visible or invisible
-
describe sequencesdemonstrate the use of the NEXTVAL and CURRVAL pseudocolumnsuse a sequenceuse the ALTER SEQUENCE statementview sequence information using USER_SEQUENCEScreate views and sequences
IN THIS COURSE
-
1.Views4m 40s
-
2.Simple and Complex Views2m 47s
-
3.Creating a View4m 23s
-
4.Modifying a View4m 33s
-
5.Viewing Information3m 20s
-
6.Visible and Invisible Columns5m 28s
-
7.Sequences4m 53s
-
8.Pseudocolumns3m 29s
-
9.Using a Sequence3m 43s
-
10.Modifying a Sequence2m 59s
-
11.Sequence Information3m 28s
-
12.Exercise: Create Other Schema Objects5m 52s
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.