•  Introduction To Oracle DBA
• What is DBA?
• Why a Company needs a DBA?
• Roles & Responsibilities of DBA
• Exploring the Oracle Database Architecture
• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures
• Preparing the Database Environment
• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI)
• Creating an Oracle Database
• Create a database manually and by using the Database Configuration Assistant (DBCA)
• Managing the Oracle Instance
• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views
• Configuring the Oracle Network Environment
• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture
• Managing Database Storage Structures
• Overview of tablespace and datafiles
• Create and manage tablespaces
• Space management in tablespaces
• Administering User Security
• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles               
• Managing Data and Concurrency
• Monitor and resolve locking conflicts
• Managing Undo Data
• Overview of Undo
• Transactions and undo data

Managing undo

• Performance Management
• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects
• Backup and Recovery Concepts
• Identify the types of failure that can occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Overview of flash recovery area
• Configure ARCHIVELOG mode
• Performing Database Backups
• Create consistent database backups
• Back up your database without shutting it down
• Create incremental backups
• Automate database backups
• Manage backups, view backup reports and monitor the flash recovery area
• Performing Database Recovery
• Overview of Data Recovery Advisor
• Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
• Moving Data
• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases
•  AUDITING
• What is auditing?
• Why auditing performed?
• Types of Auditing
• Levels of Auditing
• FLASHBACK FEATURES
• Flashback Database
• Flashback Archive(11g)
• MISCELLANEOUS
• Patch Maintenance
• Comparison between Oracle 10g and Oracle 11g
• New features Introduced in Oracle 11g
• Up gradation from Oracle 10g to Oracle11g