Database Administration - ORACLE 11G DBA

Part- 1

Installation and Upgrade Volume

• Configuring the Server for Installation
• Enterprise Edition Installation
• Verify the Installation
• Upgrade, Deinstallation and Patching

Part- 2

• Manually Starting & Stopping Database Services
• Exploring the Oracle Database Architecture: General
• Exploring the Oracle Database Architecture: Instance Memory
• Exploring the Oracle Database Architecture: Instance Processes
• Creating an Oracle Database
• Enabling Transparent Data Encryption
• Manage Databases Storage Structures: TableSpaces
• Manage Database Storage Structures: Advanced TableSpaces
• Manage Database Storage Structures: Data Files & Temp Files
• Managing Undo Data

Part- 3

• Network Environment: Oracle Net Services
• Network Environment: Oracle Shared Servers
• Security: Implementing Database Security
• Security: Administering User Security
• Moving Data: SQL Loader
• Moving Data: Export & Import
• Database Maintenance & Performance Monitoring
• Managing Concurrency & Locks
• Backup and Recovery Concepts and Configuration