• Online, Self-Paced
Course Description

Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.

Learning Objectives

Oracle Database 12c R2 SQL: Creating Other Schema Objects

  • describe views
  • differentiate between simple and complex views
  • create a view
  • modify a view
  • view information using USER_VIEWS
  • define columns as visible or invisible
  • describe sequences
  • demonstrate the use of the NEXTVAL and CURRVAL pseudocolumns
  • use a sequence
  • use the ALTER SEQUENCE statement
  • view sequence information using USER_SEQUENCES
  • create views and sequences

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.