• Online, Self-Paced
Course Description

Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.

Learning Objectives

Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables

  • obtain data from multiple tables
  • list the various types of joins
  • use the NATURAL JOIN clause
  • use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement
  • join tables with the ON clause
  • use self-joins using the ON clause
  • use a join condition containing a nonequijoin in a SQL statement
  • use a left, right, and full outer join in a SQL statement
  • demonstrate the generation of a Cartesian product returned by a SQL statement
  • create cross joins in a SQL statement
  • access data from multiple tables

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.