Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries
Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Database normalization is good practice when building a relational database to minimize data redundancy. In this course, you will learn how to join tables together to view information across multiple tables, how to write subqueries, as well as the more advanced features of the SELECT statements used to obtain values based on an unknown conditional value. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.
Target Audience
Functional Implementer, Forms Developer, System Analysts, Application Developers, PL/SQL Developer and learners looking to obtain the Oracle Database 12c Administrator Certified Associated designation or to become an OPN Certified Specialist.
Prerequisites
None
Expected Duration (hours)
1.9
Lesson Objectives Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries
start the course
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
use a subquery to solve a problem in a SQL statement
describe the rules, guidelines, and types of subqueries used in a SQL statement
use a single-row subquery to return one row in a SQL statement
display data from a main query using a group function in a subquery to return a single row in a SQL statement
use a subquery in the HAVING clause of a SQL statement
identify common errors that occur when an incorrect number of rows is returned by a single-row subquery in a SQL statement
describe multiple-row subqueries in a SQL statement
use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement
use a multiple-column subquery to return more than one column to the outer query in a SQL statement
describe NULL values in a subquery and use the NOT IN operator in a SQL statement
display data from multiple tables using joins in a SQL statement
combine two queries by making use of a subquery in a SQL statement
Course Number: od_insq_a05_it_enus
Expertise Level
Beginner