Oracle DBA Online Training

  • Introduction (Theory)
    • Identify the oracle product
    • Describe the basic concept of a relational database
    • New features in oracle 11g
  • Installing oracle database 11g software
    • System requirements
    • Redhat Linux 5.0 Installation (with and without Vmware workstation)
    • Installation of multiple oracle servers and multiple oracle databases on Vmware workstation (features and advantages for RAC implementation with Vmware configuration)
    • Install software with the Oracle Universal Installer on Linux Platform
  • Oracle database Architecture
    • Oracle Database 11g Architecture
    • Oracle instance architecture
    • Oracle Read Consistency and Concurrency
  • Database Creation.
    • Manual
    • Database Configuration Assistant(DBCA)
  • Controlling the database
    • Start and stop the enterprise manager database console
    • Start and stop the listener
    • Startup and shutdown the database
  • Storage Structures and architecture of Oracle 11g DBA
    • Logical structure Vs Physical structure
    • Defining the tablespaces and data files
    • Create tablespaces
    • Manage tablespaces
    • Obtain tablespace information
    • Managing Undo Data
  • File Management ( Theory)
    • Control File Management
    • Redo Log File Management
    • Parameter File Management
    • Obtain tablespace information
  • User Management
    • Create and manage database user accounts
    • Roles
    • Privileges
    • Control resource usage by using Profiles ion
  • Oracle Database Security
    • Apply the principal of least privilege
    • Manage default user accounts
    • Implement standard password security features
  • Oracle Net Services
    • Understand Oracle Net concepts
    • Use Oracle Net Manager to create and configure listeners
    • Use the listener control utility to control the Oracle Net Listener
    • Testing Oracle Net connectivity
    • Shared Server: Connection pooling
  • Managing schema objects
    • Create and modify tables
    • Define constraints
    • View the attributes of a table
    • View the contents of a table
    • Create indexes and views
  • Oracle Backup & Recovery (User Managed) (Theory)
    • Describe the basics of database backup, restore and recovery
    • List the types of failure that may occur in an Oracle Database
    • Describe ways to tune instance recovery
    • Identify the importance of checkpoints, redo log files, and archived log file
  • Oracle Backup
    • Archive Log Mode
    • Hot Backup
    • Cold Backup
    • RMAN Backup
  • Cloning
    • Cold Backup Cloning
    • RMAN Backup cloning
  • Logical Backup & Transporting data between databases
    • Introduction Data pump (expdp, impdp) Utilities
    • Exporting/Importing Tables
    • Exporting/Importing Schemas
    • Exporting/Importing Database
  • Invalid Objects
    • Compiling Invalid objects
    • Status of Invalid objects
    • Retriving count of each object type for each owner
    • Rebuild Indexes
  • Proactive Maintenance
    • Contents
    • Optimizer statistics
    • Automatic Workload Repository
  • Monitoring and Resolving Lock Conflicts
    • Detect and resolve lock conflicts
    • Manage deadlocks
  • Automatic Storage Management (Theory)
    • New features and implementation
  • Database Recovery (Practice only after getting experience)
    • Recover from loss of a control file
    • Recover from loss of a redo log file
    • Recover from loss of a data file