Oracle Data Base Management System

Course Objectives: This course introduces the Oracle data base product family, including Oracle Server, PL/SQL, Form, Report, etc. By comparing and contrasting with Microsoft SQL Server, students will gain a broad perspective of data base technologies and the developing trend.

Course Outlines:
Session 1
What is Oracle?
Oracle Concepts
SQL Plus
Oracle 8i -- an Overview
Session 2
Oracle Architecture
SQL and PL/SQL
Lab 1
Session 3
Basic DBA skill
Startup / Shut Down
Grant Access
Create / Drop User
Export / Import
Backup
New 8i Features
Data Warehouse
Session 4
Oracle Tools
Developer 2000
Jdeveloper
Discoverer
Webdb
Lab 2