Oracle Database 12c R2 SQL: Using the Set Operators
Oracle SQL 12c
| Beginner
- 8 Videos | 40m 5s
- Includes Assessment
- Earns a Badge
Discover how to write SQL queries by using set operators.
WHAT YOU WILL LEARN
-
describe the types of set operators and their associated guidelinesrecognize how the Oracle Server manages set operatorsuse UNION and UNION ALL operators to return all rows in a SQL statementuse the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement
-
use the MINUS operator to return all distinct rows selected by the first query in a SQL statementdemonstrate how the expressions in the SELECT lists of queries must match in number in a SQL statementuse the ORDER BY clause in set operations in a SQL statementuse set operators to combine the results of multiple queries
IN THIS COURSE
-
1.Types of Set Operators7m 28s
-
2.Oracle Server and Set Operators3m 21s
-
3.UNION and UNION ALL Operators8m 15s
-
4.INTERSECT Operator2m 32s
-
5.MINUS Operator2m 14s
-
6.Matching SELECT Statements7m 17s
-
7.Using the ORDER BY Clause in Set Operations4m 10s
-
8.Exercise: Combine Multiple Queries4m 48s
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.