Oracle 9i Database Administration I Training (OCA)Duration: 5 days Audience: Database administrators, application developers, and system administrators. Prerequisites: Basic understanding of relational database concepts, SQL and PL/SQL programming skills are required, as well as a solid understanding of Oracle schema.
Course contents:- Oracle 9i server architecture
- Oracle memory structures and processes
- Server processes and executing SQL
- The data dictionary
- Shutting down and starting up an Oracle 9i database
- Server parameter file
- Dynamic memory management
- Managing tablespaces and data files
- Managing rollback segments
- Tablespace management
- Rollback management
- Managing tables
- Managing indexes
- Managing constraints
- Control file administration
- Redo log file administration
- Oracle managed files (OMF)
- Managing users and profiles
- Security administration
- Additional security features
- Oracle utilities and managing data
- Creating an Oracle instance and database
|
