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


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

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



Expected Duration (hours)
1.1

Lesson 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

    • Course Number:
    it_dfosfd_05_enus

    Expertise Level
    Beginner