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

Oracle SQL 12c    |    Beginner
  • 11 Videos | 1h 11m 28s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries 
Likes 21 Likes 21  
COURSE SQL Databases Using SQLAlchemy: Chaining Joins, Views, & Indexes
COURSE Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Likes 47 Likes 47  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries 
Likes 21 Likes 21  
COURSE Working with Joins
Likes 45 Likes 45  
COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 165 Likes 165