> > > OC10GDBA2

Oracle Database 10g: Administration Workshop II Release 2 (OC10GDBA2)

Course Description Schedule Course Outline
 

Who should attend

  • Database Administrators
  • Support Engineer
  • Sales Consultants
  • Technical Consultant

Prerequisites

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

Course Objectives

Delegates will learn how to:

  • 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 Content

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. You 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. You 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. You 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 you for the corresponding Oracle Certified Professional exam. This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

Classroom Training
Modality: G

Duration 5 days

Price (excl. VAT)
  • United Kingdom: £ 2,325.-
Enroll now
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!