| The overall objective of this course is to allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Major tasks to be considered are:
• Software installation and the creation of new databases.
• An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
• Management of database files.
• Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
• Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
• Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
• Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
• Control over database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
• A primer on backup and recovery structures and strategies.
• Operating system-specific considerations for Unix, Linux and MS Windows. |
