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.