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

Oracle SQL 12c
  • 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE