Overview

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

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.