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.
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.
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.
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 .
Una vez finalizada la formación el estudiante obtendrá las certificaciones: Oracle Certified Associate (OCA) y Oracle Certified Professional (OCP).
Para acceder a la formación es necesario que el estudiante cuente con conocimientos previos y experiencia en el sector de IT.
