ORACLE DBA Course Content

 
Introduction
  • 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