Powered by:

Master Administracin de la Base de Datos ORACLE v.12c

Modalidad:
Presencial
Precio:
-
Fecha de Inicio:
-
Provincia:
N.D.

El Master Administracin de la Base de Datos ORACLE v.12c - Oracle Certified Professional es presencial en Madrid.

La obtencin de la Certificacin OCP acredita las aptitudes de una persona aumentando su credibilidad profesional con reconocimiento a nivel mundial

Cas Training ofrece a travs del convenio WDP y Partner, los niveles de certificacin OCA y OCP:

La certificacin Oracle Certified Associate (OCA), corresponde a un nivel bsico, que da las bases para dar soporte a productos Oracle.
La certificacin Oracle Certified Professional (OCP), representa el nivel de experto avanzado necesario para administrar base de datos de gran escala o para desarrollar aplicaciones que se puedan poner en funcionamiento a nivel global en una organizacin.

La obtencin de la Certificacin OCP acredita las aptitudes de una persona aumentando su credibilidad profesional con reconocimiento a nivel mundial, garantizando un alto nivel de conocimientos tcnicos y experiencia en la administracin de la BBDD Oracle.

Los profesionales certificados como OCP tienen una alta demanda en el mundo actual y se espera que dicha demanda crezca al aumentar el nmero de instalaciones de tecnologas de Oracle alrededor del mundo. Es el mejor aliado para desarrollar una prometedora carrera profesional en el sector de las tecnologas de la informacin.

Conocimientos y experiencia en el sector IT.

Personas con conocimientos en Informtica.
Formacin Profesional.
Titulados Universitarios.
Profesionales del sector IT que deseen actualizar sus conocimientos.
Objetivos de la Certificacin 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.

D79027GC10Oracle 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.

 126 horas

Cursos Relacionados