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 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

IN THIS COURSE

  • 4m 40s
    After completing this video, you will be able to describe views. FREE ACCESS
  • 2m 47s
    Find out how to differentiate between simple and complex sentences. FREE ACCESS
  • Locked
    3.  Creating a View
    4m 23s
    In this video, you will learn how to create a view. FREE ACCESS
  • Locked
    4.  Modifying a View
    4m 33s
    In this video, you will learn how to modify a view. FREE ACCESS
  • Locked
    5.  Viewing Information
    3m 20s
    During this video, you will learn how to view information using the USER_VIEWS table. FREE ACCESS
  • Locked
    6.  Visible and Invisible Columns
    5m 28s
    In this video, find out how to make columns visible or invisible. FREE ACCESS
  • Locked
    7.  Sequences
    4m 53s
    Upon completion of this video, you will be able to describe sequences. FREE ACCESS
  • Locked
    8.  Pseudocolumns
    3m 29s
    In this video, you will learn about the use of the NEXTVAL and CURRVAL pseudocolumns. FREE ACCESS
  • Locked
    9.  Using a Sequence
    3m 43s
    Find out how to use a sequence. FREE ACCESS
  • Locked
    10.  Modifying a Sequence
    2m 59s
    To find out how to use the ALTER SEQUENCE statement, consult the documentation for your database management system. FREE ACCESS
  • Locked
    11.  Sequence Information
    3m 28s
    During this video, you will learn how to view sequence information using the USER_SEQUENCES view. FREE ACCESS
  • Locked
    12.  Exercise: Create Other Schema Objects
    5m 52s
    Find out how to create views and sequences. 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.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Managing Schema Objects
Channel SQL Database Development & Design
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Automatic Workload Repository
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Course Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views