INTRODUCTION TO ORACLE9I: SQL |
 |
Restricting and Sorting Data |
 |
Displaying Data from Multiple Tables |
 |
Aggregating Data using Group Functions |
 |
Subqueries |
 |
Producing Readable Output with iSQL*Plus |
 |
Manipulating Data |
 |
Creating and Managing Tables |
 |
Including Constraints |
 |
Creating Views |
 |
Creating Other Database Objects |
 |
Controlling User Access |
ORACLE 9I FUNDAMENTS - I
|
 |
Oracle Architectural Components |
 |
Getting Started With the Oracle Server |
 |
Managing an Oracle Instance |
 |
Creating a Database |
 |
Data Dictionary Content and Usage |
 |
Maintaining the Control File |
 |
Maintaining Redo Log Files |
 |
Managing Table spaces and Data files |
 |
Storage Structure and Relationships |
 |
Managing Undo Data |
 |
Managing Tables |
 |
Managing Indexes |
 |
Maintaining Data Integrity |
 |
Managing Password Security and Resources |
 |
Managing Users |
 |
Managing Privileges |
 |
Managing Roles |
 |
Using Globalization Support |
ORACLE 9I FUNDAMENTALS II |
 |
Networking Overview |
 |
Basic Oracle Net Architecture |
 |
Basic Net Server-Side Configuration |
 |
Basic Oracle Net Services Client-Side Configuration |
 |
Usage and Configuration of the Oracle Shared Server |
 |
Backup and Recovery Overview |
 |
Instance and Media Recovery Structures |
 |
Configuring the Database Archiving Mode |
 |
Oracle Recovery Manager Overview and Configuration |
 |
User-Managed Backups |
 |
RMAN Backups |
 |
User-Managed Complete Recovery |
 |
RMAN Complete Recovery |
 |
User-Managed Incomplete Recovery |
 |
RMAN Incomplete Recovery |
 |
RMAN Maintenance |
 |
Recovery Catalog Creation and Maintenance |
 |
Transporting Data Between Databases |
 |
Loading Data into a Database |
ORACLE 9I PERFORMANCE TUNING |
 |
Diagnostic and Tuning Tools |
 |
Sizing the Shared Pool |
 |
Sizing the Buffer Cache |
 |
Sizing other SGA Structures |
 |
Database Configuration and I/O Issues |
 |
Optimize Sort Operations |
 |
Diagnosing Contention For Latches |
 |
Tuning Rollback (or UNDO) Segments |
 |
Monitoring and Detecting Lock Contention |
 |
Tuning Oracle Shared Server |
 |
Application Tuning |
 |
Using Oracle Blocks Efficiently |
 |
SQL Statement Tuning |
 |
Tuning the Operating System and Using Resource Manager |