Oracle Database 10g: Database Interfaces Release 2

Overview/Description
To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
3.0

Lesson Objectives

Oracle Database 10g: Database Interfaces Release 2

identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.

recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data.

recognize how to join tables and use DML and DDL statements to manipulate and define data.

identify the functions of different SQL statements and recognize the function of data locking.

identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.

use SQL*Plus and iSQL*Plus to manage data.

identify the basic elements of PL/SQL and recognize the uses of PL/SQL.

identify the characteristics of some common database interfaces.

identify how Oracle works with common database interfaces.