Introduction to Oracle and SQL in Oracle9i

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
3.2

Lesson Objectives

Introduction to Oracle and SQL in Oracle9i

describe basic relational database concepts.

define an entity relationship model for a database.

describe the features and characteristics of an Oracle relational database management system (RDBMS) and an Oracle object relational database management system (ORDBMS).

discuss and write basic SELECT SQL statements.

describe SQL statement features in an Oracle9i database.

describe the iSQL*Plus environment and how to interact with script files.

use iSQL*Plus in an Oracle9i database to execute SQL statements and interact with script files.

restrict the data that a SQL statement returns by using a WHERE clause.

sort data returned by SQL statements by using the ORDER BY clause.

use the WHERE and ORDER BY clauses to restrict and sort query results.

Course Number:
66155_eng