Curso de Oracle Database 10g DBA OCA

Análisis de educaedu

Pablo Nieves

Curso de Oracle Database 10g DBA OCA

• Modalidad de impartición
  El Curso de Oracle Database 10g DBA OCA es impartido en modalidad presencial.
• Número de horas
  El tiempo total de duración del curso es de 20 horas.
• Titulación oficial
  El participante recibirá certificación por las horas cursadas.
• Valoración del programa
  A 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 a
  Este programa está dirigido principalmente a ingenieros de sistemas, desarrolladores de software, y demás profesionales o estudiantes del área informática.
• Empleabilidad
  El participante podrá incrementar la calidad de su desempeño laboral a través de este conocimiento.

Comentarios sobre Curso de Oracle Database 10g DBA OCA - Presencial - Bogotá - Cundinamarca

• Curso dirigido a
  Ingenieros de Sistemas, Administradores de Bases de Datos, estudiantes de últimos semestres de Ing. de Sistemas.
• Contenido
  Curso 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)

Otra formación relacionada con oracle