Solicita más información sobre este curso al centro de formación y uno de los colaboradores se pondrá en contacto contigo para resolver todas las dudas que tengas.

Busca el curso que te intereseSolicita más información
inicio / usuarios / Curso de Oracle Database 11g: Administration Workshop I

Curso de Oracle Database 11g: Administration Workshop I

 
titulo:

Curso de Oracle Database 11g: Administration Workshop I
Centro de formación:

Master D
tipo de curso:

Curso
Categoría:

oracle

otros leguajes

SQL
Metodología:

Online
provincia:

-
precio:  
convocatorias: Matriculas abiertas
Descripción: Proporciona a los alumnos un alto nivel de conocimientos en la materia.
Aprenderás a crear informes y paneles de control con la herramienta Oracle Business Intelligence para la toma de desiciones empresariales en tiempo real.
a quien va dirigido: Dirigido a:
* Administradores de Sistemas o perfiles técnicos que quieran aprender o perfeccionar sus conocimientos de la base de datos Oracle.
* Aquellos que desean obtener el Certificado Oficial de Oracle OCA.
requisitos: Ninguno
Lugar de impartición:
horarios:
Duración: 6 meses
descuentos: 10% descuento
becas: No
¿Prácticas en empresas? No
salidas profesionales: Consultar al centro
programa del curso: ORACLE DATABASE 11G:
ADMINISTRATION WORKSHOP I
1. Exploring the Oracle Database Architecture
• Oracle Database Architecture Overview
• Oracle ASM Architecture Overview
• Process Architecture
• Memory structures
• Logical and physical storage structures
• ASM storage components
2. Installing your Oracle Software
• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Installation: System Requirements
• Oracle Universal Installer (OUI)
• Installing Oracle Grid Infrastructure
• Installing Oracle Database Software
• Silent Install
3. Creating an Oracle Database
• Planning the Database
• Using the DBCA to Create a Database
• Password Management
• Creating a Database Design Template
• Using the DBCA to Delete a Database
4. Managing the Oracle Database Instance
• Start and stop the Oracle database and components
• Use Oracle Enterprise Manager
• Access a database with SQLPlus
• Modify database installation parameters
• Describe the stages of database startup
• Describe database shutdown options
• View the alert log
• Access dynamic performance views
www.masterdformacion.com
MASTERDformación
http://www.masterdformacion.com/cursos-oracle-database-administration-11g
5. Manage the ASM Instance
• Set up initialization parameter files for ASM instance
• Start up and shut down ASM instances
• Administer ASM disk groups
6. Configuring the Oracle Network Environment
• Use Enterprise Manager to create and configure the Listener
• Enable Oracle Restart to monitor the listener
• Use tnsping to test Oracle Net connectivity
• Identify when to use shared servers and when to use dedicated servers
7. Managing Database Storage Structures
• Storage Structures
• How Table Data Is Stored
• Anatomy of a Database Block
• Space Management in Tablespaces
• Tablespaces in the Preconfigured Database
• Actions with Tablespaces
• Oracle Managed Files (OMF)
8. Administering User Security
• Database User Accounts
• Predefined Administrative Accounts
• Benefits of Roles
• Predefined Roles
• Implementing Profiles
9. Managing Data Concurrency
• Data Concurrency
• Enqueue Mechanism
• Resolving Lock Conflicts
• Deadlocks
10. Managing Undo Data
• Data Manipulation
• Transactions and Undo Data
• Undo Data Versus Redo Data
• Configuring Undo Retention
www.masterdformacion.com
MASTERDformación
http://www.masterdformacion.com/cursos-oracle-database-administration-11g
11. Implementing Oracle Database Auditing
• Describe DBA responsibilities for security
• Enable standard database auditing
• Specify audit options
• Review audit information
• Maintain the audit trail
12. Database Maintenance
• Manage optimizer statistics
• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Set alert thresholds
• Use server-generated alerts
• Use automated tasks
• Performance Management
13. Performance Monitoring
• Managing Memory Components
• Enabling Automatic Memory Management (AMM)
• Automatic Shared Memory Advisor
• Using Memory Advisors
• Dynamic Performance Statistics
• Troubleshooting and Tuning Views
• Invalid and Unusable Objects
14. Backup and Recovery Concepts
• Part of Your Job
• Statement Failure
• User Error
• Understanding Instance Recovery
• Phases of Instance Recovery
• Using the MTTR Advisor
• Media Failure
• Archive Log Files
www.masterdformacion.com
MASTERDformación
http://www.masterdformacion.com/cursos-oracle-database-administration-11g
15. Performing Database Backups
• Backup Solutions: Overview
• Oracle Secure Backup
• User-Managed Backup
• Terminology
• Recovery Manager (RMAN)
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• Monitoring the Flash Recovery Area
16. Performing Database Recovery
• Opening a Database
• Data Recovery Advisor
• Loss of a Control File
• Loss of a Redo Log File
• Data Recovery Advisor
• Data Failures
• Listing Data Failures
• Data Recovery Advisor Views
17. Moving Data
• Describe ways to move data
• Create and use directory objects
• Use SQL*Loader to move data
• Use external tables to move data
• General architecture of Oracle Data Pump
• Use Data Pump export and import to move data
18. Working with Support
• Use the Enterprise Manager Support Workbench
• Work with Oracle Support
• Log service requests (SR)
• Manage patches
Enviar a un amigo
'
Curso de Oracle Database 11g: Administration Workshop I - cursosymaster.es
otros cursos relacionados

Centros recomendados

Tags

Curso de Oracle Database 11g: Administration Workshop I - cursosymaster.es , Online, -, Master D, oracle, otros leguajes, SQL