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

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