Oracle

Oracle Core DBA

  • Introduction to DBA
  • Relational Database model
  • Installation of Oracle Software
  • Oracle Database Architecture
  • Creating an Oracle Database
  • Managing the Oracle database Instance
  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auding
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performaing Database Recovery
  • Moving Data
  • Recovery Manager (RMAN)
  • Monitoring and Managing Memory
  • Automatic Storage Management
  • Automating Tasks

Oracle RAC DBA

  • Oracle Grid infrastructure Concepts
  • Administering Oracle ClusterWare
  • Install oracle Clusterware and Real
  • Applicaiton cluster
  • Administering ASM Instance
  • Administring a RAC Database
  • RAC Backup and Recovery Using EM
  • Parallel Recovery in RAC database
  • Performance monitoring in RAC systems

Db2 UDBA DBA

  • Installing and Configuring Db2 on AIX/WINDOWS
  • Clinet/Server setup conepts
  • Crating and Managing Database instance
  • Creating and Managing Db2 database
  • Creating Database Objects
  • Db2 utilities
  • Moving data
  • Backup and Recovery
  • Problem Determination
  • Application issues and performance
  • Security