Curso Oracle Data Base 12C
Fecha de inicio
Fecha de finalización
Horario
Sábados de 1:00 p.m. a 6:00 p.m.
Inversión
$ 2500000 COP
Descuentos especiales
Comunidad el Bosque 15% de descuento, Descuento grupal 10% a partir de 2 participantes en adelante, Descuento Afiliado a Colsubsidio 10%. Descuento del 12% afiliados a Protección. **Los descuentos no son acumulables.
En contacto
Daniel Augusto Gómez Cortés

Daniel Augusto Gómez Cortés

Asistente Profesional
Ext. 1140

Dirigido a
Ingenieros de sistemas, Administradores de bases de datos, estudiantes de últimos semestres de Ingeniería de Sistemas y todas las personas que deseen certificarse en bases de datos Oracle.
Generalidades
Descripción del programa

Preparación para la Certificación en Bases de Datos Oracle 12C:

  • Administration Workshop
  • Install and Upgrade Workshop
Valor agregado
  • Material Original de instalación.
  • Material Original de administración.
  • Voucher para la certificación.
  • Suscripción con Oracle de 6 meses para la preparación del examen de certificación.
    Objetivos

    Adquirir la capacidad y destreza para instalar, actualizar y administrar la Base de Datos Oracle 12C.

    Metodología

    Con material original de Oracle se revisará cada módulo y se hará la práctica correspondiente.

    Oracle Database 12C: Install and Upgrade Workshop

    • Oracle Database 12c Introduction

    • Oracle Database Architecture Overview

    • Oracle Database Instance Configurations

    • Oracle Database Memory Structures

    • Process Structures

    • Database Storage Architecture

    • Logical and Physical Database Structures

    • Container and Pluggable Database Overview

     

    Installing Oracle Grid Infrastructure for a Standalone Server

    • Overview of Oracle Grid Infrastructure for a Standalone Server

    • System Requirements for Oracle Grid Infrastructure

    • Configuring Storage for Oracle Automatic Storage Management (ASM)

    • Installing Oracle Grid Infrastructure for a Standalone Server

    • Upgrading Oracle Grid Infrastructure for a Standalone Server

     

    Installing Oracle Database Software

    • Planning Your Installation

    • System Requirements for Oracle Database

    • Preparing the Operating System

    • Using 4 KB Sector Disks

    • Setting Environment Variables

    • Checking the System Requirements

    • Using the Oracle Universal Installer (OUI)

    • Performing a Silent Mode Installation

     

    Creating an Oracle Database by Using DBCA

    • Planning the Database Storage Structure

    • Choosing non-CDB or CDB

    • 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)

     

    Using Oracle Restart

    • Oracle Restart Overview

    • Oracle Restart Process startup

    • Controlling Oracle Restart

    • Choosing the Correct SRVCTL Utility

    • Oracle Restart Configuration

    • Using the SRVCTL Utility

    • Obtaining Help for the SRVCTL Utility

    • Starting Components by Using the SRVCTL Utility

     

    Introduction to Upgrading to Oracle Database 12c

    • Upgrade Methods

    • Data Migration Methods

    • Supported Releases for Direct Upgrade

    • Overview of Upgrade Process

    • Performing a Rolling Upgrade

    • Upgrading a CBD

     

    Preparing to Upgrade to Oracle Database 12c

    • Developing a Test Plan

    • Performance Testing

    • Requirements for Databases Using Oracle Label Security or Oracle Database Vault

    • Requirement for Databases Using Oracle Warehouse Builder

    • Using the Pre-Upgrade Information Tool

    • Backing Up the Database

    • Installing the Oracle Database 12c Software

    • Preparing the New Oracle Home

     

    Upgrading to Oracle Database 12c

    • Upgrading by Using the Database Upgrade Assistant (DBUA) 

    • Manually Upgrading to Oracle Database 12c

    • Migrating a non-CDB to a CDB

     

    Performing Post-Upgrade Tasks

    • Migrating to Unified Auditing

    • Performing Post-Upgrade Tasks Following a Manual Upgrade

     

    Migrating Data by Using Oracle Data Pump

    • Data Pump Overview

    • Migrating by Using Data Pump

    • Importing by Using a Network Link

    Oracle Database 12C: Administration Workshop Ed 2

    Introduction

    • Course Objectives

    • Course Schedule

    • Overview of Oracle Database 12c

    • Overview of Oracle Cloud

    • Overview of the HR Schema

     

    Exploring the Oracle Database Architecture

    • Oracle Database Architecture: Overview

    • Oracle Database Instance Configurations

    • Connecting to the Oracle Database Instance

    • Oracle Database Memory Structures

    • Process Architecture

    • Process Structures

    • Process Startup Sequence

    • Database Storage Architecture

     

    Managing the Database Instance

    • Introducing Oracle Database Management Tools

    • Understanding the Enterprise Manager Management Framework

    • Logging in to Oracle Enterprise Manager Database Express

    • Using the Enterprise Manager Database Express Home Page

    • Using Enterprise Manager Cloud Control

    • Using SQL*Plus

    • Using SQL Developer

    • Initialization Parameter Files

     

    Configuring the Oracle Network Environment

    • Oracle Net Services Overview

    • Oracle Net Listener Overview

    • Establishing Oracle Network Connections

    • Tools for Configuring and Managing the Oracle Network

    • Using the Listener Control Utility

    • Using Oracle Net Configuration Assistant

    • Using Oracle Net Manager

    • Using Enterprise Manager Cloud Control

     

    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

     

    Administering User Security

    • Database User Accounts

    • Predefined Administrative Accounts

    • Creating a User

    • Authentication

    • Unlocking a User Account and Resetting the Password

    • Privileges

    • Roles

    • Profiles

     

    Managing Data Concurrency

    • Overview of Locks

    • Locking Mechanism

    • Data Concurrency

    • DML Locks

    • Enqueue Mechanism

    • Lock Conflicts

     

    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

     

    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

     

    Performing Database Maintenance

    • Database Maintenance

    • 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

     

    Managing Resources by Using Database Resource Manager

    • Database Resource Manager Overview

    • Database Resource Manager Concepts

    • Using the Resource Manager

    • Default Maintenance Resource Manager Plan

    • Default Plan Example

    • Resource Manager Workflow

    • Specifying Resource Plan Directives

    • Resource Allocation Methods for Resource Plans

     

    Automating Tasks by Using Oracle Scheduler

    • Simplifying Management Tasks

    • Understanding a Simple Job

    • Core Components

    • Basic Work Flow

    • Persistent Lightweight Jobs

    • Using a Time-Based or Event-Based Schedule

    • Creating a Time-Based Job

    • Creating an Event-Based Schedule

     

    Managing Space

    • Space Management Overview

    • Block Space Management

    • Row Chaining and Migration

    • Free Space Management Within Segments

    • Types of Segments

    • Allocating Extents

    • Allocating Space

    • Creating Tables Without Segments

     

    Backup and Recovery Concepts

    • Categories of Failures

    • Flashback Technology

    • Understanding Instance Recovery

    • Phases of Instance Recovery

    • Tuning Instance Recovery

    • Using the MTTR Advisor

    • Media Failure

    • Configuring for Recoverability

     

    Moving Data

    • Moving Data: General Architecture

    • Oracle Data Pump

    • SQL*Loader

    • External Tables

     

    Working with Oracle Support

    • Using the Support Workbench

    • Using Enterprise Manager

    • Working with Oracle Support

    • My Oracle Support Integration

    • Researching an Issue

    • Logging Service Requests

    • Managing Patches

    • Applying a Patch Release

     

    Oracle Database Cloud Service: Overview

    • Database as a Service Architecture, Features and Tooling

    • Software Editions: Included Database Options and Management Packs

    • Automated Database Provisioning

    • Managing the Compute Node Associated With a Database Deployment

    • Enabling Access to a Compute Node Port

    • Scaling a Database Deployment & Patching Database as a Service

    • Using the Oracle Database Cloud Service Console to Manage Patches

    Institución de educación superior sujeta a inspección y vigilancia por el Ministerio de Educación Nacional.
    Importante
    La Universidad podrá cancelar el programa seleccionado, cuando no haya un número mínimo de participantes, y procederá a tramitar la devolución del dinero recibido. También podrá posponer la realización del programa por razones de fuerza mayor. En este caso se informará a las personas preinscritas la nueva fecha programada. El medio de contacto será a través de los medios suministrados en el momento de la inscripción.

    Ir a pagogos en lineaSolictar más informacion

    Próximos Cursos
    Dada la creciente importancia de los resultados de la prueba Saber Pro para las universidades del país en tanto a: los procesos de acreditación; el cálculo de valor agregado o ganancia académica (comparación entre los resultados de Saber 11 y Saber Pro...
    Los proyectos de construcción de software requieren de manera esencial el diseño de arquitecturas de software para su ejecución.
    Próximos Diplomados
    Este programa se ofrece a los médicos buscadores del conocimiento, respuestas, afirmaciones y herramientas, que ayudan a descubrir puentes que unan lo alopático a lo alternativo, a corroborar que las ciencias se complementan, no se polarizan y a buscar...
    Actualmente en Colombia, el cargo de Market Access es el más solicitado a nivel de la industria farmacéutica y no existe en el país ninguna entidad educativa que brinde formación en esta área específica de aprendizaje.
    Próximos Eventos