Cas Training

Master Administración de la Base de Datos ORACLE v.12c - Oracle Certified Professional

Cas Training
  • Imparte:
  • Modalidad:
    Presencial en Madrid
  • Precio:
    Consultar rellenando el formulario
  • Comienzo:
    Consultar rellenando el formulario
  • Lugar:
    C/ Basílica, 19 - 5º planta
    Madrid 28020
    España
  • Duración:
    126 Horas
  • Otras Convocatorias:

    Presentación

    El programa de certificación Oracle, ofrece tres niveles de certificación distintos -Asociado, Profesional y Master - cada uno diseñado para validar grados de competencia en conceptos y usos de la Tecnología de Oracle.

    Cada nivel ofrece un marco de referencia reconocido por la industria y que se aplica a roles de trabajo específicos.

    Cas Training ofrece a través del convenio WDP y Partner, los niveles de certificación OCA y OCP:
    •La certificación Oracle Certified Associate (OCA), corresponde a un nivel básico, que da las bases para dar soporte a productos Oracle.
    •La certificación 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 organización.
    La obtención de la Certificación OCP acredita las aptitudes de una persona aumentando su credibilidad profesional con reconocimiento a nivel mundial, garantizando un alto nivel de conocimientos técnicos y experiencia en la administración de la BBDD Oracle.

    Dirigido

    •Personas con conocimientos en Informática.
    •Formación Profesional.
    •Titulados Universitarios.
    •Profesionales que deseen actualizar sus conocimientos.

    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.

    Programa

    Introducción a SQL
    1. Introduction to Oracle Database
    2. Retrieve Data using the SQL SELECT Statement
    3. Learn to Restrict and Sort Data
    4. Usage of Single-Row Functions to Customize Output
    5. Invoke Conversion Functions and Conditional Expressions
    6. Aggregate Data Using the Group Functions
    7. Use Sub-queries to Solve Queries
    8. The SET Operators
    9. Use of DDL Statements to Create and Manage Tables
    10. Other Schema Objects
    11. Control User Access
    12. Management of Schema Objects
    13. Manage Objects with Data Dictionary Views
    14. Manipulate Large Data Sets
    15. Data Management in different Time Zones
    16. Retrieve Data Using Sub-queries
    17. Regular Expression Support

    Oracle Database 12c: Admin, Install and Upgrade Accelerated
    1. Introduction
    2. Exploring the Oracle Database Architecture
    3. Oracle Software Installation Basics
    4. Installing Oracle Database Software
    5. Creating an Oracle Database by Using DBCA
    6. Oracle Database Management Tools
    7. Managing the Database Instance
    8. Configuring the Oracle Network Environment
    9. Administering User Security
    10. Managing Database Storage Structures
    11. Managing Space
    12. Managing Undo Data
    13. Managing Data Concurrency
    14. Implementing Oracle Database Auditing
    15. Backup and Recovery Concepts
    16. Backup and Recovery Configuration
    17. Performing Database Backups
    18. Performing Database Recovery
    19. Moving Data
    20. Performing Database Maintenance
    21. Managing Performance

    Oracle Database 12c: Backup and Recovery Workshop
    1. Introduction
    2. Getting Started
    3. Configuring for Recoverablility
    4. Using the RMAN Recovery Catalog
    5. Backup Strategies and Terminology
    6. Performing Backups
    7. Improving Your Backups
    8. Using RMAN-Encrypted Backups
    9. Diagnosing Database Failures
    10. Restore and Recovery Concepts
    11. Performing Recovery, Part 1
    12. Performing Recovery, Part 2
    13. RMAN and Oracle Secure Backup
    14. Performing Tape Backups and Restores
    15. Using Flashback Technologies
    16. Using Flashback Database
    17. Managing Backup Space or Transporting Data
    18. Duplicating a Database
    19. RMAN Performance and Tuning
    20. Backup and Recovery Workshop

    Taller - Oracle Database 12c: Managing Multitenant Architecture
    1. Introduction
    1.1. Course Objectives
    1.2. Course Schedule
    1.3. Tools

    2. Container and Pluggable Database Architecture
    2.1. Challenges and Benefits
    2.2. Multitenant Architecture
    2.3. Provisioning PDBs
    2.4. Terminology

    3. CDB and PDB Creation
    3.1. Using Tools
    3.2. Configuring and Creating a CDB
    3.3. Creating PDBs
    3.4. Dropping PDBs
    3.5. Migrating PDBs

    4. Managing a CDB and PDBs
    4.1. Connection
    4.2. Managing a CDB and PDBs
    4.3. Managing PDBs Open Mode and Settings
    4.4. Configuring CDB and PDBs Initialization Parameters

    5. Managing Storage in a CDB and PDBs
    5.1. Managing Permanent Tablespaces in CDB and PDBs
    5.2. Managing Temporary Tablespaces in CDB and PDBs

    6. Managing Security in a CDB and PDBs
    6.1. Managing Common and Local Users
    6.2. Managing Common and Local Privileges
    6.3. Managing Common and Local Roles
    6.4. Understanding Shared and Non-Shared Objects
    6.5. Managing Common and Local Profiles

    7. Managing Availability
    7.1. Managing Backups
    7.2. Managing Recovery Operations
    7.3. Managing Flashback Database
    7.4. Duplicating PDBs
    7.5. Special Situations and Views

    8. Managing Performance
    8.1. Managing Performance
    8.2. Managing Resource Allocation
    8.3. Maximizing Consolidated Database Replay

    9. Miscellaneous
    9.1. Exporting and Importing Data
    9.2. Loading Data
    9.3. Auditing Operations
    9.4. Scheduling Jobs
    9.5. Using Other Products

    ¡Infórmate ahora sin compromiso!

    Publicidad

    Cursos Relacionados

    Ver otros masters de...