Curso de Oracle Database Administration I y II (1Z0-082 Y 1Z0-083)

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)