Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries

Oracle SQL 12c    |    Beginner
  • 11 videos | 1h 7m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 33 users Rating 4.4 of 33 users (33)
Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.

WHAT YOU WILL LEARN

  • Specify explicit default values in insert and update statements
    Describe when to use multitable insert statements
    Use the unconditional insert statement
    Use the conditional insert all statement
    Use the conditional insert first statement
    Use the pivoting insert statement
  • Use the merge statement
    Use the flashback table statement
    Track changes in data
    Use the versions between clause
    Perform advanced queries

IN THIS COURSE

  • 3m 57s
    After completing this video, you will be able to specify explicit default values in INSERT and UPDATE statements. FREE ACCESS
  • 4m 17s
    Upon completion of this video, you will be able to describe when to use INSERT statements with multiple tables. FREE ACCESS
  • Locked
    3.  Unconditional INSERT
    7m 37s
    In this video, find out how to use the INSERT statement without any conditions. FREE ACCESS
  • Locked
    4.  Conditional INSERT ALL
    6m 10s
    During this video, you will learn how to use the conditional INSERT ALL statement. FREE ACCESS
  • Locked
    5.  Conditional INSERT FIRST
    4m 34s
    Learn how to use the conditional INSERT statement. FREE ACCESS
  • Locked
    6.  Pivoting INSERT
    5m 46s
    In this video, find out how to use the INSERT statement with a pivot. FREE ACCESS
  • Locked
    7.  MERGE Statement
    9m 46s
    In this video, find out how to use the MERGE statement. FREE ACCESS
  • Locked
    8.  FLASHBACK TABLE Statement
    3m 9s
    In this video, you will use the FLASHBACK TABLE statement. FREE ACCESS
  • Locked
    9.  Tracking Changes in Data
    4m 45s
    Learn how to track changes in data. FREE ACCESS
  • Locked
    10.  VERSIONS BETWEEN Clause
    5m 49s
    In this video, learn how to use the BETWEEN Clause. FREE ACCESS
  • Locked
    11.  Exercise: Perform Advanced Queries
    11m 24s
    Learn how to perform more complex queries. 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 Administration
Course Introduction to SQL Bootcamp: Session 4 Replay
Rating 4.5 of 151 users Rating 4.5 of 151 users (151)
Course Oracle Database 12c R2 SQL: Managing Schema Objects
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 74 users Rating 4.6 of 74 users (74)
Course Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
Rating 4.3 of 24 users Rating 4.3 of 24 users (24)
Course Data Conversion
Rating 4.6 of 203 users Rating 4.6 of 203 users (203)