Oracle DBA Online Training Call : +91 9441233734
ORACLE DBA ONLINE TRAINING
PRE-REQUISITES: SQL, PL/SQL,LINUX
DURATION: 45HRS.
INTRODUCTION TO ORACLE
- Exploring the Oracle Database Architecture
- Creating an Oracle Database
- Managing the Database Instance
- Managing Database Storage Structures (Table spaces & Segments)
- Administering User Security
- Managing Data Concurrency
- Managing Undo Data
- Configuring the Oracle Network Environment
- Backup and Recovery Concepts (cold, hot & RMAN)
- Use of RMAN Recovery Catalog & Configuring Backup Settings
- Performing Database Backups with RMAN
- Performing Database Recovery
- Moving Data - Export & Import, External Tables & SQL Loader
- Using Flashback Technology I
- Using Flashback Technology II
- Implementing Oracle Database Auditing
- Implementing Oracle Database Auditing
- Database Maintenance
- Performance Management
- Managing Performance by SQL Tuning
- Diagnosing the Database
- Managing Space
- Managing Space for the Database
- Managing the ASM Instance
- Duplicating a Database / Cloning Database
- Data Guard
- Installing your Oracle Software
- Database Patches & Database Upgrades
- Introduction to Real Application Clusters
- OLTP vs OLAP
- Data modeling
- Snake-Flow diagram
- Dimensions and Facts
- IQD preparation
- IQD publishing
- Cube generation
- Cube publishing into portal
- Validations
- Adhoc reports
- Zero suppression reports
- Performance and Tuning with OLAP
- Backup and recovery in OLAP
No comments:
Post a Comment