Modalidad de imparticiónEl Curso de Oracle Database 10g DBA OCA es impartido en modalidad presencial.
Número de horasEl tiempo total de duración del curso es de 20 horas.
Titulación oficialEl participante recibirá certificación por las horas cursadas.
Valoración del programaA través de los módulos que componen este programa, la Universidad del Bosque se propone enseñar al estudiante diferentes herramientas pertenecientes a este programa, que le permitan adquirir la capacidad y destreza necesarias para la administración de la Base de Datos Oracle 10g.
Dirigido aEste programa está dirigido principalmente a ingenieros de sistemas, desarrolladores de software, y demás profesionales o estudiantes del área informática.
EmpleabilidadEl participante podrá incrementar la calidad de su desempeño laboral a través de este conocimiento.
Curso de Oracle Database 10g DBA OCA
Curso dirigido aIngenieros de Sistemas, Administradores de Bases de Datos, estudiantes de últimos semestres de Ing. de Sistemas.
ContenidoCurso Oracle Database 10g DBA OCA
Horario: Sábados de 1:00 a 5:00 pm.
Intensidad Horaria: 20 Horas.
Valor Agregado
Descuento en Voucher de Certificación
Material de ORACLE
OBJETIVO:
Adquirir la capacidad y destreza para administrar la Base de Datos Oracle 10g.
METODOLOGÍA:
Con material de Oracle se revisará cada módulo y se realizará la práctica correspondiente.
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)