Loading Course Schedule...
PT3089
Training Summary
This course provides students with an introduction to Oracle 9i database administration. The course provides an overview of the key issues pertaining to the operation and maintenance of an existing Oracle 9i database. The course also includes discussions of database design, administration and operation. The Data Dictionary is examined to create awareness, among participants, of system information available. Dynamic performance tables are also explored to provide access to additional information about the database.
Prerequisites
Students should have taken an Oracle 9i Concepts and Facilities and Oracle 9i SQL & SQL*Plus course. Oracle 9i PL/SQL Programming course experience would be helpful, but is not required.
Duration
3 Days/Lecture
Audience
This course is designed for Programmers, Analysts and Database Administrators responsible for the administration of an existing Oracle 9i database.
Course Topics
- Overview of Oracle 9i Architecture
- Memory Structures and Processes
- Relationships Between Database Objects
- User Management and Database Security
- Defining Database Objects
- Oracle Utilities
- Storage Management
- Overview of Client-Server Architecture
- Oracle's Data Dictionary