Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Oracle SQL 12c
| Beginner
- 6 videos | 34m 35s
- Includes Assessment
- Earns a Badge
Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.
WHAT YOU WILL LEARN
-
Provide an overview of data dictionary views
Demonstrate when to use the user objects view
Demonstrate when to use the all_objects view -
Query a data dictionary view for table, column, and constraint information
Add a comment to a table and query the data dictionary view for comment information
Work with dictionary views
IN THIS COURSE
-
7m 38sAfter completing this video, you will be able to provide an overview of data dictionary views. FREE ACCESS
-
3m 15sIn this video, you will learn how to use the USER OBJECTS view. FREE ACCESS
-
3. ALL_OBJECTS3m 52sIn this video, you will learn how to use the ALL_OBJECTS view. FREE ACCESS
-
4. Querying Dictionary Views7m 15sLearn how to query a data dictionary view for information about tables, columns, and constraints. FREE ACCESS
-
5. Adding Comments to a Table5m 12sTo add a comment to a table, query the data dictionary view for comment information. FREE ACCESS
-
6. Exercise: Work with Dictionary Views7m 23sDuring this video, you will learn how to work with dictionary views. FREE ACCESS
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.
