This course provides students with a detailed understanding of the methods they can use to effectively perform their responsibilities as an Oracle 10g database administrator. Students will learn how to install and start a server, how to allocate necessary devices and databases, and the manner by which to set up Oracle user accounts and privileges. Backup and recovery procedures will also be discussed, as will the steps to perform when attempting to solve certain run time problems.
Students should have an understanding of the facilities of the Oracle Relational Database Management System. Students should have also attended the Introduction to Oracle class, or have obtained equivalent knowledge. It would be helpful if the prospective attendees of this class have been working with the Oracle system for a period of at least 3 months.
5 Days/Lecture & Lab
This course is recommended for database owners, and potential Oracle database administrators. Database designers might also be interested in learning the materials presented in this class.
- Responsibilities of a DBA
- Oracle Architecture
- Version 10g new features
- Creating and Maintaining a Database
- The Data Dictionary
- Database initialization parameters
- Users and Security
- Enterprise manager
- Backup and Recovery
- The v$views
- Reading and interpreting AWR reports
- Memory performance considerations
- Disk performance considerations
- Distributed Databases