Introduction
Explain the course objectives
Identify the Oracle product line
Describe the basic concepts of a relational database

Connection with Oracle
Multi layer architecture
Oracle Connection methods
SQL Plus
Parametric Query

SQL DDL Part
Data Dictionary
Tables
Indexes
Integrity Constraints
Normalization
Sequences
Naming Conventions

SQL DML Part
Statement Types
Operators
Functions
Complex Queries

SQL DCL Part
Users
System Privileges
Object Privileges
Roles

SQL Advanced Topics
Transaction
Temporary table
Directory
External table
Views
Synonyms
Constraints disagreement

Programming with PL/SQL
Language structure
Declaration
Data types
Name resolve
Control statements
Procedures
Exceptions
Cursors

Develop PL/SQL program units
Stored procedures
Packages
Procedure & package management
Triggers
Dependency

Objects
Class Diagram
Object types
Object type in tables
Encapsulation
Inheritance
Polymorphism
Altering types

Large Objects
Convert to LOB
LOB constructor
Processing LOB types

Collections
Collection types
Processing of collections
Collection in tables
Collection objects