ORACLE DBA Course Content

  • Identify the oracle product
  • Describe the basic concept of a relational database
Installing oracle database 10g software
  • System requirements
  • Use Oracle Optimal Flexible Architecture (OFA) 
  • Install software with the Oracle Universal Installer
Create an oracle database
  • Oracle Database Architecture
  • Oracle instance architecture
  • Use the Database Creation Assistant
Controlling the database
  • Manually configure the Oracle 10g EM dbconsole
  • Start and stop the agent 
  • Start and stop the enterprise manager database console 
  • Start and stop the listener 
  • Startup and shutdown the database
Storage Structures 
  • Defining the tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Obtain tablespace information
  • Create and manage tablespace using oracle enterprises manager
Administering users
  • Create and manage database user accounts 
  • Create and manage roles 
  • Grant and revoke privileges 
Oracle Database Security  ---  Only Theory
  • 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 Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity
Performance Monitoring
  • Gather optimizer statistics
  • View performance metrics
Monitoring and Managing Memory
  • Oracle Memory Structures
  • Automatic PGA Memory Management
  • Using the Memory Advisor
  • Using Automatic Shared Memory Management to avoid long running query issues
Monitoring and Resolving Lock Conflicts
  • Detect and resolve lock conflicts
  • Manage deadlocks
Diagnostic Sources
  • The Alert Log
  • Viewing Alerts with EM
  • Alerts Notification   ----- Only Theory
  • Editing Thresholds ----- Only Theory
  • Trace Files
Proactive Maintenance: Objectives   ---  Only Theory
  • Set warning and critical alert thresholds
  • Collect and use baseline metrics
  • Use tuning and diagnostic advisors
  • Use the Automatic Database Diagnostic Monitor (ADDM)

Automatic Storage Management  ---- Only Theory

  • ASM Concepts
  • ASM General Architecture
  • Creating an ASM instance
  • Creating tablespaces that use ASM storage
  • Viewing ASM information
  • Migrating a tablespace to use ASM storage.
Undo Management  ---  Only Theory
  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor
Backup and Recovery    ---  Only 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
Managing Data
  • Manipulating data through SQL
  • Using Import
  • Using Export
Database backups
  • Configure ARCHIVELOG mode
  • Create consistent database backups
  • Back your database up without shutting it down
  • Create incremental backups
  • Automate database backups
  • Monitor the flash recovery area
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
Database Recovery
  • Recover from loss of a control file
  • Recover from loss of a redo log file
  • Recover from loss of a data file