Monday 30 December 2013

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
  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

No comments:

Post a Comment