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