Working with Joins
Oracle 12c
| Beginner
- 17 Videos | 1h 1m 50s
- Earns a Badge
It's important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.
WHAT YOU WILL LEARN
-
describe how to obtain data from multiple tables using JOINS in a SQL statementjoin tables automatically based on columns with matching data types and names to retrieve data in a SQL statementuse the USING clause to specify columns used for an equijoin to retrieve records in a SQL statementuse aliases with the USING clause and use prefixes to join multiple tables in a SQL statementuse the ON clause when you specify join conditions in the WHERE clause in a SQL statementusing a three-way join to join three tables in a SQL statementuse the AND clause or the WHERE clause to apply additional conditions to a join in a SQL statementuse a self-join to join a table to itself in a SQL statementuse a join condition containing a non-equijoin in a SQL statement
-
use an OUTER join to return records with no direct match in a SQL statementdescribe the differences between an INNER and OUTER joinuse a left outer join in a SQL statementuse a right outer join in a SQL statementuse a full outer join in a SQL statementdescribe the generation of a Cartesian product returned by a SQL statementcreate cross joins in a SQL statementdisplay data from multiple tables using joins in a SQL statement
IN THIS COURSE
-
1.Obtaining Data from Multiple Tables2m 42s
-
2.Creating and Retrieving Records with Natural Joins3m 50s
-
3.Creating Joins with the USING Clause5m 9s
-
4.Ambiguous Column Names and Table Aliases4m 58s
-
5.Creating Joins with the ON Clause3m 49s
-
6.Creating Three-way Joins5m 1s
-
7.Applying Additional Conditions to a Join2m 34s
-
8.Creating Self-joins using the ON clause5m 10s
-
9.Retrieving Records from Non-equijoins4m 14s
-
10.Retrieving Records with No Direct Match4m 46s
-
11.INNER and OUTER Joins1m 37s
-
12.Left Outer Join2m 57s
-
13.Right Outer Join2m 21s
-
14.Full Outer Join2m 52s
-
15.Generating Cartesian Product2m 36s
-
16.Cross Joins2m 2s
-
17.Exercise: Joining Multiple Tables5m 12s
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.