Oracle9i SQL 1Z0-007: Combining Tables
Product Code: OR0704 Time: 2 Hour(s) CEUs: .20

Summary:

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

Objectives:

After completing this course, students will 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

Outline:

  • 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

Features:

  • 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

Applicability:

his course is for anyone who is interested in learning more about Oracle9i SQL and in taking the Oracle 9i exam 1Z0-007: Introduction to Oracle 9i:SQL.

Prerequisites:

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

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Oracle9i™ is a trademark of the Oracle Corporation.

Terms of Use:

None

Copyright © 2004 eLearningDepot.com. All rights reserved.