Griffin Software

Introduction to Oracle 9i - 3 days

Course Content:

Back to Main Introduction to Oracle 9i Page

Introduction to Database Concepts

Data Modeling and Database Design

	Users of Oracle^TM
	The Relational Database Model
	The Development Life Cycle

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

Introduction to Structured Query Language

Other Structured Query Language Statements

	Introduction to SQL*Plus
	The SELECT Statement

	Data Manipulation Language (DML)
	Transaction Control Language (TCL)
	Transaction Control Language (TCL)
	Data Control Language (DCL)

Procedural Language/Structured Query Language

Database Objects

	Overview of PL/SQL
	Stored Packages, Procedures, and Functions
	Triggers

	Data Blocks
	Database Storage
	Oracle^TM and Object-oriented Methodology

Oracle^TM Architecture

Appendix A: Removing Oracle^TM

	The Oracle^TM Database
	The Oracle^TM Instance
	Executing SQL Statements
	Other Oracle^TM Products and Tools

· Removing Oracle^TM Databases and SoftwareTopic

Prerequisites:
To ensure your success, we recommend you first take the following course or have equivalent knowledge

Follow-Up Courses:
Option of other related or follow-on courses: