Сhat now
Training Center MUKКурсыOracleDatabaseОсновы администрирования Oracle 11g, часть II

Oracle Database 11g: Administration Workshop I

Course code
MUK-ODB2
Duration
5 Days, 40 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview

Course overview

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Objectives

Course objective

  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database
  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL
Prerequisites

Suggested Prerequisite

  • Working knowledge of SQL and how to use PL/SQL packages

Required Prerequisite

  • Oracle Database 11g: Administration Workshop I Ed 2
  • Oracle Database 11g Database Administration

Audience

  • Administrator
  • Database Administrator
  • Implementer
Course Outline

Course outline

  1. Core Concepts and Tools of the Oracle Database
  2. Configuring for Recoverability
  3. Using the RMAN Recovery Catalog
  4. Configuring Backup Settings
  5. Creating Backups with RMAN
  6. Restore and Recovery Task
  7. Using RMAN to Perform Recovery
  8. Monitoring and Tuning RMAN
  9. Diagnosing the Database
  10. Using Flashback Technology I
  11. Using Flashback Technology II
  12. Performing Flashback Database
  13. Managing Memory
  14. Managing Database Performance
  15. Managing Performance by SQL Tuning
  16. Managing Resources
  17. Automating Tasks with the Scheduler
  18. Managing Space in Blocks
  19. Managing Space in Segments
  20. Managing Space for the Database
  21. Duplicating a Database
Request the training
Oracle Database 11g: Administration Workshop I
Course code:
MUK-ODB2
Duration:
5 Days, 40 Acad. Hours
Apply
Сhat now
Свяжитесь со мной
Сhat now
Отправить заявку
Registration for the webinar
Отправить заявку
Your application has been received! We will contact you soon.