Displaying Data from Multiple Tables using JOIN
The "Displaying Data from Multiple Tables using Joins" module provides you with the instructions and devices to develop your hands on skills in the following topics: Using EQUIJOINS and NON EQUIJOINS to Access Data from Multiple Tables, Using SELF JOIN, Using OUTER JOIN, Generate Cartesian Product using CROSS JOIN.

Introduction
The Displaying Data from Multiple Tables using Joins module provides you with the instructions and devices to develop your hands on skills in the following topics.
- Using EQUIJOINS and NON EQUIJOINS to Access Data from Multiple Tables
- Using SELF JOIN
- Using OUTER JOIN
- Generate Cartesian Product using CROSS JOIN
Exercise 1 - Using EQUIJOINS and NON EQUIJOINS to Access Data from Multiple Tables
In this exercise, you will learn the following about displaying data from multiple tables using JOINS:
- Establishing a connection to the database
- Example of SELECT statement using three tables
- Understanding the EQUIJOIN
- Understanding the NON EQUIJOIN
- Understanding the SELF JOIN
- Understanding the INNER JOIN
- Understanding the FULL OUTER JOIN
- Understanding the LEFT OUTER JOIN
- Understanding the RIGHT OUTER JOIN
- Understanding the CROSS JOIN
- Understanding the NATURAL JOIN
Exercise 2 - Using SELF JOIN
In this exercise you will learn the following about displaying data from multiple tables using JOINS:
- Usefulness of Joining a Table back to itself
Exercise 3 - Using OUTER JOIN
In this exercise you will learn the following about displaying data from multiple tables using JOINS:
- Using LEFT OUTER JOIN
- Using RIGHT OUTER JOIN
- Using FULL OUTER JOIN
Exercise 4 - Generate Cartesian Product using CROSS JOIN
In this exercise you will learn the following about displaying data from multiple tables using JOINS:
- CROSS JOIN using two tables
See the full benefits of our immersive learning experience with interactive courses and guided career paths.