ORACLE DBA ONLINE TRAINING

Many people want to enhance the value of their profile. Taking up a certification course in Oracle technologies is one of the validated and established ways of making your resume more valuable. Oracle DBA online training gives even the employed people interested in enhancing the worth of their profile a chance to add Oracle certification to their resume.

This particular certification helps you outstand among the professionals as it indicates verification of a particular skill set which is what many reputed companies are looking for instead of just having basic knowledge. Professionals with Oracle certification have been known to possess high salary jobs as compared to DBA professionals or other developers. Thus, Oracle DBA online training gives you an opportunity to venture into a successful career path.

 

PRE-REQUISITES: SQL, PL/SQL

 

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
  1. OLTP vs OLAP
  2. Data modeling
  3. Snake-Flow diagram
  4. Dimensions and Facts
  5. IQD preparation
  6. IQD publishing
  7. Cube generation
  8. Cube publishing into portal
  9. Validations
  10. Adhoc reports
  11. Zero suppression reports
  12. Performance and Tuning with OLAP
  13. Backup and recovery in OLAP

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top