Curso Completo de Oracle

Educational
profile

Parte 1 - Oracle SQL

Executando SQL Básicos

Funções Básicas

Exibindo dados de varias tabelas

Funções de Grupo

Criando e gerenciando tabelas

Implementando Constraints

Criando Visões e Objetos

Parte 2 - Oracle PL/SQL

Introdução ao PL/SQL

Comandos Escutáveis

Estruturas de Controle

Record e Collections

Cursor Explícito

Tratamento de Exceções

Procedimentos e Funções

Criando Packages e Triggers

Parte 3 - Oracle PL/SQL Avançado

Collections

MERGE

FULL TEXT SEARCH

Triggers de DDL

Pacote UTL_FILE

Manipulado XML

Otimização de Consultas

Criação de Índices

Estatísticas

Views Materializadas

Hints de Pesquisa

Parte 4 - DBA

Arquitetura

Control file e redo log

Tablespaces e datafiles

Segmentos de undo/temp

Usuários e privilégios

Recovery backup e processos

Modo archiving

Recovery completo e incompleto

Export e import

Recovery manager

Catálogo de recovery

Backups físicos, restore e recovery

Flashback

15-day warranty

Safe payments

Frequently Asked Questions

I can see this page is a Hotmart Public Profile. What is this?

Hotmart Public Profile is a promotional channel for Producers and digital products sold through Hotmart. These products are online courses, ebooks, video lesson series, among others. The objective of the Public Profile is to help you learn more about the content and specificities of the product, helping you in your purchasing decision. This means that the images, texts, comments, and achievements shown on this page are truly representative of theses products’ content. If you don’t agree with something being displayed, please contact us using this channel