| 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 |
