www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Oracle 10g - Database Administration Training Course UK
Oracle DBA Part 2

Dates and full course list

Oracle 10g - Database Administration (Oracle DBA Part 2) Training Course Overview

Course Code:	ORC0070
Price:	£1600
Duration:	5 days
Date:
Who should attend:	This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle10g databases.  This course is also suitable for delegates who need to be able to monitor and improve the database performance.
Prerequisite Skills:	Attendance on Introduction to Oracle SQL and Oracle 10g DBA - Part 1 or equivalent experience. Knowledge of PL/SQL can be useful.

This course introduces delegates to the main concepts of Oracle backup and recovery.  They will learn how to plan and implement a backup and recovery strategy using operating system backups, the import and export utilities and Recovery Manager.  

Delegates will learn how to monitor and improve database performance.  They will also learn how to control database resources using Resource Manager, automate tasks with the Scheduler and use Automatic Storage Management (ASM).   

This course covers the main topics of the Oracle exam #1Z1-043 Oracle Database 10g: Administration II.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Oracle 10g Database Administration (Oracle DBA Part 2) Training Course Outline

• Plan a Backup Strategy
• Plan a Disaster Recovery Strategy
• Alter a Database to Archivelog and NoArchivelog Modes
• Online and Offline Backups
• Complete and Incomplete Database Recovery
• Recover a Database from Non-Critical Losses
• Perform Logical Backups with Export and Import Utilities
• Use RMAN to Perform Backups And Restore
• Use Flashback Technology to Recover a Database
• Use Flashback to Recover From User Errors
• Database Corruption
• Diagnostic Sources
• Use Automatic Database Management
• Monitor and Manage Storage
• Use Automatic Storage Management
• Monitor and Manage Memory
• Control Database Resources Using Resource Manager
• Automate Management Tasks with the Scheduler
• Secure the Oracle Listener

Associated Courses

Oracle 10g Database Administration (Oracle DBA) Training Course for Programmers and DBAs

Introduction to Oracle SQL

Introduction to Oracle PL/SQL

Oracle 10g DBA Combined ('Fundamentals')

Oracle 10g - Database Administration (Oracle DBA) for Developers

Oracle 10g DBA - Part 1

Oracle 10g DBA - part 2

Oracle 10g Performance & Tuning

Oracle 6i Reports

Oracle 6i Forms

Oracle Forms & Reports 5-day Hybrid

Oracle 9i Intro to SQL

Oracle 9i Intro to PL/SQL

Oracle 9i Database Administration (Oracle DBA)

Oracle 9i Performance Tuning