• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle DBA Training Courses

Oracle Database 10g DBA Fundamentals

View course dates

Course Duration: 10 days

Course Code: O10GDBAF

Course Description:

This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database.  They will gain practical experience in setting up, administering and troubleshooting an Oracle10g database.  They will gain an understanding of the architecture and processes of the Oracle server.  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 exams #1Z1-042 Oracle Database 10g: Administration I and #1Z1-043 Oracle Database 10g: Administration II.

 

Who Should Attend

 

Anyone who needs to administer, monitor, support, backup and restore an Oracle 10g database.

Prerequisites:

A working knowledge of SQL*Plus is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.

This course includes the following modules:

Course Content

• Installing and Configuring Oracle
• Creating and Managing an Oracle database
• Administering an Oracle Database
• Configuring the Oracle Network Environment and Shared Servers
• Creating and Managing Database Storage Structures
• Managing Redo Log Files and Control Files
• Managing Schema Objects
• Managing Users, Profiles, Privileges and Roles
• Managing Undo Data and Temporary Segments
• Monitoring and Resolving Lock Conflicts
• Maintaining Database Security
• Monitoring the Performance of the Database
• Loading and Unloading Data
• Plan a Backup Strategy and 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

 

Location	Duration	RRP	Dec	Jan	Feb	Mar	Apr	May
Click on course date to make a booking, check availability, or find out about available discounts.
Birmingham	12 days	£2695				16 - 27
Bristol	12 days	£2695		19 - 30				11 - 22
Edinburgh	12 days	£2695				9 - 20
Leeds	12 days	£2695			16 - 27		20 - 1
London	12 days	£2695	8 - 19	19 - 30		2 - 13	20 - 1
Manchester	12 days	£2695			2 - 13

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course