Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Oracle SQL 12c
| Beginner
- 11 Videos | 1h 6m 28s
- Includes Assessment
- Earns a Badge
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
WHAT YOU WILL LEARN
-
obtain data from multiple tableslist the various types of joinsuse the NATURAL JOIN clauseuse the USING clause to specify columns used for an equijoin to retrieve records in a SQL statementjoin tables with the ON clauseuse self-joins using the ON clause
-
use a join condition containing a nonequijoin in a SQL statementuse a left, right, and full outer join in a SQL statementdemonstrate the generation of a Cartesian product returned by a SQL statementcreate cross joins in a SQL statementaccess data from multiple tables
IN THIS COURSE
-
1.Obtaining Data from Multiple Tables3m 3s
-
2.Types of Joins6m 2s
-
3.Creating Natural Joins3m 13s
-
4.USING Clause4m 35s
-
5.ON Clause9m 27s
-
6.Self-Joins6m 14s
-
7.Nonequijoins5m 54s
-
8.OUTER Joins10m 37s
-
9.Cartesian Product3m 23s
-
10.Cross Joins5m 29s
-
11.Exercise: Access Data from Tables8m 31s
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.