Oracle Database 10g : Administration Workshop II SitesPower Training Institute
Price: TBC

    Course details

    Course Overview

    Please Note: Oracle Courses are only available for private, onsite training.


    What one will learn
    This course advances your success as an Oracle professional in the area of database administration. In this class, one will learn how to configure an Oracle database for multilingual applications. They will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. They will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. Applicants will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database. The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare one for the corresponding Oracle Certified Professional exam which is one of the two exams required for the OCP DBA 10g certification.

    Database Administrator, Sales Consultants, Support Engineer, Technical Consultant


    • Knowledge of basic database administration
    • Oracle Database 10g: Administration Workshop I Release 2
    • Oracle Database 10g: SQL and PL/SQL Fundamentals

    Course Objectives

    • Use RMAN to create and manage backup sets and image copies
    • Recover the database to a previous point in time
    • Use Oracle Secure Backup to backup and recover a database
    • 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
    • Review database log files for diagnostic purposes
    • Customize language-dependent behavior for the database and individual sessions
    • Administer a VLDB
    • Implement a secure database

    Transport data across platforms

    Course Outline

    • Introduction
    • Configuring Recovery Manager
    • Using Recovery Manager
    • Oracle Secure Backup
    • Recovering from Non-critical Losses
    • Incomplete Recovery
    • Flashback
    • Dealing with Database Corruption
    • Monitoring and Managing Memory
    • Automatic Performance Management
    • Monitoring and Managing Storage I
    • Monitoring and Managing Storage II
    • Automatic Storage Management
    • VLDB Support
    • Managing Resources
    • Automating Tasks with the Scheduler
    • Database Security
    • Data Movement
    • Using Globalization Support
    • Workshop


    About SitesPower Training Institute

    About SitesPower

    Resulting from our proven track record of customer satisfaction, SitesPower has been granted numerous international, elite authorizations and achievements in the short time since launching in 2001, not to mention having our courses Accredited by the Ministry of Education.  As an independent training provider, rather than a franchisee, these are true accomplishments. Authorizations include PMI, ILM (UK), Microsoft, RedHat, EC-Council, ITIL (EXIN), City & Guilds, AutoDesk, Adobe & ICDL.

    See all SitesPower Training Institute courses

    IT / Technology Related Questions

    Contact information not available.

    Are you from SitesPower Training Institute ? Claim your course!
    Courses you can instantly connect with... ORACLE (Database Administration Track) Jurassic Institute of Management and Technology ORACLE (Application Development Track) Jurassic Institute of Management and Technology Oracle WebLogic Server 12c: Administration I New Horizons Computer Learning Center-Dubai

    Is this the right course for you?

    Rate our content

    Didn't find what you were looking for ?