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 statement
Join tables automatically based on columns with matching data types and names to retrieve data in a sql statement
Use the using clause to specify columns used for an equijoin to retrieve records in a sql statement
Use aliases with the using clause and use prefixes to join multiple tables in a sql statement
Use the on clause when you specify join conditions in the where clause in a sql statement
Using a three-way join to join three tables in a sql statement
Use the and clause or the where clause to apply additional conditions to a join in a sql statement
Use a self-join to join a table to itself in a sql statement
Use 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 statement
Describe the differences between an inner and outer join
Use a left outer join in a sql statement
Use a right outer join in a sql statement
Use a full outer join in a sql statement
Describe the generation of a cartesian product returned by a sql statement
Create cross joins in a sql statement
Display data from multiple tables using joins in a sql statement
IN THIS COURSE
-
1. Obtaining Data from Multiple Tables2m 42sUpon completion of this video, you will be able to describe how to obtain data from multiple tables using JOINS in SQL. FREE ACCESS
-
2. Creating and Retrieving Records with Natural Joins3m 50sDuring this video, you will learn how to join tables automatically based on columns with matching data types and names, in order to retrieve data in a SQL statement. FREE ACCESS
-
3. Creating Joins with the USING Clause5m 9sLearn how to use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement. FREE ACCESS
-
4. Ambiguous Column Names and Table Aliases4m 58sLearn how to use aliases with the USING clause and use prefixes to join multiple tables in one SQL statement. FREE ACCESS
-
5. Creating Joins with the ON Clause3m 49sIn this video, find out how to use the ON clause when specifying join conditions in the WHERE clause of a SQL statement. FREE ACCESS
-
6. Creating Three-way Joins5m 1sIn this video, you will learn how to join three tables in a SQL statement using a three-way join. FREE ACCESS
-
7. Applying Additional Conditions to a Join2m 34sIn this video, find out how to use the AND clause or the WHERE clause to apply additional conditions to a join in a SQL statement. FREE ACCESS
-
8. Creating Self-joins using the ON clause5m 10sIn this video, you will learn how to join a table to itself using a self-join in a SQL statement. FREE ACCESS
-
9. Retrieving Records from Non-equijoins4m 14sLearn how to use a join condition containing a non-equijoin in an SQL statement. FREE ACCESS
-
10. Retrieving Records with No Direct Match4m 46sLearn how to use an OUTER join to return records that have no direct match in a SQL statement. FREE ACCESS
-
11. INNER and OUTER Joins1m 37sUpon completion of this video, you will be able to describe the differences between an inner and outer join. FREE ACCESS
-
12. Left Outer Join2m 57sLearn how to use a left outer join in a SQL statement. FREE ACCESS
-
13. Right Outer Join2m 21sIn this video, find out how to use a right join in a SQL statement. FREE ACCESS
-
14. Full Outer Join2m 52sTo find out how to use a full outer join in a SQL statement, consult a SQL reference guide or search for a tutorial online. FREE ACCESS
-
15. Generating Cartesian Product2m 36sAfter completing this video, you will be able to describe the generation of a Cartesian product returned by an SQL statement. FREE ACCESS
-
16. Cross Joins2m 2sDuring this video, you will learn how to create cross joins in SQL statements. FREE ACCESS
-
17. Exercise: Joining Multiple Tables5m 12sIn this video, find out how to display data from multiple tables using joins in SQL statements. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
