Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Oracle SQL 12c
| Beginner
- 11 Videos | 1h 7m 13s
- Includes Assessment
- Earns a Badge
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 statementsdescribe when to use multitable INSERT statementsuse the unconditional INSERT statementuse the conditional INSERT ALL statementuse the conditional INSERT FIRST statementuse the pivoting INSERT statement
-
use the MERGE statementuse the FLASHBACK TABLE statementtrack changes in datause the VERSIONS BETWEEN Clauseperform advanced queries
IN THIS COURSE
-
1.Explicit Default3m 57s
-
2.Multitable INSERT Statements4m 17s
-
3.Unconditional INSERT7m 37s
-
4.Conditional INSERT ALL6m 10s
-
5.Conditional INSERT FIRST4m 34s
-
6.Pivoting INSERT5m 46s
-
7.MERGE Statement9m 46s
-
8.FLASHBACK TABLE Statement3m 9s
-
9.Tracking Changes in Data4m 45s
-
10.VERSIONS BETWEEN Clause5m 49s
-
11.Exercise: Perform Advanced Queries11m 24s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.