Welcome to Comnet Group Inc.


Oracle Database Administration

Course number: OracleDBA-CGI001

This Oracle 11g training course will allow the student to gain the skills necessary for day-to-day administration of an Oracle database.

Who Should Attend

The primary audiences for this course are: Database administrators Web server administrators System administrators Implementation specialists Data center support engineers senior application designers and developers

Course Outline
Lesson 1: Installation and Upgrade Volume
  • Configuring the Server for Installation
  • Enterprise Edition Installation
  • Verify the Installation
  • Upgrade, Deinstallation and Patching
Lesson 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: Table Spaces
  • Manage Database Storage Structures: Advanced Table Spaces
  • Manage Database Storage Structures: Data Files & Temp Files
  • Managing Undo Data
Lesson 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
Lesson 4: Volume A: Advanced Database Administration
  • Managing Memory
  • Managing Storage & The Segment Advisor
  • Globalization
  • Diagnosing Database Problems
  • Recovery Concepts
  • Oracle Flashback Technology
  • Flashback Database & Flashback Data Archive
Lesson 5: Volume B: Resource Manager & Scheduler
  • Managing Resources
  • Automating Tasks with the Scheduler (Basic)
  • Automating Tasks with the Scheduler (Advanced)
  • Managing Database Performance
Lesson 6: Volume C: RMAN Backup & Recovery
  • Instance Recovery
  • Configuring RMAN
  • Backup with RMAN
  • RMAN Management with EM
  • User-Managed Recovery Operations
  • Recovery with RMAN
  • Using the RMAN Recovery Catalog
  • Database Duplication & Cloning
  • Advanced RMAN Capabilities
  • Transporting Table Spaces
  • Recovering From Corruption with Data Recovery Advisor

Available Formats

Live Online