TRAINING
Oracle 11g
Developer 10g
Apps Technicals (R12)
Applications DBA
Financials Functional
Oracle SCM
Manufacturing
Oracle HRMS
OAF
Oracle RAC
ADF
Oracle DBA

Oracle DBA

  • UNIX/LINUX BASICS
    • File management commands
    • Scheduling, background processing, file security,..
  • SHELL SCRIPTING
    • Introduction, variables
    • Control instructions
    • Advanced scripting,….
  • SQL
    • DRL, DDL, DML, TCL, DCL
    • Indexes, Views, Synonyms, Sequences,..
  • ORACLE DATABASE ARCHITECTURE
    • What Is RDBMS
    • Memory Structures
    • Database Logical & Physical Structures,..
  • DATABASE ADMINISTRATION AND MANAGEMENT
    • Installation / Uninstallation
    • Managing Database, Datafiles, Tablespaces
    • Control File Management
    • Parameter Files(Pfile), Server Paramenet Files(Spfile),..
  • NETWORK MANAGEMENT
    • Configuring Listener, Tns Clients
    • Monitoring & Trouble Shooting,…
  • BACKUP & RECOVERY
    • Introduction, Design, Test, Implementation Stratagies
    • Offline (Cold) Backups, Online (Hot) Backups
    • Rman
    • Database Cloning,..
  • LOGICAL BACKUP & RECOVERY
    • Import And Export Tables (Imp, Exp)
    • Datapumps (Impdp, Expdp),..
  • FLASHBACK
    • Introductions, Configuration
    • Flasback Query/Table/Table Drop/Database
    • Creating Restore Points
  • DATA GUARD
    • Introduction
    • Architecture
    • Configure Stand By Database
    • Switchover And Failover
    • Monitoring & Trouble Shooting,…
  • UPGRADATION & MIGRATION
    • Introduction
    • Upgrading 9i To 10g, 10g To 11g
    • Migrating Oracle Database Between Hetrogenous Envoronment(Widows To Linux)
  • PERFORMANCE TUNING
    • Introduction
    • Proactive Vs Reactive Tuning
    • Db Defragmentation
    • Explain Plan
    • Db Stats
    • Tuning Of Memory Parameters
    • Managing & Generating Awr Snapshots,…
  • ASM (AUTOMATIC STORAGE MANAGEMENT)
    • Configuaration Of ASM Instance
    • Asm Processes And Parameters
    • Managing Asm Disk Groups Using ASM Cmd Utility
    • Monitoring & Trouble Shooting,…
  • REAL APPLICATION CLUSTERS (RAC)
    • Introduction To RAC
    • RAC Setup Requirements
    • RAC Architecture
    • Installation
    • Cluster Installation
    • Different File Systems For Database
    • RAC Administration
    • Backup & Recovery In RAC Environment
    • Cloning Types
    • Load Balancing & Workload Management
    • Applying Patches & Upgradation
    • Performance Monitoring In RAC
 
© Copyright APP World. All rights Reserved. Designed by InnovateIndia.