Working with Joins

Oracle 12c
  • 17 Videos | 1h 4m 20s
  • Earns a Badge
Likes 45 Likes 45
It's important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.

WHAT YOU WILL LEARN

  • describe how to obtain data from multiple tables using JOINS in a SQL statement
    join tables automatically based on columns with matching data types and names to retrieve data in a SQL statement
    use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement
    use aliases with the USING clause and use prefixes to join multiple tables in a SQL statement
    use the ON clause when you specify join conditions in the WHERE clause in a SQL statement
    using a three-way join to join three tables in a SQL statement
    use the AND clause or the WHERE clause to apply additional conditions to a join in a SQL statement
    use a self-join to join a table to itself in a SQL statement
    use a join condition containing a non-equijoin in a SQL statement
  • use an OUTER join to return records with no direct match in a SQL statement
    describe the differences between an INNER and OUTER join
    use a left outer join in a SQL statement
    use a right outer join in a SQL statement
    use a full outer join in a SQL statement
    describe the generation of a Cartesian product returned by a SQL statement
    create cross joins in a SQL statement
    display data from multiple tables using joins in a SQL statement

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

Likes 109 Likes 109  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
COURSE SQL Developer
Likes 152 Likes 152  
Likes 223 Likes 223