• Oracle Tuning
• Oracle Blocks
• Oracle Data Structures
• Oracle Data Dictionary
• Tuning with Ora Partitioning

• Info Retrieval
• Select Statement
• SQL Views
• Key Sql Functions
• SQL Reporting

• Oracle DB Backup
• Physical Backups Archiving
• Oracle Noarchivelog Mode
• Recovery with Archiving
• Incomplete Recovery with Archiving

• SQL Introduction
• SQL Select Statement
• Relational Databases
• Foundations of SQL
• SQL Table Querying

• Database Administration
• Intro DB Administration
• Oracle 8i Enhancements
• Table Space Management
• Oracle Improvements

• DB Creation Architecture
• Oracle Server Manager
• Oracle DB Architecture
• Oracle Instance Architecture
• Oracle Memory Architecture

• Extended DB Features
• Partitioned Tables
• Clustering Tables
• Index Organized Tables
• Oracle Auditing Features

• Managing DB Objects
• Oracle Space Management
• Managing Oracle Tables
• Managing Oracle Constraints
• Oracle Indexes

• Managing Users Connectivity
• Configuring Oracle
• Oracle Password Files
• Oracle Enterprise Manager
• Intro SQL* Plus

• Intro Network Configuration
• Configuring Oracle Names
• Configure Oracle Intelligent Agent
• Multi-Threaded Server
• Configuring MTS

• Oracle Backup Recovery
• Backup Recovery Features
• Recovery Manager Enhancements
• Backup Recovery Strategies
• Oracle Backup Recovery Improvements

• Oracle Database Backup
• Export-Import Utilities
• Oracle DB Backup-Recovery
• Recovery Catalog Maintenance Basics
• Oracle Recovery Catalog

• Oracle Network Administration
• Oracle Net8 Features
• Net 8 Installation
• Net 8 Applications
• Distributed Databases

• Oracle Network Topology
• Oracle Certification
• Overview Oracle Networking
• SQL*Net Architecture
• SQLNet ServerSide Configuration

• Oracle Programming
• Oracle Environment
• Oracle Select Statement
• Ora Data Manipulation
• Join Table Queries

• Oracle SQL Tuning
• Tuning Oracle SQL
• Oracle Extensions ANSI SQL
• SQL Tuning Tools
• Explain Plan Utility

• Programming PL/SQL
• Querying Oracle Object Tables
• Querying Related Object Tables
• Querying Nested Tables/Varrays
• Object Table Modification

• Performance Tuning Oracle
• Optimizer/Query Improvements
• Oracle Materialized Views
• Oracle Index Enhancements
• Index Organized Tables

• PL/SQL Objects
• User Defined Functions
• Creating Oracle Procedure
• Creating Oracle Trigger
• Using Oracle Parameters

• Programming PL/SQL Objects
• Declaring PL/SQL Variables
• PL/SQL Datatypes
• Writing Control Structures
• Composite Datatypes

• Relational Data Analysis
• Relational Constraints
• DB Normal Forms
• Third Normal Form
• Table Joins User Views

• Relational Database Design
• Relational Database Structure
• Database Life Cycle
• DB Requirements Analysis
• DB Attributes Entities

• Tuning Oracle Instance
• Oracle Instance Tuning
• Shared Pool Tuning
• Data Buffer Cache
• Redo Log Tuning