Course Features

Duration3 months
Skill LevelAdvanced

Seat:30 seat

Course Time:3 months

Oracle 11g DBA

Oracle DBAs handle capacity planning, evaluate database server hardware, and manage all aspects of an Oracle database including installation, configuration, design, and data migration. Additional responsibilities include performance monitoring, security, backups, troubleshooting, and data recovery.

Course Requirement

  • 1Enterprise edition installation
  • 2The administrator interface: general
  • 3The oracle enterprise architecture
  • 4Exploring the oracle database architecture: instance memory
  • 5Creating an oracle database
  • 6Managing the database instance
  • 7Manage database storage structures: Tablespaces
  • 8Manage database storage structures: advanced Tablespaces
  • 9Manage database storage structures
  • 10Managing undo data
  • 11Network environment: oracle shared servers
  • 12Security: implementing database security
  • 13Security: administering user security
  • 14Moving data: SQL loader
  • 15Moving data: export & import
  • 16Database maintenance & performance management
  • 17Managing concurrency & locks
  • 18• Backup & recovery concepts & configuration