Working with Joins

Oracle 12c    |    Beginner
  • 17 videos | 1h 1m 50s
  • Earns a Badge
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)
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

  • Locked
    1.  Obtaining Data from Multiple Tables
    2m 42s
    Upon completion of this video, you will be able to describe how to obtain data from multiple tables using JOINS in SQL. FREE ACCESS
  • Locked
    2.  Creating and Retrieving Records with Natural Joins
    3m 50s
    During this video, you will learn how to join tables automatically based on columns with matching data types and names, in order to retrieve data in a SQL statement. FREE ACCESS
  • Locked
    3.  Creating Joins with the USING Clause
    5m 9s
    Learn how to use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement. FREE ACCESS
  • Locked
    4.  Ambiguous Column Names and Table Aliases
    4m 58s
    Learn how to use aliases with the USING clause and use prefixes to join multiple tables in one SQL statement. FREE ACCESS
  • Locked
    5.  Creating Joins with the ON Clause
    3m 49s
    In this video, find out how to use the ON clause when specifying join conditions in the WHERE clause of a SQL statement. FREE ACCESS
  • Locked
    6.  Creating Three-way Joins
    5m 1s
    In this video, you will learn how to join three tables in a SQL statement using a three-way join. FREE ACCESS
  • Locked
    7.  Applying Additional Conditions to a Join
    2m 34s
    In this video, find out how to use the AND clause or the WHERE clause to apply additional conditions to a join in a SQL statement. FREE ACCESS
  • Locked
    8.  Creating Self-joins using the ON clause
    5m 10s
    In this video, you will learn how to join a table to itself using a self-join in a SQL statement. FREE ACCESS
  • Locked
    9.  Retrieving Records from Non-equijoins
    4m 14s
    Learn how to use a join condition containing a non-equijoin in an SQL statement. FREE ACCESS
  • Locked
    10.  Retrieving Records with No Direct Match
    4m 46s
    Learn how to use an OUTER join to return records that have no direct match in a SQL statement. FREE ACCESS
  • Locked
    11.  INNER and OUTER Joins
    1m 37s
    Upon completion of this video, you will be able to describe the differences between an inner and outer join. FREE ACCESS
  • Locked
    12.  Left Outer Join
    2m 57s
    Learn how to use a left outer join in a SQL statement. FREE ACCESS
  • Locked
    13.  Right Outer Join
    2m 21s
    In this video, find out how to use a right join in a SQL statement. FREE ACCESS
  • Locked
    14.  Full Outer Join
    2m 52s
    To find out how to use a full outer join in a SQL statement, consult a SQL reference guide or search for a tutorial online. FREE ACCESS
  • Locked
    15.  Generating Cartesian Product
    2m 36s
    After completing this video, you will be able to describe the generation of a Cartesian product returned by an SQL statement. FREE ACCESS
  • Locked
    16.  Cross Joins
    2m 2s
    During this video, you will learn how to create cross joins in SQL statements. FREE ACCESS
  • Locked
    17.  Exercise: Joining Multiple Tables
    5m 12s
    In this video, find out how to display data from multiple tables using joins in SQL statements. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Querying SQL Databases: Prompt Engineering to Work with Advanced SQL Operations
Course MySQL: Understanding & Implementing Joins
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 88 users Rating 4.7 of 88 users (88)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Restricting Output
Rating 4.6 of 220 users Rating 4.6 of 220 users (220)
Course SQL*Plus Commands
Rating 4.5 of 285 users Rating 4.5 of 285 users (285)
Book Oracle Database 12c PL/SQL Programming