Introduction (6 topics)

  • Oracle product overview
  • Oracle Support services
  • Relational database concepts
  • Oracle architecture
  • Database administration tasks
  • Database administration tools

Installing and Configuring an Oracle Database (6 topics)

  • Understand system requirements
  • Use Oracle Universal Installer to install Oracle software (OUI)
  • Create a database using Database Configuration Assistant (DBCA)
  • Delete a database using DBCA
  • Use DBCA to manage templates
  • Upgrade a database using Database Upgrade Assistant (DBUA)

Administer a Database (6 topics)

  • Administrative tools available to a DBA
  • Use SQL*Plus and SQL Developer to manage a database
  • Administer the database using Enterprise Manager (EM)
  • Start and stop the EM Database Console
  • EM navigation
  • Grant EM administrative privileges to a user

Configure the Oracle Network Environment (9 topics)

  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Configure local naming for client connections with Net Manager
  • Start and stop the Oracle listener
  • Configure the listener with EM
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database

Oracle Instance (9 topics)

  • Instance management
  • Memory structures
  • Background processes
  • Access an Oracle database
  • Initialization parameters
  • Password file
  • Shutdown the database
  • Startup the database
  • View alert log and trace files

Database Storage Structures (8 topics)

  • Oracle database structures
  • Control files
  • Redo log and archive redo log files
  • Tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Manage undo and use the Undo Advisor
  • Use EM to view the storage structure of the database

Manage Users (6 topics)

  • Database administration accounts
  • User accounts
  • Create and administer user accounts
  • Lock and unlock user accounts
  • Change a user’s password
  • Administer privileges and roles

Manage Schema Objects (10 topics)

  • Create schema objects
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Create indexes
  • View index attributes
  • Create views
  • Create synonyms
  • Create sequences

Backup, Recover and Restore a Database (10 topics)

  • Oracle backup strategy
  • Overview of backup, restore and recovery
  • Backup and recovery configuration
  • Configure ARCHIVELOG mode
  • Backup and recover the database using EM
  • Schedule backups
  • Configure backup settings
  • Configure recovery settings
  • Configure catalog settings
  • Perform recovery

Performance Monitoring (7 topics)

  • Self-monitoring architecture
  • Monitor an Oracle database
  • Automatic Workload Repository
  • Automatic Database Diagnostics Monitor (ADDM)
  • Use the advisors
  • Set up notification rules
  • Conclusion