Oracle Database: Administration Workshop

  • : OU_DBA
  • : 5 .
  • : 192 500 55 875
    , 01.01.2022 01.11.2030

20.06.2022
192 500

:

,    . , , -, . , , -. . .

:

  • Oracle.
  • Oracle Network.
  • .
  •    .
  • .
  • .
  • Database Cloud Service .

: 20, 19c, 18c, 12cR2.

:

  • SQL PL/SQL .
  • Linux

:

  • Oracle
  • Oracle Database Cloud Service (DBCS)
  • DBCS

:

:


Oracle - , . Oracle Cloud. HR. 

Oracle

  • Oracle.
  • Oracle.
  • .
  • Oracle.
  • .
  • Multitenant .
  • Automatic Storage Management (ASM).

Oracle Database Cloud 

  • Oracle Database Cloud Service Architecture.
  • Features and Tooling.

Oracle Database Cloud Service (DBCS) 

  • Creation Wizard.
  • SSH.

Oracle

  • SQL*Plus. SQL Developer.
  • Database Configuration Assistant (DBCA).
  • Oracle Enterprise Manager Database Express.
  • Oracle Enterprise Manager Cloud Control.
  • Oracle Database Cloud Service Tools. 

DBCS

  • .
  • DBCS.
  • .

  • .
  • Oracle.
  • Down Oracle.
  • Automatic Diagnostic Repository (ADR).
  • .
  • .

Oracle Net 

  • Oracle Net Listener.
  • Oracle.
  • .
  • Oracle Net Services.
  • .

  • , Oracle Cloud.
  • , Oracle.
  • .
  • Profiles.
  • .
  • Principal . 

PDBs

  • PDBs.
  • PDBs Seed. PDBs.
  • Unplugging Plugging PDBs.
  • PDBs. 

Master Encryption Keys PDBs

  • Oracle Database Cloud Service.
  • Transparent Data Encryption (TDE).
  • CDB PDB Master Encryption Keys.

  • .
  • , .
  • .
  • , Oracle.
  • Online .
  • DBCS. 

  • Oracle.
  • .
  • .
  • .
  • .
  • .
  • .
  • Resumable . 

Undo

  • Undo .
  • Undo .
  • Undo Redo .
  • Local Undo Shared Undo.
  • Undo Rentention.
  • Undo. 

  • Oracle Data Pump. SQL*Loader.
  • .
  • Oracle Database Cloud Service. 

  • .
  • .
  • .
  • .
  • Flashback. 

  • Fast Recovery Area.
  • .
  • Redo Log .
  • Redo Log .
  • ARCHIVELOG. 

  • Backup Terminology.
  • Recovery Manager (RMAN).
  • RMAN.
  • Database Cloud Service (DBCS).
  • DBCS. 

  • Database Recovery Advisor.
  • NOARCHELOG.
  • ARCHIVELOG.
  • Database Cloud Service (DBCS). 

 

  • .
  • Automatic Workload Repository (AWR).
  • Automatic Database Diagnostic Monitor (ADDM).
  • Advisory Framework.
  • .
  • , .
  • .
  • .

SQL 

  • SQL.
  • Oracle.
  • .
  • SQL Tuning Advisor. SQL Access Advisor. SQL Performance Analyzer.
: Oracle Database: Administration Workshop



* -

:

:

: