Oracle SQL and SQL*Plus

Course Number:  574-JK
Recommended Duration:  3 days

Intended Audience
Personnel needing to create and execute queries against the Oracle database using SQL*Plus.  No programming background or experience is necessary, although a technical orientation is helpful.

Course Overview
This course introduces developers to Oracle 10g, SQL, and SQL*Plus. This course is a subset of Oracle for Developers. (Suitable for Oracle9i, or Oracle8i; Oracle 7 version available). There are nine machine exercises.

Objectives
Participants will be introduced to the Oracle database, SQL, and the SQL*Plus tool. Several exercises use SQL to query the database and create simple reports using the SQL*Plus tool. The participant will also learn how to work with views and synonyms.

Prerequisites
Participants should be familiar with the terminals to be used in class exercises.  A basic understanding of the host system editing tool is useful, but not required.

Topics

• Relational database concepts

• SQL syntax and usage

• SELECT statement

• Joins

• Outer joins

• Nested Queries

• Views

• Synonyms

• SQL*Plus report creation

• Editing and saving queries

• Spooled output