• Author / Uploaded
• Fredy

Citation preview

Oracle 18c Database Administrator DURACIÓN: 120 HORAS En este curso obtendrás los conocimientos y habilidades para la obtención del certificado Oracle Certified Associates (OCA) y Oracle Certified Professional (OCP), basado en el material oficial de Oracle bajo convenio Workforce Development Program (WDP).

DIRIGIDO Profesionales, egresados, interesados en convertirse en administradores de base de datos.

LOGROS DEL CURSO Al finalizar el curso serás capaz de instalar, administrar y gestionar el motor de datos en una infraestructura eficiente en Oracle 18c.

PRE-REQUISITOS • Oracle Database 12c: Introduction to SQL.

CERTIFICACIONES Al término de la capacitación obtendrás un certificado de “Oracle 18c Database Administrator” a nombre de Cibertec.

CONCEPTO Y TERMINOLOGÍA • SQL SELECT statement • Restricting and sorting data • Performing Database Maintenance • Managing Data Concurrency • Automatic Storage Management • Oracle Database Auditing • Managing Data Concurrency

• Managing Performance • Conversion functions • Conditional expressions • Oracle SQL*Plus • Oracle SQL Developer • Backup and Recovery • Moving Data

• RMAN recovery • RMAN-Encrypted backups • Performing backups • Multitenant Architecture • Auditing Operations • Pluggable Database Architecture • Container Database Architecture

CONTENIDO TEMÁTICO Oracle Database 18c: Administration Workshop Introduction • Oracle Database Architecture • Introduction to Oracle Database Cloud • Creating Oracle Database Cloud Service (DBCS) Deployments • Accessing an Oracle Database • Managing DBCS Database Deployments • Managing Database Instances • Oracle Net Services

• Administering User Security • Creating PDBs • Creating Master Encryption Keys for PDBs • Creating and Managing Tablespace • Managing Storage Space • Managing Undo Data • Moving Data • Backup and Recovery Concepts • Backup and Recovery Configuration

• Creating Database Backups • Performing Database Recovery • Monitoring and Tuning Database Performance • SQL Tuning

Oracle Database 18c: Backup and Recovery Workshop Introduction • Getting Started • Configuring for Recoverability • Using the RMAN Recovery Catalog • Backup Strategies and Terminology • Performing Backups • Improving Your Backups • Using RMAN-Encrypted Backups

• Diagnosing Failures • Restore and Recovery Concepts • Performing Complete Recovery • Performing Point-in-Time Recovery • Additional Recovery Operations • Using Flashback Technologies • Using Flashback Database • Transporting Data

• Performing Point-in-Time Recovery • Duplicating a Database • RMAN Troubleshooting and Tuning • Backup and Recovery Workshop

Oracle Database 18c: Managing Multitenant Architecture • CDB Basics • CDB and Regular PDBs • Application PDBs and Application Installation • PDB Creation • CDB and PDB Management

• Storage • Security • Backup and Duplicate • Recovery and Flashback • Performance Monitoring • Resources Allocation

• Data Movement • Upgrade methods • Miscellaneous