Tools
Register Login

TREINAMENTO DE TI

SOMENTE TURMAS PRIVADAS - Academia SAP, Treinamentos ORACLE, GP & ITIL

You are here: INICIAL » Oracle Database 11g: Administration Workshop I DBA Release 2
Sábado, 16 Dez 2017

Oracle Database 11g: Administration Workshop I DBA Release 2

E-mail Imprimir PDF


Este curso é o primeiro passo para o sucesso como um profissional Oracle,desenhado para lhe dar uma base sólida em administração de banco de dados de base. Neste curso, você aprenderá a instalar e manter um banco de dados Oracle.Você obterá uma compreensão conceitual da arquitetura do banco de dados Oracle e como seus componentes trabalham e interagem uns com os outros. Você também vaiaprender como criar um banco de dados operacional e gerenciar adequadamente asdiversas estruturas de uma forma eficaz e eficiente incluindo monitoramento de desempenho, segurança de banco de dados, gerenciamento de usuários e técnicas de backup / recovery. Os tópicos da lição são reforçados com práticas estruturadassobre as práticas. Este curso está desenhado para se preparar para o exame Oracle Certified Associate.

O curso não abrange as seguintes tecnologias-chave da grade:
(1) Enterprise Manager Grid Control
(2) Real Application Clusters
(3) Streams
(4) Data Guard.

Estas tecnologias são abordadas os seguintes cursos:
(1) do Oracle Enterprise Manager 11g Grid Control
(2) Oracle Database 11g: Administração de RAC
(3) Oracle Database 11g: Implementar Streams
(4) Oracle Database 11g: Administração de Dados da Guarda

Aprenda a:
Instalar infra-estrutura Oracle Grid
Criar e gerenciar usuários
Instalar e configurar o banco de dados Oracle
Criar e gerenciar estruturas de armazenamento
Administrar o banco de dados Oracle
Backup e Recuperação


Público:

·         Administrador de Banco de Dados

·         Consultor Técnico

·         Desenvolvedor em Java

Pré-requisitos:

Pré-requisitos Obrigatórios:

·         Taken Oracle Introduction to SQL course or equivalent experience

·         Oracle Database: Introduction to SQL

Pré-requisitos Recomendados:

·         Taken Oracle PL/SQL course or equivalent experience

·         Oracle Database: PL/SQL Fundamentals

Objetivos do Curso:

·         Monitor performance

·         Describe Oracle Database Architecture

·         Install Oracle Grid Infrastructure

·         Install and configure Oracle Database 11g

·         Configure Oracle Net services

·         Monitor and administer undo data

·         Manage the database storage structures

·         Create and administer user accounts

·         Perform basic backup and recovery of a database

·         Manage data concurrency

Tópicos do Curso:

Exploring the Oracle Database Architecture

·         Oracle Database Architecture Overview

·         Oracle ASM Architecture Overview

·         Process Architecture

·         Memory structrues

·         Logical and physical storage structures

·         ASM storage components

Installing your Oracle Software

·         Tasks of an Oracle Database Administrator

·         Tools Used to Administer an Oracle Database

·         Installation: System Requirements

·         Oracle Universal Installer (OUI)

·         Installing Oracle Grid Infrastructure

·         Installing Oracle Database Software

·         Silent Install

Creating an Oracle Database

·         Planning the Database

·         Using the DBCA to Create a Database

·         Password Management

·         Creating a Database Design Template

·         Using the DBCA to Delete a Database

Managing the Oracle Database Instance

·         Start and stop the Oracle database and components

·         Use Oracle Enterprise Manager

·         Access a database with SQLPlus

·         Modify database installation parameters

·         Describe the stages of database startup

·         Describe database shutdown options

·         View the alert log

·         Access dynamic performance views

Manage the ASM Instance

·         Set up initialization parameter files for ASM instance

·         Start up and shut down ASM instances

·         Administer ASM disk groups

Configuring the Oracle Network Environment

·         Use Enterprise Manager to create and configure the Listener

·         Enable Oracle Restart to monitor the listener

·         Use tnsping to test Oracle Net connectivity

·         Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures

·         Storage Structures

·         How Table Data Is Stored

·         Anatomy of a Database Block

·         Space Management in Tablespaces

·         Tablespaces in the Preconfigured Database

·         Actions with Tablespaces

·         Oracle Managed Files (OMF)

Administering User Security

·         Database User Accounts

·         Predefined Administrative Accounts

·         Benefits of Roles

·         Predefined Roles

·         Implementing Profiles

Managing Data Concurrency

·         Data Concurrency

·         Enqueue Mechanism

·         Resolving Lock Conflicts

·         Deadlocks

Managing Undo Data

·         Data Manipulation

·         Transactions and Undo Data

·         Undo Data Versus Redo Data

·         Configuring Undo Retention

Implementing Oracle Database Auditing

·         Describe DBA responsibilities for security

·         Enable standard database auditing

·         Specify audit options

·         Review audit information

·         Maintain the audit trail

Database Maintenance

·         Manage optimizer statistics

·         Manage the Automatic Workload Repository (AWR)

·         Use the Automatic Database Diagnostic Monitor (ADDM)

·         Describe and use the advisory framework

·         Set alert thresholds

·         Use server-generated alerts

·         Use automated tasks

Performance Management

·         Performance Monitoring

·         Managing Memory Components

·         Enabling Automatic Memory Management (AMM)

·         Automatic Shared Memory Advisor

·         Using Memory Advisors

·         Dynamic Performance Statistics

·         Troubleshooting and Tuning Views

·         Invalid and Unusable Objects

Backup and Recovery Concepts

·         Part of Your Job

·         Statement Failure

·         User Error

·         Understanding Instance Recovery

·         Phases of Instance Recovery

·         Using the MTTR Advisor

·         Media Failure

·         Archive Log Files

Performing Database Backups

·         Backup Solutions: Overview

·         Oracle Secure Backup

·         User-Managed Backup

·         Terminology

·         Recovery Manager (RMAN)

·         Configuring Backup Settings

·         Backing Up the Control File to a Trace File

·         Monitoring the Flash Recovery Area

Performing Database Recovery

·         Opening a Database

·         Data Recovery Advisor

·         Loss of a Control File

·         Loss of a Redo Log File

·         Data Recovery Advisor

·         Data Failures

·         Listing Data Failures

·         Data Recovery Advisor Views

Moving Data

·         Describe ways to move data

·         Create and use directory objects

·         Use SQL*Loader to move data

·         Use external tables to move data

·         General architecture of Oracle Data Pump

·         Use Data Pump export and import to move data

Working with Support

·         Use the Enterprise Manager Support Workbench

·         Work with Oracle Support

·         Log service requests (SR)

·         Manage patches



DURAÇÃO: 05 DIAS

LiveZilla Live Help

LiveZilla Live Help