 |
|
|
Oracle 9i Server Database Architecture & Administration
This 4 day course provides a starting point for administration of the OracleTM database. The first two day segment considers an in-depth discussion of the database architecture, including the OracleTMinstance, background processes, the SGA and memory structures, data files, table spaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup and recovery, physical storage of indexes and tables and many others.
 Course Summary:
- Oracle™ Database Server Architecture
- Understanding Database Objects
- Instance & User Memory Structures
- Instance & User Processes
- Auditing Database Usage
- An Introduction to Backup & Recovery
- Utilities
- Utilities, Exporting & Importing Data
- Managing Physical Storage of Tables
- Managing Indexes
- Managing Clusters & Indexed Organised Tables
- National Language Support (NLS)
- Data Files, Data Segments
- Data Files, Non-Data Segments
- Non-Data Files
- Installation & Database Creation
- Instance StartUO & Shutdown
- Database Maintenance, Tablespaces
- Database Maintenance, Other Structure
- Managing User Security
Follow-Up Courses:
Option of other related or follow-on courses:
- OracleTM SQL Introduction
- OracleTM Intro to PL/SQL Language
- OracleTM SQL Advanced
|
 |
|
|
