After completing this course, the user should be able to:

	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

	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

	Exercises that allow users to practice the application
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to the application
	A glossary
	A Skill Assessment

	Oracle9i SQL 1Z0-007: Introduction to SQL
	Oracle9i SQL 1Z0-007: Intermediate Queries
	Oracle9i SQL 1Z0-007: Queries with Single-Row Functions

	Oracle9i SQL 1Z0-007: Grouping and Summarizing Data
	Oracle9i SQL 1Z0-007: Advanced Queries and Views
	Oracle9i SQL 1Z0-007: Working with Data
	Oracle9i SQL 1Z0-007: Creating Tables and Constraints
	Oracle9i SQL 1Z0-007: Database Objects and User Security
	Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL
	Oracle9i SQL 1Z0-007: Practice Exam

Oracle9i™ is a trademark of the Oracle Corporation.