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

Oracle SQL 12c    |    Beginner
  • 11 Videos | 1h 6m 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: Managing Objects with Data Dictionary Views
Likes 28 Likes 28  
COURSE Working with Joins
Likes 102 Likes 102  
COURSE Oracle Database 12c R2 SQL: Creating Other Schema Objects
Likes 23 Likes 23  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Joins
Likes 102 Likes 102  
COURSE Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Likes 50 Likes 50  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Likes 28 Likes 28