Cas Training

Administración de la Base de Datos ORACLE v.12c

4.5 1 opinión
Cas Training
En Madrid
  • Cas Training

Precio a consultar
CURSO PREMIUM
Fináncialo cómodamente
¿Quieres hablar con un asesor sobre este curso?
¿Quieres hablar con un asesor sobre este curso?

Información importante

Tipología Master
Lugar Madrid
Horas lectivas 126h
Duración Flexible
Inicio Septiembre
otras fechas
  • Master
  • Madrid
  • 126h
  • Duración:
    Flexible
  • Inicio:
    Septiembre
    otras fechas
Descripción

¿Te interesa la informática? ¿Quieres seguir ampliando tus conocimientos? Si estás pensando en completar tu formación, este curso que Emagister.com incorpora a su catálogo formativo te interesará.

El centro Cas Training ha diseñado el plan de estudios del Curso de Administración de la Base de Datos ORACLE, que imparte en modalidad presencial en Madrid. Con esta formación, aprenderás a evaluar tus propios requisitos de recuperación y a desarrollar estrategias adaptadas a distintos casos.

Si quieres conocer todos los detalles sobre este curso, puedes hacerlo fácilmente. Solo tienes que hacer clic en el botón de solicitar información y contactaremos contigo lo más pronto posible para resolver todas tus dudas.

Información importante

Bonificable: Curso bonificable para empresas
Si eres trabajador en activo, este curso te puede salir gratis a través de tu empresa.

Instalaciones (1) y fechas
Dónde se imparte y en qué fechas
Inicio Ubicación
Septiembre
Septiembre
Madrid
C/ Basílica, 19, 28020, Madrid, España
Ver mapa
Inicio Septiembre
Septiembre
Ubicación
Madrid
C/ Basílica, 19, 28020, Madrid, España
Ver mapa

A tener en cuenta

· ¿Cuáles son los objetivos de este curso?

Objetivos de la Certificación OCA y OCP • 1Z0-061: Oracle Database 12c: SQL Fundamentals. • 1Z0-062: Oracle Database 12c: Installation and Administration. • 1Z0-063: Oracle Database 12c: Advanced Administration.

· ¿A quién va dirigido?

• Personas con conocimientos en Informática. • Formación Profesional. • Titulados Universitarios. • Profesionales que deseen actualizar sus conocimientos.

· Requisitos

Conocimientos y experiencia en el sector IT.

Preguntas & Respuestas

Plantea tus dudas y otros usuarios podrán responderte

Opiniones

4.5
Valoración del curso
100%
Lo recomiendan
4.2
fantástico
Valoración del Centro

Opiniones sobre este curso

S
Sergio Casillas
4.5 06/11/2015
Lo mejor: Este curso ha sido genial, no puedo decir otra cosa. Haría cualquier otro curso encantado.
A mejorar: .
¿Recomendarías este curso?:
¿Te ha ayudado esta opinión? (0)
* Opiniones recogidas por Emagister & iAgora

¿Qué aprendes en este curso?

Oracle
Oracle v.12c
Competencias tecnológicas
Competencias digitales
Competencias individuales
Trabajo en equipo
Conocimientos en uso de tecnología flashback
Conocimientos en uso del frashback de BB.DD
Conocimientos en administración de la memoria
Conocimientos en administración del rendimiento de BB.DD
Conocimientos en uso del asesor de segmentos
Conocimientos en gestión de recursos
Conocimientos en automatización de tareas Scheduler Oracle
Conocimientos en administración de Scheduler de Oracle
Conocimientos en soporte de globalización

Profesores

Profesores certificados IT con alto nivel de conocimiento
Profesores certificados IT con alto nivel de conocimiento
Amplia experiencia en el sector

Profesores de máximo nivel, con amplia experiencia en el sector IT. Nuestros profesores cuentan además con una sólida carrera docente. Todos los cursos se desarrollan en un ambiente eminentemente práctico.

Temario

D79027GC10–Oracle Database 12c: Admin, Install and Upgrade Accelerated

  • INTRODUCTION
    • Course Objectives.
    • Course Schedule.
    • Overview of Oracle Database 12c.
    • Overview of Oracle Cloud.
    • Overview of the HR Schema.
  • EXPLORING THE ORACLE DATABASE ARCHITECTUR.
    • Oracle Database 12c Introduction.
    • Oracle Database Architecture: Overview.
    • Oracle Database Instance Configurations.
    • Connecting to the Oracle Database Instance.
    • Oracle Database memory Structures (overview).
    • Process Architecture (description).
    • Process Structures.
    • Process Startup Sequen.
  • ORACLE SOFTWARE INSTALLATION BASICS
    • Planning Your Installation.
    • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM.
    • Operating System Groups and Users.
    • Environment Variables.
    • Configuring the Oracle Software Owner Environment.
    • Using Oracle Universal Installer (OUI).
    • Installation Option: Silent Mode.
  • INSTALLING ORACLE DATABASE SOFTWARE
    • System Requirements for Oracle Database.
    • Operating.
    • Types of Installations.
  • CREATING AN ORACLE DATABASE BY USING DBCA
    • Planning the Database Storage Structure.
    • Types of Databases (based on workload).
    • Choosing the Appropriate Character Set.
    • Understanding How Character Sets are Used.
    • Setting the NLS_LANG Initialization Parameter.
    • Using the Database Configuration Assistant (DBCA).
  • ORACLE DATABASE MANAGEMENT TOOLS
    • Introducing Oracle Database Management Tools.
    • Using SQL*Plus.
    • Using SQL Developer.
    • Logging in to Oracle Enterprise Manager Database Express.
    • Using the Enterprise Manager Database Express Home Pag.
    • Understanding the Enterprise Manager Cloud Control Framework.
    • Using Enterprise Manager Cloud Control.
  • MANAGING THE DATABASE INSTANCE
    • Initialization Parameter Files.
    • Starting an Oracle Database Instance.
    • Shutting Down an Oracle Database Instance.
    • Viewing Log Files.
    • Using Trace Files.
    • Using the Dynamic Performance Views.
    • Data Dictionary.
  • CONFIGURING THE ORACLE NETWORK ENVIRONMENT
    • Oracle Net Services Overview.
    • Oracle Net Listener Overview.
    • Establishing Oracle Network Connections.
    • Connecting to a Server.
    • Tools for Configuring and Managing the Oracle Network.
    • Using the Listener Control Utility.
    • Using Oracle Net Configuration Assistant.
    • Using Oracle Net Manager.
  • ADMINISTERING USER SECURITY
    • Database User Accounts (overview).
    • Predefined Administrative Accounts.
    • Creating a User.
    • Authentication.
    • Unlocking a User Account and Resetting the Password.
    • Privileges.
    • Roles.
    • Profiles.
  • MANAGING DATABASE STORAGE STRUCTURES
    • Understanding Storage of Data.
    • Database Block contents.
    • Exploring the Storage Structure.
    • Creating a New Tablespace.
    • Overview of Tablespaces Created by Default.
    • Managing Tablespaces.
    • Viewing Tablespace Information.
    • Using Oracle Managed Files.
  • MANAGING SPACE
    • Space Management Overview.
    • Block Space Management.
    • Row Chaining and Migration.
    • Free Space Management Within Segments.
    • Types of Segments.
    • Allocating Extents.
    • Allocating Space.
    • eating Tables Without Segments.
  • MANAGING UNDO DATA
    • Undo Data Overview.
    • Transactions and Undo Data.
    • Storing Undo Information.
    • Comparing Undo Data and Redo Data.
    • Managing Undo.
    • Configuring Undo Retention.
    • Guaranteeing Undo Retention.
    • Changing an Undo tablespace to a Fixed Size.
  • MANAGING DATA CONCURRENCY
    • Overview of Locks.
    • Locking Mechanism.
    • Data Concurrency.
    • DML Locks.
    • Enqueue Mechanism.
    • Lock Conflicts.
  • IMPLEMENTING ORACLE DATABASE AUDITING
    • Separation of Responsibilities.
    • Database Security.
    • Monitoring for Compliance.
    • Standard Database Auditing.
    • Unified Audit Data Trail.
    • Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles).
    • Configuring the Audit Trail.
    • Specifying Audit Options.
  • BACKUP AND RECOVERY CONCEPTS
    • Categories of Failures.
    • Flashback Technology.
    • Understanding Instance Recovery.
    • Phases of Instance Recovery.
    • Tuning Instance Recovery.
    • Using the MTTR Advisor.
    • Comparing Complete and Incomplete Recovery.
    • Oracle Data Protection Solutions.
  • BACKUP AND RECOVERY CONFIGURATION
    • Configuring for Recoverability.
    • Configuring the Fast Recovery Area.
    • Multiplexing the Control File.
    • Online Redo Log File.
    • Multiplexing the Online Redo Log File.
    • Archived Redo Log Files.
    • Archiver Process.
    • Archived Redo Log File Naming and Destinations.
  • PERFORMING DATABASE BACKUPS
    • Backup Solutions Overview.
    • Oracle Secure Backup (overview).
    • User Managed Backup (overview).
    • Backup Terminology and Types of Backups.
    • Using Recovery Manager (RMAN).
    • Configuring Backup Settings.
    • Oracle-Suggested Backup.
    • Backing Up the Control File to a Trace File.
  • PERFORMING DATABASE RECOVERY
    • Data Recovery Advisor.
    • Loss of a Control File.
    • Loss of a Redo Log File.
    • Loss of a Datafile in NOARCHIVELOG Mode.
    • Loss of a Noncritical Datafile in ARCHIVELOG Mode.
    • Loss of a System-Critical Datafile in ARCHIVELOG Mode.
  • MOVING DATA
    • Moving Data: General Architecture.
    • Oracle Data Pump.
    • SQL*Loader.
    • External Tables.
  • PERFORMING DATABASE MAINTENANCE
    • Database Maintenance (overview).
    • Viewing the Alert History.
    • Terminology.
    • Automatic Workload Repository (AWR).
    • Statistic Levels.
    • Automatic Database Diagnostic Monitor (ADDM).
    • Advisory Framework.
    • Enterprise Manager and Advisors.
  • MANAGING PERFORMANCE
    • Performance Monitoring.
    • Tuning Activities.
    • Performance Planning.
    • Instance Tuning.
    • Performance Tuning Methodology.
    • Performance Tuning Data.
    • Monitoring Performance.
    • Managing Memory.
  • MANAGING PERFORMANCE: SQL TUNING
    • SQL Tuning.
    • Oracle Optimizer.
    • SQL Plan Directives.
    • Adaptive Execution Plans.
    • SQL Advisors.
    • Automatic SQL Tuning results.
    • Implement Automatic Tuning Recommendations.
    • SQL Tuning Advisor.

D78850GC10 – Oracle Database 12c: Backup and Recovery Workshop

  • INTRODUCTION
    • Curriculum Context.
    • Assess your Recovery Requirements.
    • Categories of failures.
    • Oracle Backup and Recovery Solutions.
    • Oracle Maximum Availability Architecture.
    • Oracle Secure Backup.
    • Benefits of using Oracle Data Guard.
    • Basic Workshop Architecture.
  • GETTING STARTED
    • Core Concepts of the Oracle Database, Critical for Backup and Recovery.
    • Oracle DBA Tools for Backup and Recovery.
    • Connecting to Oracle Recovery Manager (RMAN).
    • Quick Start: A Problem-Solution Approach.
  • CONFIGURING FOR RECOVERABLILITY
    • RMAN commands.
    • Configuring and managing persistent settings.
    • Using the Fast Recovery Area (FRA).
    • Control File.
    • Redo Log File.
    • Archiving Logs.
  • USING THE RMAN RECOVERY CATALOG
    • Creating and Configuring the Recovery Catalog.
    • Managing Target Database Records in the Recovery Catalog.
    • Using RMAN Stored Scripts.
    • Maintaining and Protecting the Recovery Catalog.
    • Virtual Private Catalogs.
  • BACKUP STRATEGIES AND TERMINOLOGY
    • Backup Solutions Overview and Terminology.
    • Balancing Backup and Restore Requirements.
    • Backing Up Read-Only Tablespaces.
    • Best Practices for Data Warehouse Backups.
    • Additional Backup Terminology.
  • PERFORMING BACKUPS
    • RMAN Backup Types.
    • Incrementally Updated Backups.
    • Fast Incremental Backup.
    • Block Change Tracking.
    • Oracle-Suggested Backup.
    • Reporting on Backups.
    • Managing Backups.
  • IMPROVING YOUR BACKUPS
    • Compressing Backups.
    • Using a Media Manager.
    • Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets.
    • Creating and Managing Archival Backups.
    • Backing Up Recovery Files.
    • Backing Up the Control File to a Trace File.
    • Cataloging Additional Backup Files.
    • Backing Up ASM Disk Group Metadata.
  • USING RMAN-ENCRYPTED BACKUPS
    • Creating RMAN-Encrypted Backups.
    • Using Transparent-Mode Encryption.
    • Using Password-Mode Encryption.
    • Using Dual-Mode Encryption.
  • DIAGNOSING DATABASE FAILURES
    • Reducing Problem Diagnosis Time.
    • Automatic Diagnostic Repository.
    • Interpreting RMAN Message Output and Error Stacks.
    • Data Recovery Advisor.
    • Diagnosing Data File Loss (file system and ASM).
    • Handling Block Corruption.
  • RESTORE AND RECOVERY CONCEPTS
    • Restoring and Recovering.
    • Instance Failure and Instance/Crash Recovery.
    • Media Failure.
    • Complete Recovery (Overview).
    • Point-in-Time Recovery (Overview).
    • Recovery Through RESETLOGS.
  • PERFORMING RECOVERY, PART 1
    • RMAN Recovery in NOARCHIVELOG Mode.
    • Performing Complete Recovery (of critical and noncritical data files).
    • Restoring ASM Disk Groups.
    • Recovery with Image Files.
    • Performing Point-in-Time (PITR) or Incomplete Recovery.
    • Table Recovery from Backups.
  • PERFORMING RECOVERY, PART 2
    • Recovery of Server Parameter File, Control File.
    • Redo Log File Loss and Recovery.
    • Password Authentication File Re-creation.
    • Index, Read-Only Tablespace, and Tempfile Recovery.
    • Restoring the Database to a New Host.
    • Disaster Recovery.
    • Restoring RMAN Encrypted Backups.
  • RMAN AND ORACLE SECURE BACKUP
    • Oracle Secure Backup Overview.
    • Oracle Database Disk and Tape Backup Solution.
    • Backing Up the Fast Recovery Area to Tape.
    • Defining Retention for RMAN Backups.
    • RMAN and Oracle Secure Backup Basic Process Flow.
    • Integration with Cloud Control.
    • RMAN Database Backup to Tape.
  • PERFORMING TAPE BACKUPS AND RESTORES
    • Scheduling Backups with EM.
    • Oracle-Suggested Backup.
    • RMAN and OSB Process Flow.
    • RMAN and Oracle Secure Backup Jobs.
    • Managing Database Tape Backups.
    • Performing Database Recovery.
    • RMAN Automatic Failover to Previous Backup.
  • USING FLASHBACK TECHNOLOGIES
    • Flashback Technology: Overview and Setup.
    • Using Flashback Technology to Query Data.
    • Flashback Table.
    • Flashback Transaction (Query and Backout).
    • Flashback Drop and the Recycle Bin.
    • Flashback Data Archive.
  • USING FLASHBACK DATABASE
    • Flashback Database Architecture.
    • Configuring Flashback Database.
    • Performing Flashback Database.
    • Best Practices for Flashback Database .
  • MANAGING BACKUP SPACE OR TRANSPORTING DATA
    • Transporting Tablespaces.
    • Transporting Databases.
  • DUPLICATING A DATABASE
    • Using a Duplicate Database.
    • Choosing Database Duplication Techniques.
    • Creating a Backup-up Based Duplicate Database.
    • Understanding the RMAN Duplication Operation.
    • Using Cloud Control to Clone a Database.
  • RMAN PERFORMANCE AND TUNING
    • Tuning Principles.
    • RMAN Multiplexing.
    • Diagnosing Performance Bottlenecks.
    • Restore and Recovery Performance Best Practices.
  • BACKUP AND RECOVERY WORKSHOP
    • Workshop Structure.
    • Workshop Approach to Solving Failure Scenarios.
    • Business Requirements for Database Availability and Procedure.

Oracle Database 12c: Managing Multitenant Architecture

  • INTRODUCTION
    • Course Objectives.
    • Course Schedule.
    • Tools.
  • CONTAINER AND PLUGGABLE DATABASE ARCHITECTURE
    • Challenges and Benefits.
    • Multitenant Architecture.
    • Provisioning PDBs.
    • Terminology.
  • CDB AND PDB CREATION
    • Using Tools.
    • Configuring and Creating a CDB.
    • Creating PDBs.
    • Dropping PDBs.
    • Migrating PDBs.
  • MANAGING A CDB AND PDBS
    • Connection.
    • Managing a CDB and PDBs.
    • Managing PDBs Open Mode and Settings.
    • Configuring CDB and PDBs Initialization Parameters.
  • MANAGING STORAGE IN A CDB AND PDBS
    • Managing Permanent Tablespaces in CDB and PDBs.
    • Managing Temporary Tablespaces in CDB and PDBs.
  • MANAGING SECURITY IN A CDB AND PDBS
    • Managing Common and Local Users.
    • Managing Common and Local Privileges.
    • Managing Common and Local Roles.
    • Understanding Shared and Non-Shared Objects.
    • Managing Common and Local Profiles.
  • MANAGING AVAILABILITY
    • Managing Backups.
    • Managing Recovery Operations.
    • Managing Flashback Database.
    • Duplicating PDBs.
    • Special Situations and Views.
  • MANAGING PERFORMANCE
    • Managing Performance.
    • Managing Resource Allocation.
    • Maximizing Consolidated Database Replay.
  • MISCELLANEOUS
    • Exporting and Importing Data.
    • Loading Data.
    • Auditing Operations.
    • Scheduling Jobs.
    • Using Other Products .