MP9003: Network and Database (General) - Using Joins and Subqueries > Oracle Database 11g SQL Fundamentals I (1Z0-051)

This course covers the use of table joins to relate two or more tables. It discusses the use of set operators to combine the results of more than one query into one. This course also examines the use of subqueries to manipulate data. 

Topics:
Using Joins and Subqueries

Objectives:
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables
Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Duration:
1 Hour