1. Acesso a um treinamento completo: o Oracle Database Básico ao Avançado oferece um conteúdo completo para quem deseja se tornar um expert em Banco de dados Oracle e tirar a certificação de OCP 19.

2. Material complementar: além das videoaulas, o treinamento disponibiliza um material complementar para que você possa aprofundar seus conhecimentos sobre o Banco de dados Oracle.

3. Preparação para a certificação em 3 meses: o objetivo do treinamento é deixar você preparado para tirar a certificação de OCP em apenas 3 meses, o que é uma vantagem para quem deseja se destacar no mercado de trabalho.

4. Diversidade de temas: o treinamento aborda temas como Administration Workshop, Introduction to SQL, Managing Multitenant Architecture, Backup and Recovery Workshop, Deploy, Patch and Upgrade Workshop e Oracle Database 19c New Features, o que garante uma formação completa e atualizada sobre o Banco de dados Oracle.

Pergunta 1: Para quem é o produto?

Resposta 1: O produto é destinado a pessoas que desejam se tornar especialistas em Banco de dados Oracle e obter a Certificação de OCP 19.

Pergunta 2: O que será aprendido com o produto?

Resposta 2: O produto abrange diversos tópicos, como Administração, Introdução ao SQL, Gerenciamento de Arquitetura Multitenant, Backup e Recuperação, Implantação, Atualização e Recursos Novos do Oracle Database 19c.

Pergunta 3: Qual é o objetivo do produto?

Resposta 3: O objetivo do produto é preparar o aluno para obter a certificação de OCP em Banco de dados Oracle em um período de 3 meses, fornecendo videoaulas e material complementar para aprofundamento no assunto.

DBAOCM

Oracle Database Básico ao Avançado

Comece aqui

Comunidade DBAOCM

Telegram

Programa de Afiliados

Boas Vindas

Como criar um laboratório para OCP do zero gratuitamente na Oracle Cloud

Como instalar o Oracle Database 19c do Zero no VirtualBox

Understanding Oracle Database Server Architecture

Understanding Oracle Database Instance Configurations

Understanding Process Structures

Understanding Oracle Database Memory

Managing Control File

Managing Redo Log

Managing Undo Tablespace

Data Dictionary and Dynamic Performance Views

Using the Automatic Diagnostic Repository (ADR)

Managing SPFILE (Server Parameter File)

Viewing Tablespace Information / Implementing Oracle Managed Files

Managing Users

Managing Roles

Configuring Privilege and Role Authorization

Managing Users, Roles and Privileges - hands on

Managing Resumable Space Allocation

Reclaiming Unused Space

Understanding Block Space Management

Using External Tables

Using Table and Row Compression

External tables ORACLE_DATAPUMP Access Driver

Using Oracle Data Pump

Oracle Data Pump Network_Link

Datapump Parallel and Compression

Using SQL*Loader

Understanding Oracle Net Architecture

Configuring Oracle Net Services

Quick Start to Oracle Net Services

Managing Oracle Net Services

Configuring Communication Between Database Instances

Comparing Dedicated and Shared Server Configurations

CMAN - Connection Manager

Creating Tablespaces

Altering and Dropping Tablespaces / Managing Table Data Storage

Moving and Renaming Online Data Files

Explorando o Oracle SQL Developer

Enterprise Manager Express

Automatic Startup - dbstart

Redefining Tables Online

Introduction to Auditing

Profile

purgeLogs tool

ORAchk

DBMS_SCHEDULER

Certificado - Bootcamp Oracle Database Administration

1z0-082 - Administration Workshop

Installing Sample Schemas

Restricting and Sorting Data

Using Conversion Functions and Conditional Expressions

Displaying Data from Multiple Tables Using Joins

Using SET Operators

Understanding Data Definition Language

Managing Views

Managing Data in Different Time Zones

Using Column aliases / DESCRIBE command / SQL SELECT statement

Using concatenation operator, literal character strings, alternative quote operator

Using Arithmetic expressions and NULL values in the SELECT statement

Managing Indexes / Managing Synonyms / Managing Sequences

Reporting Aggregated Data Using Group Functions

Managing Tables using DML statements

Managing Schema Objects

Using Subqueries to Solve Queries

Using Single-Row Functions to Customize Output

Introduction to Schema Objects

Certificado - Bootcamp Oracle Introduction to SQL

Retrieving Data using the SQL SELECT Statement

1z0-082 - Introduction to SQL

Creating CDBs and Regular PDBs

Manage PDB service names and connections

Manage startup, shutdown and availability of CDBs and PDBs

Evaluate the impact of parameter value changes / Performance management in CDBs and PDBs

Performance management in CDBs and PDBs

Control CDB and PDB resource usage with the Oracle Resource Manager

Change the different modes and settings of PDBs

Backup and Duplicate in a CDB

Explain the purpose of application root and application seed

Define and create application PDBs

Install, upgrade and Patch applications

Create and administer Application PDBS

Clone PDBs and Application containers

Plug and unplug operations with PDBs and application containers

Comparing Local Undo Mode and Shared Undo Mode

Restore and Recovering Databases with RMAN

Perform CDB and PDB flashback

Manage security in Multitenant databases

Manage PDB lockdown profiles

Application contexts and Oracle Virtual Private Database

Audit Users in CDBs and PDBs

Complete Recovery Pluggable Database

Pluggable Database Refresh

Como criar um novo service name para um PDB

PDBs With Different Time Zones to the CDB

Application Common Objects

PDB Snapshot Carousel

Migrate a Non-Container Database to PDB - Clone Remote Non-CDB

Flashback Pluggable Database Shared Undo

PDB's com character sets diferentes

Duplicate Pluggable Database (PDB)

Multitenant - Dynamic CPU Scaling

Creating Proxy PDB

Rename PDB

Certificado - Bootcamp Oracle Multitenant Architecture

Upgrading and Transporting CDB’s and Regular PDB’s

1z0-083 - Managing Multitenant Architecture

Perform Full and Incremental Backups and Recoveries

Modo Archivelog

Compress and Encrypt RMAN Backups

Use a media manager

Create multi-section backups of very large files / Create duplexed backup sets

Backup of recovery files / Create archival backups

Restore and Recovery Concepts

Using Flashback Technologies

Duplicating a Database

Diagnosing Failures

Transporting Data

Configuring and Using RMAN

Performing Recovery

Restore Parcial Oracle Database

RMAN Database Restore from ASM to File System

Table Point In Time Recovery (PITR)

Tuning RMAN Performance

Database Point In Time Recovery

Backup RMAN To Object Storage

Recuperando um Banco de Dados do Object Storage

Using Logminer

Backup non database files and Backup ASM metadata

RMAN Recovery Catalog

Virtual Private Catalog

Recover Database Until Available Redo

Responda Esse Formulário

Certificado - Backup and Recovery 

1z0-083 - Backup and Recovery Workshop

Install Grid Infrastructure for a Standalone server - Parte 1

Install Grid Infrastructure for a Standalone server - Parte 2

Install Oracle Database software

RPM based Database Installation

Rapid Home Provisioning

Patching Grid Infrastructure and Oracle Database

Upgrading to Oracle Grid Infrastructure

Upgrade the Oracle Database

Creating an Oracle Database by using DBCA

Manual Upgrade Oracle Database 19c

ASM – Automatic Storage Management

Criando um ASM Cluster File System (ACFS)

Upgrading PDB using Unplug and Plug

Oracle Database 19c Installation On Oracle Linux 8 (OL8)

Migration Oracle Database 11g to 19c (PDB) using Full Transportable Tablespaces

Oracle Optimal Flexible Architecture (OFA)

Autoupgrade 19c

Convert character set database using Oracle Database Migration Assistant for Unicode(DMU)

Certificado - Bootcamp Oracle Deploy, Patch and Upgrade

1z0-083 - Deploy, Patch and Upgrade

Using Availability Enhancements

Using Diagnosibility Enhancements

Using Security Enhancements

Using General Overall Database Enhancements

New Feature 19c - Listener Log Rotation

Cloning a Remote PDB

Relocating a Remote PDB

DataPump - Test Mode For Transportable Tablespaces

New Feature 19c - Listagg Distinct

ADDM Support for Pluggable Databases (PDBs)

Certificado - Bootcamp New Features Oracle Database 19c

1z0-083 - Oracle Database 19c: New Features for Administrators

Performance Tuning Methodology

Using Log and Trace Files to Monitor Performance

Understanding Oracle Automatic Workload Repository - AWR

Hands on AWR

Statspack

Understanding The Advisory Framework

Monitoring Wait Events, Sessions, and Services

Oracle Wait Events

Managing Metric Thresholds and Alerts

Understanding The Automatic Database Diagnostic Monitor (ADDM)

Como configurar o Huge pages para o Oracle Database

Optimizer Statistics Concepts

Managing Memory Components

Using Force Full Database Caching Mode

Using SQL Tuning Advisor

Managing Resources with Oracle Database Resource Manager

Monitoring Applications

Tuning the Program Global Area (PGA)

Utilização do Oratop Oracle (MOS 1500864.1)

Overview of Oracle Database Transaction Isolation Levels

Overview of the Oracle Database Locking Mechanism

Oracle Trace File Analyzer(TFA)

Tuning Redolog

SQL Health Check - SQLHC

Oracle Database In-Memory

Certificado - Bootcamp Oracle Performance Tuning

1z0-083 - Performance Management and Tuning

Oracle Database Básico ao Avançado

Avaliações

Perguntas Frequentes