UAHuntsville

You will gain detailed instruction and hands-on experience in Oracle database administration fundamentals. The course covers topics associated with the latest version of the Oracle Relational Database Management Systems (RDBMS) server; however, the topics also apply to all versions of the Oracle RDBMS.

Topics Include:
• Installing and uninstalling the Oracle Binaries
• Implementing an efficient and effective database
• Creating and managing tablespaces and datafiles
• Managing control files
• Managing online redo logs and redo log groups
• Efficiently managing database security
• Configuring and managing the Oracle network
• Managing database objects
  • Tables and Constraints
  • Indexes
  • Views
  • Synonyms
  • Sequences

• Data Dictionary Basics
• Managing large amounts of data
  • Using partitioning to manage large amounts of data
  • Using Oracle Data Pump to move large amounts of data
  • Transportable tablespaces
  • External tables
  • Materialized views

• Backing-up and recovering database
  • Configuring RMAN
  • Scheduling backups
  • RMAN Restore and Recovery

• Troubleshooting database issues

Prerequisites:
Oracle Fundamentals or equivalent experience.