| ORACLE DATABASE INTRODUCTION |
 |
Oracle Database Architecture |
|
Oracle Installation and Configuration |
|
Relational Database Concepts |
|
Working with SQL*Plus |
|
SQL Fundamentals and Techniques |
|
Designing and Building a Database |
|
ORACLE DATABASE ADMINISTRATION
|
|
Tasks of a DBA |
|
Building a Database |
|
Configuring Database Storage (Logical and Physical storage) |
|
Creating and Managing Users and resources |
|
Building Table Partitions and Sub partitions |
|
Configuring index Partitions |
|
BACK-UP AND RECOVERY |
|
Protecting the Database |
|
Performing Back-ups |
|
Archiving the Database |
|
Recovering the Database |
|
Automating Back-up and Recovery |
|
PERFORMANCE AND TUNING |
|
Tuning Memory Structures |
|
Configuring Disk Usage |
|
Improving the Performance |
|
Optimizing Transaction Processing |
|
Handling Block Contention |
|
Diagnosing Problems and Tuning |
