Pergunta 1: Para quem é o produto?
Resposta 1: O produto é voltado para pessoas que desejam se tornar DBAs Oracle Junior e obter a certificação Oracle Database 19c OCP.

Pergunta 2: O que será aprendido com o produto?
Resposta 2: O curso abrange teoria e prática de todos os tópicos da certificação OCP de um DBA Oracle 19c, além de ensinar atividades práticas do dia a dia de um DBA Oracle em uma empresa.

Pergunta 3: Qual é o objetivo do curso?
Resposta 3: O objetivo do curso é ajudar na formação de novos DBAs Oracle, proporcionando o diferencial de mercado necessário para ter sucesso e conquistar um espaço privilegiado nesse mercado.

Felipe Alves

01.1.3 - Trilha DBA Oracle Junior: Formação DBA Oracle (Certificação OCP19c provas 1Z0-082 e 1Z0-083)

Aula 01 - Como começar 

Modulo 0 - COMECE POR AQUI

Boas Vindas e Apresentação

Modulo 1 - Introdução

Aula 2.1: Minhas certificações

Aula 2.2: Minha experiência com certificações

Aula 2.3: Trilha de certificação Oracle database 19c

Aula 2.4: Como comprar e agendar a prova

Aula 2.5: Formato da prova

Modulo 2 - Dicas sobre a Certificação

Aula 3.1.1: Instalação Oracle Linux 7

Aula 3.1.2: Instalação Oracle Linux 8

Aula 3.2.1: Instalação SGDB Oracle 19c Sem Interface Gráfica - Modo Silent

Aula 3.2.2: Instalação SGDB Oracle 19c Com Interface Gráfica

Aula 3.2.3: Instalação SGDB Oracle 19c com GRID StandAlone

Aula 3.2.4: Instalação SGDB Oracle 19c Sem Interface Gráfica - Pacote RPM

Aula 3.2.4: Variáveis de Ambiente

Modulo 3 - Instalação S.O e SGBD

Aula 4.0.1: Apresentação do Ambiente 

Aula 4.0.2: Preciso aprender Linux?

Aula 4.1.1: Understanding Oracle Database Architecture - Instance Configurations

Aula 4.1.2: Understanding Oracle Database Architecture - Memory

Aula 4.1.2: Understanding Oracle Database Architecture - Process Structures

Aula 4.1.3: Understanding Oracle Database Architecture - Logical and Physical Database Structures

Aula 4.1.4: Understanding Oracle Database Architecture - Server Architecture

Aula 4.2.1: Managing Database Instances - Starting Up Oracle Database Instances

Aula 4.2.2: Managing Database Instances - Using Data Dictionary Views

Aula 4.2.3: Managing Database Instances - Shutting Down Oracle Database Instances

Aula 4.2.4: Managing Database Instances - Using Dynamic Performance Views

Aula 4.2.5: Managing Database Instances - Using the Automatic Diagnostic Repository (ADR)

Aula 4.2.6: Managing Database Instances - Using the Alert Log and Trace Files

Aula 4.2.7: Managing Database Instances - Managing Initialization Parameter Files

Aula 4.3.1: Managing Users, Roles and Privileges - Managing Oracle Database Users, Privileges, and Roles

Aula 4.3.2: Managing Users, Roles and Privileges - Applying the Principal of Least Privilege

Aula 4.3.3: Managing Users, Roles and Privileges - Administering User Authentication Methods

Aula 4.3.4: Managing Users, Roles and Privileges - Assigning Quotas to Users

Aula 4.3.5: Managing Users, Roles and Privileges - Creating and Assigning Profiles

Aula 4.4.1: Managing Storage - Understanding Block Space Management

Aula 4.4.2: Managing Storage - Managing Different Types of Segments

Aula 4.4.3: Managing Storage - Deferring Segment Creation

Aula 4.4.4: Managing Storage - Using Table and Row Compression

Aula 4.4.5: Managing Storage - Shrinking Segments

Aula 4.4.6: Managing Storage - Managing Resumable Space Allocation

Aula 4.4.7: Managing Storage - Using Space-Saving Features

Aula 4.4.8: Managing Storage - Deploying Oracle Database Space Management Features	

Aula 4.5.1: Moving Data - Using Oracle Data Pump

Aula 4.5.2: Moving Data - Using SQL*Loader

Aula 4.5.3: Moving Data - Using External Tables

Aula 4.6.1: Accessing an Oracle Database with Oracle supplied Tools - Using the DBCA

Aula 4.6.2: Accessing an Oracle Database with Oracle supplied Tools - Using SQL Plus

Aula 4.6.3: Accessing an Oracle Database with Oracle supplied Tools - Using SQL Developer

Aula 4.6.4: Accessing an Oracle Database with Oracle supplied Tools - Using Oracle EM Database Express

Aula 4.6.5: Accessing an Oracle Database with Oracle supplied Tools - Using Oracle EMCC

Aula 4.7.1: Configuring Oracle Net Services - Connecting to an Oracle Database Instance

Aula 4.7.2: Configuring Oracle Net Services - Configuring the Oracle Net Listener

Aula 4.7.3: Configuring Oracle Net Services - Administering Naming Methods

Aula 4.7.4: Configuring Oracle Net Services - Using Oracle Net Services Administration Tools

Aula 4.7.5: Configuring Oracle Net Services - Comparing Dedicated and Shared Server Configurations

Aula 4.7.6: Configuring Oracle Net Services - Configuring Communication Between Database Instances

Aula 4.8.1: Managing Tablespaces and Datafiles - Viewing Tablespace Information

Aula 4.8.2: Managing Tablespaces and Datafiles - Creating, Altering and Dropping Tablespaces

Aula 4.8.3: Managing Tablespaces and Datafiles - Managing Table Data Storage

Aula 4.8.4: Managing Tablespaces and Datafiles - Implementing Oracle Managed Files

Aula 4.8.5: Managing Tablespaces and Datafiles - Moving and Renaming Online Data Files

Aula 4.9.1: Managing Undo - Understanding Transactions and Undo Data

Aula 4.9.2: Managing Undo - Storing Undo Information

Aula 4.9.3: Managing Undo - Configuring Undo Rentention

Aula 4.9.4: Managing Undo - Comparing Undo Data and Redo Data

Aula 4.9.5: Managing Undo - Understanding Temporary Undo

Aula 4.10.1: - Introduction to SQL 

Modulo 4 - Administração | (exam_1Z0-082)

Aula 5.0.1: Multitenant Architecture

Aula 5.1.1: Creating CDBs and Regular PDBs - Configure and create a CDB

Aula 5.1.2: Creating CDBs and Regular PDBs - Create a new PDB from the CDB seed

Aula 5.1.3: Creating CDBs and Regular PDBs - Explore the structure of PDBs

Aula 5.2.1: Manage CDBs and PDBs - Manage PDB service names and connections

Aula 5.2.2: Manage CDBs and PDBs - Manage startup, shutdown and availability of CDBs and PDBs

Aula 5.2.3: Manage CDBs and PDBs - Change the different modes and settings of PDBs

Aula 5.2.4: Manage CDBs and PDBs - Evaluate the impact of parameter value changes

Aula 5.2.5: Manage CDBs and PDBs - Performance management in CDBs and PDBs

Aula 5.2.6: Manage CDBs and PDBs - Control CDB and PDB resource usage with the Oracle Resource Manager

Aula 5.3.1: Backup and Duplicate - Perform Backup and Recover CDBs and PDBs

Aula 5.3.2: Backup and Duplicate - Duplicate an active PDB

Aula 5.3.3: Backup and Duplicate - Duplicate a Database

Aula 5.4.1: Upgrading and Transporting CDBs and Regular PDBs - Upgrade an Oracle Database

Aula 5.4.2: Upgrading and Transporting CDBs and Regular PDBs - Transport Data

Aula 5.5.1: Manage Application PDBs - Explain the purpose of application root and application seed

Aula 5.5.2: Manage Application PDBs - Define and create application PDBs

Aula 5.5.3: Manage Application PDBs - Install, upgrade and Patch applications

Aula 5.5.4: Manage Application PDBs - Create and administer Application PDBs

Aula 5.5.5: Manage Application PDBs - Clone PDBs and Application containers

Aula 5.5.6: Manage Application PDBs - Plug and unplug operations with PDBs and application containers

Aula 5.5.7: Manage Application PDBs - Comparing Local Undo Mode and Shared Undo Mode

Aula 5.6.1: Manage Security in Multitenant databases - Manage Security in Multitenant databases

Aula 5.6.2: Manage Security in Multitenant databases - Manage PDB lockdown profiles

Aula 5.6.3: Manage Security in Multitenant databases - Audit Users in CDBs and PDBs

Aula 5.6.4: Manage Security in Multitenant databases - Manage other types of policies in application containers

Aula 5.7.1: Recovery and Flashback - Restore and Recovering Databases with RMAN

Aula 5.7.2: Recovery and Flashback - Perform CDB and PDB flashback

Aula 5.8.1: Backup Strategies and Terminology - Perform Full and Incremental Backups and Recoveries

Aula 5.8.2: Backup Strategies and Terminology - Compress and Encrypt RMAN Backups

Aula 5.8.3: Backup Strategies and Terminology - Use a media manager

Aula 5.8.4: Backup Strategies and Terminology - Create multi-section backups of very large files

Aula 5.8.5: Backup Strategies and Terminology - Create duplexed backup sets

Aula 5.8.6: Backup Strategies and Terminology - Create archival backups

Aula 5.8.7: Backup Strategies and Terminology - Backup of recovery files

Aula 5.8.8: Backup Strategies and Terminology - Backup non database files

Aula 5.8.9: Backup Strategies and Terminology - Backup ASM meta data

Aula 5.9.1: Restore and Recovery Concepts - Employ the best Oracle Database recovery technology for your failure situation

Aula 5.9.2: Restore and Recovery Concepts - Describe and use Recovery technology for Crash, Complete, and PITR

Aula 5.10.1: Using Flashback Technologies - Configure your Database to support Flashback

Aula 5.10.2: Using Flashback Technologies - Perform flashback operations

Aula 5.11.1: Duplicating a Database - Duplicate Databases

Aula 5.12.1: Configuring and Using RMAN - Configure RMAN and the Database for Recoverability

Aula 5.12.2: Configuring and Using RMAN - Configureand Using an RMAN recovery catalog

Aula 5.13.1: Diagnosing Failures - Detect and repair database and database block corruption

Aula 5.13.2: Diagnosing Failures - Diagnosing Database Issues

Aula 5.14.1: Performing Recovery - Restore and Recovering Databases with RMAN

Aula 5.14.2: Performing Recovery - Perform Non RMAN database recovery

Aula 5.15.1: Transporting Data - Transport Data

Aula 5.16.1: RMAN Troubleshooting and Tuning - Interpret the RMAN message output

Aula 5.16.2: RMAN Troubleshooting and Tuning - Diagnose RMAN performance issues

Aula 5.17.1: Install Grid Infrastructure and Oracle Database - Install Grid Infrastructure for a Standalone server

Aula 5.17.2: Install Grid Infrastructure and Oracle Database - Install Oracle Database software

Aula 5.18.1: Patching Grid Infrastructure and Oracle Database - Patch Grid Infrastructure and Oracle Database

Aula 5.19.1: Upgrading to Oracle Grid Infrastructure - Upgrade Oracle Grid Infrastructure

Aula 5.20.1: Oracle Database 18c: New Features - Image and RPM based Database Installation

Aula 5.21.1: Creating an Oracle Database by using DBCA - Create, Delete and Configure Databases using DBCA

Aula 5.22.1: Oracle Restart - Configure and use Oracle Restart to manage components

Aula 5.23.1: Upgrade the Oracle Database - Plan for Upgrading an Oracle Database

Aula 5.23.2: Upgrade the Oracle Database - Upgrade an Oracle Database

Aula 5.23.3: Upgrade the Oracle Database - Perform Post-Upgrade tasks

Aula 5.24.1: Install Grid Infrastructure for a Standalone server - Rapid Home Provisioning

Aula 5.25.1: Using General Overall Database Enhancements - Install Oracle Database software

Aula 5.25.2: Using General Overall Database Enhancements - Create, Delete and Configure Databases using DBCA

Aula 5.25.3: Using General Overall Database Enhancements - Creating CDBs and Regular PDBs

Aula 5.25.4: Using General Overall Database Enhancements - Use Miscellaneaous 19c New Features

Aula 5.26.1: Using Availability Enhancements - Use an RMAN recovery catalog

Aula 5.26.2: Using Availability Enhancements - Use Flashback Database

Aula 5.27.1: Using Diagnosibility Enhancements - Use new Diagnoseability Features

Aula 5.28.1: Monitoring and Tuning Database Performance - Managing Memory Components

Aula 5.28.2: Monitoring and Tuning Database Performance - Understanding The Automatic Workload Repository (AWR)

Aula 5.28.3: Monitoring and Tuning Database Performance - Understanding The Advisory Framework

Aula 5.28.4: Monitoring and Tuning Database Performance - Monitoring Wait Events, Sessions, and Services

Aula 5.28.5: Monitoring and Tuning Database Performance - Managing Metric Thresholds and Alerts

Aula 5.28.6: Monitoring and Tuning Database Performance - Understanding and Using The Performance Tuning Methodology

Aula 5.28.7: Monitoring and Tuning Database Performance - Performing Performance Planning

Aula 5.28.8: Monitoring and Tuning Database Performance - Understanding The Automatic Database Diagnostic Monitor (ADDM)

Aula 5.29.1: Tuning SQL Statements - Understanding The Oracle Optimizer

Aula 5.29.2: Tuning SQL Statements - Using The SQL Tuning Advisor

Aula 5.29.3: Tuning SQL Statements - Managing Optimizer Statistics

Aula 5.29.4: Tuning SQL Statements - Using The SQL Access Advisor

Aula 5.29.5: Tuning SQL Statements - Understanding The SQL Tuning Process

Modulo 5 - Administração || (exam_1Z0-083)

00 - Vídeos do Youtube

01 - Gerar Trace para sessão

02 - Gerenciando Arquivo de parâmetros e parâmetros 

03 - Gerenciando Usuários Privilégios e Roles

04 - Gerando DDL de Usuários 

05 - Gerenciando ACLs

06 - Gerenciando Password File 

07 - Gerenciando Profiles

08 - Configurando e Gerenciando compressão 

09 - Executando Shrink de Tabelas 

10 - Executando e Analisando o Segmento Advisor 

11 - Gerenciando o Oracle Data Pump (Parte 1 - Introdução)

11 - Gerenciando o Oracle Data Pump (Parte 2 - Export)

11 - Gerenciando o Oracle Data Pump (Parte 3 - Import)

11 - Gerenciando o Oracle Data Pump (Parte 4 - NetwotkLink)

11 - Gerenciando o Oracle Data Pump (Parte 4 - Parfile)

11 - Gerenciando o Oracle Data Pump (Parte 4 - Sqlfile)

11 - Gerenciando o Oracle Data Pump (Parte 5 - Backup)

11 - Gerenciando o Oracle Data Pump (Parte 6 - Cenários)

12 - Usando o SQL*Loader

13 - Usando External Tables

14 - Usando o SQLplus

15 - Instalando o Oracle Client 

16 - Usando o SQLDeveloper

Adicional - Administração | (exam_1Z0-082)

01 - Criando banco de dados Multitenant (CDB e PDB)

02 - Criando PDBs dentro de um CDB 

03 - Clonando um PDB entre CDBs	

04 - Duplicate Database

05 - Movimentando PDBs entre CDBs (Plug e unplug)

06 - Gerenciando o Application Container (Parte 1)

06 - Gerenciando o Application Container (Parte 2)

06 - Gerenciando o Application Container (Parte 3)

07 - Flashback Database (Flashback Query)

07 - Flashback Database (Flashback Version Query)

07 - Flashback Database (Flashback Transaction Query)

07 - Flashback Database (Flashback Transaction Backout)

07 - Flashback Database (Flashback Table)

07 - Flashback Database (Flashback Drop)

07 - Flashback Database (Flashback Database)

07 - Flashback Database (Flashback Data Archive)

09 - Backup e Recover com RMAN - Backup (Archivelog mode)

09 - Backup e Recover com RMAN - Backup (Como se conectar no RMAN)

09 - Backup e Recover com RMAN - Backup (Configuração RMAN)

Adicional - Administração || (exam_1Z0-083)

01.1.3 - Trilha DBA Oracle Junior: Formação DBA Oracle (Certificação OCP19c provas 1Z0-082 e 1Z0-083)

Perguntas Frequentes

Comece na Hotmart gratuitamente

Poucos passos, muitas possibilidades