On-line training course catalogue
Oracle Database 10g: Administration Workshop II
Type of course: Classroom
| Fee | £2200 |
|---|---|
| Days | 5 |
| Course code | OR10GAWII |
| Location | Aug | Sep | Oct | Nov | Dec | Jan |
|---|---|---|---|---|---|---|
| Altrincham Manchester | |- | |- | |- | |17 | |- | |26 |
| Leeds Yorkshire | |- | |- | |6 | |- | |- | |- |
| London King William Street | |- | |29 | |- | |24 | |- | |- |
| Washington Tyne & Wear | |- | |15 | |20 | |- | |- | |- |
Booking: click a course date | View location: click location name | Print this page | Download as Word document |
Overview
Please note that Oracle courses running at London training centres are subject to a 5% surcharge.
Oracle DBAs manage the industries most advanced information systems and command some of the highest salaries. This course advances your success as an Oracle professional in the area of database administration.
In this class, you’ll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam
Leads to certifications
Prerequisites
Oracle Database 10g: Administration Workshop I
Knowledge of Oracle SQL & PL/SQL Languages
Delegates will learn how to
- Use RMAN to create and manage backup sets and image copies
- Customize language-dependent behavior for the database and individual sessions
- Recover the database to a previous point in time
- Detect block corruptions and take appropriate measures to correct them
- Use the various Database advisors and views to monitor and improve database performance
- Simplify management tasks by using the Scheduler
- Improve the security of the listener
- Review database log files for diagnostic purposes
- Use Oracle’s Flashback technology to recover your database
- Control database resource usage with the Resource Manager
Outline
Using Globalization Support
Securing the Oracle Listener
Configuring Recovery Manager
Using Recovery Manager
Diagnostic Sources
Recovering from non-critical losses
Database Recovery
User-Managed Recovery Procedures: RECOVER Command
Point-in-time recovery using RMAN
Flashback database
Recovering from User Errors
Flashback Dropped Tables Using EM
Using Flashback Versions Query and Flashback Transaction Query
Using EM To Flashback Tables
Dealing with Database Corruption
Automatic Database Management
Monitoring and Managing Storage
Automatic Storage Management
Monitoring and Managing Memory
Managing Resources
Automating Tasks with the Scheduler
Workshop
Related Certifications
This course forms part of the following certification track(s):
Link to this page: http://www.xpertise.co.uk/OR10GAWII
Xpertise – Oracle Database 10g: Administration Workshop II training courses
Xpertise provides Oracle Database 10g: Administration Workshop II training courses from 7 UK locations: in Altrincham Manchester, Hinckley East Midlands, Leeds Yorkshire, London King William Street, Maidenhead Berkshire, Malmesbury Wiltshire and Washington Tyne & Wear – and at 44 partner locations nationwide.
Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.