Curso en Oracle Database 10g: Administration Workshop II

Análisis de educaedu

Pablo Nieves

Curso en Oracle Database 10g: Administration Workshop II

• Modalidad de impartición
  El Curso en Oracle Database 10g: Administration Workshop II es impartido de manera presencial.
• Número de horas
  Consultar el tiempo de duración en el centro.
• Titulación oficial
  El centro otorgará certificación a todos los participantes del curso.
• Valoración del programa
  En este curso el estudiante encontrará la preparación necesaria para presentar el examen para certificación Oracle Certified Profesional OCP. Esta certificación consiste en dar el siguiente paso en una provechosa carrera de trabajo con la tecnologia Oracle 11g, despues de obtener el grado de OCA.
• Precio del curso
  Consultar precio.
• Dirigido a
  El programa está dirigido a profesionales en diversas áreas interesados en esta certificación.
• Empleabilidad
  El profesional que reciba esta certificación obtendrá credibilidad laboral y múltiples herramientas para desempeñarse adecuadamente en su sitio de trabajo.

Comentarios sobre Curso en Oracle Database 10g: Administration Workshop II - Presencial - Bogotá - Cundinamarca

• Objetivos del curso
  Use RMAN to create and manage backup sets and image copies Recover the database to a previous point in time Use Oracle's Flashback technology to recover your database Detect block corruptions and take appropriate measures to correct them Use the various Database advisors and views to monitor and improve database performance Control database resource usage with the Resource Manager Simplify management tasks by using the Scheduler Improve the security of the listener
• Contenido
  Temas Del Curso:
  
  Using Globalization Support
  Datetimes with Timezones
  Specifying Language-Dependent Behavior
  Locale Variants
  Linguistic Sorting
  Case and Accent Insensitive Sorts
  Linguistic Comparisons
  Obtaining Information about the Current NLS Configuration
  
  Securing the Oracle Listener
  Listener Password Authentication
  Controlling Database Access
  Securing the EXTPROC Service Entry
  
  Configuring Recovery Manager
  Using a Flash Recovery Area with RMAN
  Setting Parameters for RMAN
  Starting RMAN
  Configuring Persistent Settings for RMAN
  Control File Autobackups
  Retention Policies
  
  Using Recovery Manager
  Issuing Recovery Manager Commands
  Parallelization of Backup Sets
  Compressed Backups
  Copying the Whole Database
  Making Incremental Backups
  Block Change Tracking
  Incrementally Updating Backups
  Monitoring RMAN Backups
  
  Diagnostic Sources
  The Alert Log
  Viewing Alerts with EM
  Alerts Notification
  Editing Thresholds
  Trace Files
  
  Recovering from non-critical losses
  Creating New Temporary Tablespace
  Recreating Redo Log Files
  Recovering an Index Tablespace
  Read-Only Tablespace Recovery
  Loss of Password Authentication File
  
  Database Recovery
  Recovery Steps
  User-Managed Recovery Procedures: RECOVER Command
  Types of incomplete recovery
  Incomplete Recovery Best Practices
  Recovery Using EM
  Simple Recovery Through RESETLOGS
  Point-in-time recovery using RMAN
  
  Flashback database
  When to Use Flashback Technology
  Configuring Flashback Database
  Monitoring Flashback Database
  Best Practices for the Database and Flash Recovery Area
  Flash Recovery Area Space Usage
  Flashback Database Examples
  
  Recovering from User Errors
  Recycle Bin
  Flashback Dropped Tables Using EM
  Querying Dropped Tables
  Flashback Versions Query
  Flashback Transaction Query
  Using Flashback Versions Query and Flashback Transaction Query
  Flashback Table
  Using EM To Flashback Tables
  
  Dealing with Database Corruption
  What is block corruption?
  Interpreting DBVERIFY
  The ANALYZE command
  How to Handle Corruptions
  The DBMS_REPAIR Package
  Block Media Recovery (BMR)
  Detecting Database Corruptions Using DBVERIFY
  Using RMAN to Repair Corrupt Blocks
  
  Automatic Database Management
  Automatic Optimizer Statistics Collection
  Workload Repository
  Database Control and Advisors
  Using the SQL Tuning Advisor
  Using the SQL Access Advisor
  Automatic Undo Retention Tuning
  
  Monitoring and Managing Storage
  Redo Logfile Size Advisor
  Resumable Statements
  Tablespace Space Usage Monitoring
  Accessing the Segment Advisor
  Shrinking Segments Using SQL
  Segment Resource Estimation
  Monitoring Index Space
  Identifying Unused Indexes
  
  Automatic Storage Management
  ASM Concepts
  ASM General Architecture
  Creating an ASM instance
  Creating tablespaces that use ASM storage
  Viewing ASM information
  Migrating a tablespace to use ASM storage
  
  Monitoring and Managing Memory
  Oracle Memory Structures
  Automatic PGA Memory Management
  Using the Memory Advisor
  Using Automatic Shared Memory Management to avoid long running query issues
  
  Managing Resources
  Creating a New Resource Plan
  Creating Resource Consumer Groups
  Assigning Users to Resource Consumer Groups
  Adaptive Consumer Group Mapping
  Using Sub-Plans to limit CPU Utilization
  Administering the Resource Manager
  Resource Plan Directives
  
  Automating Tasks with the Scheduler
  Creating a Scheduler Job
  Using Scheduler Programs
  Creating and Using Schedules
  Creating a Job Class
  Prioritizing Jobs within a Window
  Viewing Job Execution Details
  Creating a job that runs a program outside of the database
  
  MATERIAL INCLUIDO
  Oracle Database 10g: Administration Workshop II Common Spanish Student Kit
  Libreta
  Esfero

Otra formación relacionada con oracle