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

Cas Training
Precio

Precio a consultar

Impartición

Máster en Madrid

Objetivos

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.

Sedes

Madrid
Enero 2019

Temario completo de este curso

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 .
Ver más

Más cursos relacionados de Bases de datos

INTECSSA - Instituto Inertia de Sistemas y Software Avanzado

Administración y Gestión Avanzada de Bases de Datos Oracle 12c

INTECSSA - Instituto Inertia de Sistemas y Software Avanzado - Máster online
Oracle Data Pump Curso 3: Administración de una Base de Datos Oracle 12c Introducción Explorar la arquitectura de una Base de Datos Oracle Gestión

1.500 
IVA exento
PUE

OCA DBA - Administering Oracle 12c Databases

PUE - Curso en Madrid y 1 sede más
Workshop Introducción a la Base de Datos Oracle 12c Instalación de una Infraestructura Oracle Grid para un Servidor aislado Instalación del software de Bases

1.525 
Intergrupo

Oracle 12C

Intergrupo - Curso online
DISEÑO Y PROGRAMACIÓN Instalación Arquitectura de una base de datos Oracle Tablas Relaciones Propiedades de tabla Índices El lenguaje SQL Vistas

Precio a consultar
Grupo Atrium

MÁSTER CERTIFICADO EXPERTO® EN BB.DD ORACLE 12c ONLINE

Grupo Atrium - Máster online
TEMARIO : 1. Introducción a Oracle: SQL 2.- Desarrollo con PL/SQL 3.- Administración Básica – DBA I 4.- Estrategias de Backup y Recuperación- DBA II

1.195 
INESEM -Formación Bonificada para Empresas

Especialista TIC en Gestión de Base de Datos con Oracle 12c

INESEM -Formación Bonificada para Empresas - Curso online
. ADMINISTRACIÓN: PRINCIPALES HERRAMIENTAS UNIDAD DIDÁCTICA 6. ARRANQUE Y PARADA UNIDAD DIDÁCTICA 7. CREACIÓN DE BASE DE DATOS UNIDAD DIDÁCTICA 8. INSTANCIA

420 
Ver más