Home
  
How it works
  
About the quality of your course
 
Managed services
  
Promote CourseMonster
  
 
 
 
 
Oracle

Database 10g: DBA Level 2

Course Code: OD10-DB2      Days: 5
Show all Oracle Database 10g Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Central London
City
City 07/07/08 £ 2,200
City (EC1) 21/07/08 £ 1,700
City 28/07/08 £ 1,595
City (EC1) 11/08/08 £ 1,700
City (EC4) 18/08/08 £ 2,200
City 08/09/08 £ 1,595
City (EC4) 29/09/08 £ 2,200
City 13/10/08 £ 1,595
City (EC1) 20/10/08 £ 1,700
City (EC1) 10/11/08 £ 1,595
City 13/11/08 £ 1,595
City (EC4) 24/11/08 £ 2,200
City (EC1) 08/12/08 £ 1,700
City 15/12/08 £ 1,595
England
Bristol
Bristol 29/09/08 £ 1,595
Bristol 24/11/08 £ 1,595
Cheshire
Altrincham (WA14) 15/09/08 £ 2,200
Altrincham (WA14) 17/11/08 £ 2,200
Greater Manchester
Manchester 18/08/08 £ 1,595
Manchester (M5) 22/09/08 £ 1,700
Manchester (M5) 13/10/08 £ 1,700
Manchester 10/11/08 £ 1,595
Tyne and Wear
Washington (NE38) 15/09/08 £ 2,200
Washington (NE38) 20/10/08 £ 2,200
West Midlands
Birmingham (B16) 04/08/08 £ 1,595
Birmingham 08/09/08 £ 2,200
Birmingham (B16) 13/10/08 £ 1,595
Birmingham 10/11/08 £ 2,200
Birmingham (B16) 15/12/08 £ 1,595
Yorkshire (West)
Leeds (LS12) 07/07/08 £ 2,200
Leeds (LS1) 14/07/08 £ 1,700
Leeds (LS2) 11/08/08 £ 1,595
Leeds (LS1) 18/08/08 £ 1,700
Leeds (LS12) 06/10/08 £ 2,200
Leeds (LS2) 20/10/08 £ 1,595
Leeds (LS1) 17/11/08 £ 1,700
Leeds (LS1) 15/12/08 £ 1,700
Scotland
Edinburgh
Edinburgh (EH1) 21/07/08 £ 1,595
Edinburgh (EH2) 28/07/08 £ 1,700
Edinburgh (EH2) 15/09/08 £ 1,700
Edinburgh (EH1) 27/10/08 £ 1,595
Edinburgh (EH2) 24/11/08 £ 1,700
Europe / International
New Horizons Edison House (Birmingham) 04/08/08 £ 1,595
New Horizons Edison House (Birmingham) 13/10/08 £ 1,595
New Horizons Edison House (Birmingham) 15/12/08 £ 1,595
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

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.

Skills Gained

  • Use RMAN to create and manage backup sets and image copies
  • Recover the database to a previous point in time
  • Use Oracle's Flashback technology to recover your database
  • Detect block corruptions and take appropriate measures to correct them
  • Use the various Database advisors and views to monitor and improve database performance
  • Control database resource usage with the Resource Manager
  • Simplify management tasks by using the Scheduler
  • Improve the security of the listener
  • Review database log files for diagnostic purposes
  • Customize language-dependent behavior for the database and individual sessions

Prerequisites

  • Oracle Database 10g: Administration Level 1
  • Knowledge of Oracle SQL & PL/SQL Languages

Course 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


How to make a booking for the OD10-DB2 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership