
Curso de Oracle Database Administration I y II (1Z0-082 Y 1Z0-083)
- Formación VIRTUAL
- Agencia de Colocación Autorizada por el SEPE
- Profesores expertos
- 200 horas
Curso de Oracle Database Administration I y II (1Z0-082 Y 1Z0-083)
- Instalar, parchear y actualizar Oracle Database y Oracle Grid Infrastructure para un servidor independiente
- Crear y administrar una estrategia de respaldo y recuperación usando Recovery Manager (RMAN)
- Aprender a usar RMAN para la duplicación y el transporte de bases de datos
- Diseñar diagnósticos de fallos mediante RMAN y administrar todos los aspectos de las bases de datos de contenedores de múltiples inquilinos.
- Los tipos de bases de datos conectables y sus contenedores de aplicaciones de terceros como la creación, clonación, seguridad, transporte, respaldo y recuperación.
Al finalizar el curso ORACLE DATABASE ADMINISTRATION I Y II estará demostrando que posee el conjunto completo de habilidades necesarias para realizar la administración diaria de la Base de Datos Oracle de cualquier entorno y empresa.
El Grupo Aranda Formación te conecta con el mundo laboral mediante un curso de máxima calidad y amplia salida laboral. Elige la mejor formación en IT y conviértete en un profesional en pocos meses.
¡Tasas de examen incluidas!


Más de 25 años FORMANDO ALUMNOS
Matrícula
ABIERTA 2023/2024
Profesores de Prestigio



SOMOS AGENCIA DE COLOCACIÓN - 9900000468
Nuestro principal objetivo es convertirte en un profesional y ayudarte a encontrar empleo.
titulaciÓN
- Oracle Database Administration I y II (1Z0-071)
Programa
Oracle Database Administration I (1Z0-082)
MODULO I
- Relational Databases: A Brief Introduction
- Creating A Database
- Getting Ready To Create The Database
- Installing The Oracle Software
- Creating The File System For The Database
- Ensuring Sufficient Memory Allocation
- Getting Necessary Authorizations
- Setting The Os Environment Variables
- Creating The Parameter File
- Types Of Database Parameter Files
- The Initialization Parameter File
- Changing The Initialization Parameter Values
- Important Oracle Database 11g Initialization Parameters
- Undocumented Initialization Parameters
- Viewing The Current Initialization Parameter Values
- Práctica Módulo
MODULO II
- Starting Up And Shutting Down The Database From Sql*Plus
- Starting The Database
- Automatically Starting Databases
- Restricting Database Access
- Shutting Down The Database
- Quiescing A Database
- Suspending A Database
- Dropping A Database
- Using The Data Dictionary To Monitor Database Status
- Práctica Módulo
MODULO III
- Connectivity And Networking
- Oracle Networking And Database Connectivity
- Networking Concepts: How Oracle Networking Works
- How A Web Application Connects To Oracle
- Database Instance Names
- Global Database Names
- Database Service Names
- Connect Descriptors
- Connect Identifiers
- Connect String
- Establishing Oracle Connectivity
- The Oracle Client
- Installing The Oracle Client
- Using The Two_Task Environment Variable
- The Instant Client
- Práctica Módulo
MODULO IV
- The Listener And Connectivity
- Automatic Service Registration
- Listener Commands
- Listener Management
- Naming And Connectivity
- The Local Naming Method
- The Easy Connect Naming Method
- Database Resident Connection Pooling
- The External Naming Method
- The Directory Naming Method
- Oracle And Java Database Connectivity
- Establishing Database Connectivity
- Working With The Database
- Práctica Módulo
MODULO V
- Managing Users
- Temporary And Default Tablespaces
- Creating A New User
- Altering A User
- Dropping A User
- Creating And Using User Profiles
- Managing Resources
- The Database Resource Manager
- Using The Database Resource Manager
- Using Oem To Administer The Database Resource Manager
- Práctica Módulo
MODULO VI
- Controlling Database Access
- Privileges In An Oracle Database
- Roles
- Using Views And Stored Procedures To Manage Privileges
- DBA Views For Managing Users, Roles, And Privileges
- Fine-Grained Data Access
- Auditing Database Usage
- Standard Auditing
- Fine-Grained Auditing
- Authenticating Users
- Database Authentication
- External Authentication
- Proxy Authentication
- Centralized User Authorization
- Práctica Módulo
MODULO VII
- Enterprise User Security
- Shared Schemas
- Single Sign-On
- Data Encryption
- Tablespace Encryption
- Oracle Internet Directory
- Database Security Dos And Don’ts
- Automatic Secure Configuration
- User Accounts
- Passwords
- Operating System Authentication
- Database Auditing
- Granting Privileges
- Dealing With Environments With Multiple DBAS
- Protecting The Data Dictionary
- Setting Permissions
- The Network And The Listener
- Fine-Grained Network Access Control
- Oracle’s Advanced Security Option
- Application Security
- Useful Techniques For Managing Users
- Práctica Módulo
MODULO VIII
- Loading And Transforming Data
- An Overview Of Extraction, Transformation, And Loading
- Using The SQL*Loader Utility
- Exploring The SQL*Loader Control File
- Generating Data During The Load
- Invoking SQL*Loader
- Exploring The Loader Log File
- Using Return Codes
- Using The Direct-Path Loading Method
- Some Useful SQL*Loader Data-Loading Techniques
- Práctica Módulo
MODULO IX
- BATERÍA DE PREGUNTAS DEMO EXAMEN (1Z0-082)
Oracle Database Administration II (1Z0-083)
MODULO I
- Using External Tables To Load Data
- Creating The External Table Layer
- Populating External Tables
- Using An External Table
- Using SQL*Loader To Generate External Table
- Creation Statements
- Transforming Data
- Deriving The Data From Existing Tables
- Using SQL To Transform Data
- Using The SQL Model Clause
- Using Oracle Streams For Replication And Information Sharing
- Exploring The Streams Architecture
- Setting Up Oracle Streams
- Práctica Módulo
MODULO II
- Using Data Pump Export And Import
- Introduction To The Data Pump Technology
- Benefits Of The Data Pump Technology
- Uses For Data Pump Export And Import
- Data Pump Components
- Data-Access Methods
- Data Pump Files
- Data Pump Privileges
- The Mechanics Of A Data Pump Job
- Performing Data Pump Exports And Imports
- Data Pump Export Methods
- Data Pump Export Modes
- Data Pump Export Parameters
- Data Pump Export Examples
- Data Pump Import Types And Modes
- Data Pump Import Parameters
- Práctica Módulo
MODULO III
- Monitoring A Data Pump Job
- Viewing Data Pump Jobs
- Viewing Data Pump Sessions
- Viewing Data Pump Job Progress
- Using The Data Pump Api
- Transportable Tablespaces
- Uses For Transportable Tablespaces
- Transporting A Tablespace
- Transporting Tablespaces Across Platforms With Different Formats
- Práctica Modulo
MODULO IV
- Backing Up Oracle Databases.
- Important Backup Terms.
- Backup Guidelines.
- Testing Your Backups.
- Maintaining A Redundancy Set.
- Backup Strategies.
- The Flash Recovery Area.
- Benefits Of The Flash Recovery Area.
- Setting The Size Of The Flash Recovery Area
- Ways To Create A Flash Recovery Area.
- Working With The Flash Recovery Area.
- Práctica Módulo
MODULO V
- Recovery Manager
- Benefits Of Rman
- Rman Architecture
- Connecting To Rman
- Scripting With Rman
- Important Rman Terms
- Specifying Backup Tags And Backup Formats
- Making Copies Of Rman Backups.
- Rman Backup Locations
- Rman Commands.
- Rman Configuration Parameters
- Práctica Módulo
MODULO VI
- Working With The Recovery Catalog
- Maintaining The Recovery Catalog
- Virtual Private Catalogs
- Examples Of Rman Backups
- Restarting An Rman Backup
- Specifying Limits For Backup Duration
- Incrementally Updated Backups
- Fast Incremental Backups
- Rman Compressed Backups
- Archival Backups
- Monitoring And Verifying Rman Jobs
- Backing Up The Control File
- Práctica Módulo
MODULO VII
- Oracle Secure Backup
- Benefits Of Oracle Secure Backup
- Oracle Secure Backup Administrative Domain
- Installing Oracle Secure Backup
- Using The Oracle Backup Web Interface Tool
- Configuring Oracle Secure Backup
- Performing Backups With Oracle Secure Backup
- User-Managed Backups
- Making Whole Database Backups
- Making Partial Database Backups
- Monitoring User-Managed Online Backups
- Database Corruption Detection
- Detecting Media Corruption.
- Detecting Data Block Corruption
- Enhanced Data Protection For Disaster Recovery
- High-Availability Systems
- Oracle Data Guard And Standby Databases.
- Práctica Módulo
MODULO VIII
- Batería De Preguntas Demo Examen (1Z0-083)