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

Oracle SQL 12c    |    Beginner
  • 6 videos | 34m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 36 users Rating 4.5 of 36 users (36)
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 38s
    After completing this video, you will be able to provide an overview of data dictionary views. FREE ACCESS
  • 3m 15s
    In this video, you will learn how to use the USER OBJECTS view. FREE ACCESS
  • Locked
    3.  ALL_OBJECTS
    3m 52s
    In this video, you will learn how to use the ALL_OBJECTS view. FREE ACCESS
  • Locked
    4.  Querying Dictionary Views
    7m 15s
    Learn how to query a data dictionary view for information about tables, columns, and constraints. FREE ACCESS
  • Locked
    5.  Adding Comments to a Table
    5m 12s
    To add a comment to a table, query the data dictionary view for comment information. FREE ACCESS
  • Locked
    6.  Exercise: Work with Dictionary Views
    7m 23s
    During 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.

YOU MIGHT ALSO LIKE

Channel Oracle Database 12c Administrator Certified Associate
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Oracle Database 12c: RAC and Grid Infrastructure Administration
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel SQL Database Administration
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Rating 4.4 of 33 users Rating 4.4 of 33 users (33)
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Oracle Database 12c R2 SQL: SQL*Plus
Rating 4.6 of 63 users Rating 4.6 of 63 users (63)