|
ora11g202-ver1
Oracle Database 11g: Administration II (5 day)
Description
This Oracle 11g courseware training guide book will bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise.
Audience
The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful.
This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.
Certification
This course along with its prerequisites cover information necessary to complete the certification test EXAM #1Z1-053 ORACLE DATABASE 11g: ADMINISTRATION II.
Prerequisites
Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are these Sideris titles:
• ORACLE DATABASE 11g: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: PL/SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: ADMINISTRATION I
Suggested Next Courses
Administrators may wish to proceed onto more focused and specialized courses with these modules:
• ORACLE DATABASE 11g: PERFORMANCE TUNING
• ORACLE DATABASE 11g: SQL TUNING
• ORACLE DATABASE 11g: PARALLEL SQL & PARTITIONING
• ORACLE DATABASE 11g: DATA WAREHOUSE IMPLEMENTATION
One might also consider the Sideris courses which address the most common operating systems used for Oracle database servers, namely the Linux enterprise administration and Windows Server curricula.
Objectives
Specific subjects to be considered are:
• Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
• Using Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability.
• Controlling resource utilization on database servers whose resource demand exceeds its capacity.
• Automating launching routine maintenance tasks and even application functions using the database Scheduler.
• Handling database corruption.
• Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data.
• Automatic resumption of database operations even in the face of failures and errors.
• User-managed and automatically managed backup strategies and database recovery operations.
• Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others.
• Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager.
 Download
PDF outline here!
|
|
|
|
