MP9003: Network and Database (General) - Combining Tables > Oracle9i SQL 1Z0-007

This course examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format. 

Topics:
Joining tables
Cross joins
Natural joins
The USING and the ON clause
Outer joins
Left outer joins
Right outer joins
Self joins
Other types of joins

Objectives:
Write SELECT statements to access data from more than one table using equality and nonequality joins
View data that generally does not meet a join condition by using outer joins
Join a table to itself using a self join
Create various types of join queries
Identify the differences between Oracle proprietary format and ANSI format for joining tables

Duration:
2 Hours