Menú
¡Llama gratis! 900 264 357

Máster en Administración de la Base de Datos ORACLE v.12c de CAS TRAINING

CAS TRAINING

CAS TRAINING
Presencial Duración: 126 horas
Pedir información
Impartido en: Madrid
Certificación Oficial Oracle DBA (OCA + OCP). La obtención de la Certificación OCP acredita las aptitudes de una persona aumentando su credibilidad profesional con reconocimiento a nivel mundial

Presentación

Certifícate en OCA y OCP aumentarás tu credibilidad profesional y reconocimiento a nivel mundial, una excelente opción para certificarte si deseas desarrollar tu carrera profesional en este sector.

En esta oportunidad desde Cas Training en convenio con WDP y Partner ofrecemos en esta formación los niveles de certificación OCA y OCP.

La certificación Oracle Certified Associate (OCA), es un nivel básico que permite dar las bases para brindar soporte a diferentes productos Oracle, mientras que la certificación Oracle Certified Professional (OCP) es un nivel de experto que se emplea para administrar base de datos de gran escala y también para desarrollar aplicaciones empleables a nivel global en una organización.


Con la Certificación OCP acreditas tu alto nivel de conocimientos técnicos y experiencia en la administración de la BBDD Oracle.

A quién va dirigido

El máster está especialmente dirigido a:

Toda persona que posea conocimientos de informática, a personas con formación profesional o titulados universitarios interesados en ampliar sus conocimientos en administración de la base de datos ORACLE v.12c.

Todo profesional del sector IT que desee actualizar sus conocimientos en el contenido de la formación.


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 .

Titulación obtenida

Una vez finalizada la formación el estudiante obtendrá las certificaciones: Oracle Certified Associate (OCA) y Oracle Certified Professional (OCP).

Requisitos

Para acceder a la formación es necesario que el estudiante cuente con conocimientos previos y experiencia en el sector de IT.



Objetivos

Estudiar el procedimiento para combinar varias consultas en una sola utilizando operadores SET.

Aprender a utilizar las funciones de grupo para elaborar informes.

Adquirir conocimientos de la instalación y administración de Bases de datos Oracle 12c.

Estudiar los conceptos relacionados a la arquitectura multitenant.

Contacta ahora con el centro