Oracle9i:Introduction

Introduction to Database Concepts
Users of Oracle
The Relational Database Model
The Development Life Cycle

Data Modeling and Database Design
Overview of Normalization
Data Modeling
Entities and Attributes
Entities and Their Relationships
Denormalization

Introduction to Structured Query Language
Introduction to SQL*Plus
The SELECT Statement

Other Structured Query Language Statements
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Data Definition Language (DDL)
Data Control Language (DCL)

Procedural Language/Structured Query Language
Overview of PL/SQL
Stored Packages, Procedures, and Functions
Triggers

Database Objects
Data Blocks
Database Storage
Oracle and Object-oriented Methodology

Oracle Architecture
The Oracle Database
The Oracle Instance
Executing SQL Statements
Other Oracle Products and Tools

After completing this course, students will know how to:

Describe basic Oracle concepts and how they relate to DBAs and developers.
Describe the goals of normalization.
Identify the techniques of logical database design, and apply these techniques to design a basic Entity-Relationship Diagram (ERD).
Describe the use of SQL, and write SQL statements to create, retrieve, and manipulate data.
Create and execute a simple PL/SQL program and describe the use and syntax of packages, procedures, functions, and triggers.
List the objects that might be found in an Oracle database, and describe how they are stored.
Explain the architecture of Oracle9i and the overall operation of the RDBMS.

Prerequisites

Students should have knowledge of: Introduction to Programming or equivalent.