Oracle Database 11g: Administration Workshop I (Manhã)

Carga Horária: 42 horas

 

 

Frequência: terças e quintas-feiras.

 

 

Objetivos:

Este curso apresenta uma visão da arquitetura de um Banco de Dados Oracle e como seus componentes funcionam, a criação de bancos de dados e o gerenciamento de suas suas várias facetas, incluindo monitoramento de desempenho, segurança, gerenciamento de usuários, backup e restore.

 

 

Descrição:

Este curso ensina a instalar o banco de dados Oracle 11g, a configurar um banco de dados, a gerenciar as instâncias Oracle e as estruturas de armazenamento de bancos de dados, a criar e administrar contas de usuário, a realizar cópia e recuperação de banco de dados, a monitorar problemas, a manter um banco de dados, a configurar serviços Oracle Net e a mover dados entre bancos de dados e arquivos.

 

 

Conteúdo Programático:

 

Introduction (Database Architecture)

•  
• Describe course objectives
• Explore the Oracle 11g database architecture

Installing the Oracle Database Software

 

• Explain core DBA tasks and tools
• Plan an Oracle installation
• Use optimal flexible architecture
• Install software with the Oracle Universal Installer (OUI)

Creating an Oracle Database

 

• Create a database with the Database Configuration Assistant (DBCA)
• Create a database design template with the DBCA
• Generate database creation scripts with the DBCA

Managing the Oracle Instance

 

• Start and stop the Oracle database and components
• Use Enterprise Manager (EM)
• Access a database with SQL*Plus and iSQL*Plus
• Modify database initialization parameters
• Understand the stages of database startup
• View the Alert log
• Use the Data Dictionary

Managing Database Storage Structures

 

• Describe table data storage (in blocks)
• Define the purpose of tablespaces and data files
• Understand and utilize Oracle Managed Files (OMF)
• Create and manage tablespaces
• Obtain tablespace information
• Describe the main concepts and functionality of Automatic Storage Management (ASM)

Administering User Security

 

• Create and manage database user accounts
• Authenticate users
• Assign default storage areas (tablespaces)
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
• Implement standard password security features
• Control resource usage by users

Managing Schema Objects

 

• Define schema objects and data types
• Create and modify tables
• Define constraints
• View the columns and contents of a table
• Create indexes, views and sequences
• Explain the use of temporary tables
• Use the Data Dictionary

Managing Data and Concurrency

 

• Manage data through SQL
• Identify and administer PL/SQL Objects
• Describe triggers and triggering events
• Monitor and resolve locking conflicts

Managing Undo Data

 

• Explain DML and undo data generation
• Monitor and administer undo
• Describe the difference between undo and redo data
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor

Implementing Oracle DatabaseSecurity

 

• Describe DBA responsibilities for security
• Apply the principal of least privilege
• Enable standard database auditing
• Specify audit options
• Review audit information
• Maintain the audit trail

Configuring the Oracle Network Environment

 

• Use Enterprise Manager for configuring the Oracle network environment
• Create additional listeners
• Create Net Service aliases
• Configure connect-time failover
• Control the Oracle Net Listener
• Test Oracle Net connectivity
• Identify when to use shared versus dedicated servers

Proactive Maintenance

 

• Use statistics
• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe advisory framework
• Set alert thresholds
• Use server-generated alerts
• Use automated tasks

Performance Management

 

• Use Enterprise Manager pages to monitor performance
• Use the SQL Tuning Advisor
• Use the SQL Access Advisor
• Use Automatic Shared Memory Management
• Use the Memory Advisor to size memory buffers
• Use performance related dynamic views
• Troubleshoot invalid or unusable objects

Backup and Recovery Concepts

 

• Identify the typ