Inicio


Curso

Oracle Database 10g DBA OCA


Información del curso

Temática
Gerencia y Administrativo

Administración

Técnico Científico

Ingeniería de Sistemas

Información del curso
Tipo de curso

Abierto

Descripción

PROGRAMA ACADÉMICO


MÓDULO I: Architecture


 Outline the Oracle Architecture and its main Components

 Explain the Oracle instance architecture


MÓDULO II: Installing the Oracle Database Software

 Identify common database administrative tools available to a DBA (1)

 Use optimal flexible architecture

 Install software with Oracle Universal Installer

 Identify and configure commonly used environment variables

 Use Installer Log (2)


MÓDULO III: Creating an Oracle Database

 Use DBCA to Create a database

 Use DBCA to Delete a database

 Use DBCA to manage templates


MÓDULO IV: Managing the Oracle Instance

 Use Enterprise Manager

 Use SQL*Plus and iSQL*Plus to access the Oracle Database

 Modify database initialization parameters

 Describe the stages of database startup

 Describe the database shutdown options

 View the database alert log

 Use dynamic performance views (3)


MÓDULO V: Managing Database Storage Structures

 Describe how table row data is stored in blocks (4)

 Define the purpose of tablespaces and data files

 Explain space management in tablespaces

 Create tablespaces

 Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL

 Obtain tablespace information

 Explain key features and benefits of ASM (5)


MÓDULO VI: Administering User Security

 Create and manage database user accounts

 Create and manage roles

 Grant and revoke privileges

 Create and manage profiles (6)



MÓDULO VII: Managing Schema Objects

 Create and modify tables

 Define constraints and states of constraints (7)

 Dropping and truncating tables (7)

 Create and use B-Tree and Bitmap indexes (8)

 Create Views

 Create sequences

 Use data dictionary


MÓDULO VIII: Managing Data and Concurrency

 Manipulate data through the use of SQL

 Identify and administer PL/SQL objects

 Describe triggers and triggering events

 Define levels of locking

 List possible causes of lock conflict

 Monitor and resolve lock conflicts


MÓDULO IX: Managing Undo Data

 Monitor and administer undo

 Configure undo retention

 Describe the relationship between undo and transactions

 Size the undo tablespace


MÓDULO X: Implementing Oracle Database Security

 Apply the principle of least privilege

 Audit database activity

 Implement Fine-Grained Auditing


MÓDULO XI: Configuring the Oracle Network Environment

 Use Database Control to Create additional listeners

 Use Database Control to Create Oracle Net service aliases

 Control Oracle Net Listeners

 Identify when to use shared servers versus dedicated servers


MÓDULO XII: Proactive Maintenance

 Gather optimizer statistics

 Manage the Automatic Workload Repository

 Use the Automatic Database Diagnostic Monitor (ADDM)

 Set warning and critical alert thresholds

 React to performance issues



MÓDULO XIII: Performance Management

 Use enterprise manager to view performance (9)

 Tune SQL by using SQL tuning advisor (10)

 Tune SQL by using SQL access advisor

 Use automatic shared memory management (11)

 Use the memory advisor to size memory buffer (11)


MÓDULO XIV: Backup and Recovery Concepts

 Describe the types of failure that may occur in an Oracle Database

 Identify the importance of checkpoints, redo log files, and archived log files

 Tuning instance recovery

 Configure a database for recoverability

 Configure ARCHIVELOG mode


MÓDULO XV: Performing Database Backup

 Create consistent database backups

 Back up your database without shutting it down

 Create incremental backups

 Automate database backups

 Backup a control file to trace

 Monitor flash recovery area


MÓDULO XVI: Performing Database Recovery

 Recover from loss of a Control file

 Recover from loss of a Redo log file

 Recover from loss of a system-critical data file

 Recover from loss of a non system-critical data file


MÓDULO XVII: Performing Flashback

 Describe flashback database (12)

 Resotore the table contents to a specific point in time (12)

 Recover from a dropped table (12)

 Use Flashback Query to view the contents of the database as of any single point of time (12)

 View transaction history or row with flashback transaction query (12)


MÓDULO XVIII: Moving Data

 Describe the general architecture of Data Pump (13)

 Use Data Pump export and import to move data between Oracle databases

 Load data with SQL Loader (14)

 Use external tables to move data (14)

 

Información comercial del curso
Intensidad

Sábados de 1:00 a 5:00 PM
20 Horas

Modalidad

PRESENCIAL

Dirigido a

Ingenieros de Sistemas, Administradores de Bases de Datos, estudiantes de últimos semestres de Ing. de Sistemas

Tipo de certificación obtenida

ASISTENTE

Valor agregado

 Descuento en Voucher de Certificación
 Material de ORACLE

Etiquetado como:

Información de contacto

Contacto Educación Continuada