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%.
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
    El Programa Avanzado de Negociación es una herramienta que le permitirá poner en práctica un método fiable, contrastado y una rigurosidad.
    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
    El manejo de la información estratégica es de vital importancia para la toma de decisiones a nivel gerencial, por esta razón se requieren herramientas y metodologías que apoyen este proceso.
    Certificación internacional como auditor interno integral ISO 9001, ISO 14001, OHSAS 18001 y Certificación Auditor Norsok.