• Online, Self-Paced
Course Description

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.

Learning Objectives

Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views

  • 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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.