DBA Admin Tasks   «Prev  Next»

DBA Admin Tasks

Welcome to Administrative Tasks. In this course, you will learn how to monitor your database, how to manage its physical structure, and how to use the import, export, and loader utilities. Taken together, the courses in this series teach you how to create and manage an Oracle database.

Course goals

The goal of this course is to teach you the skills to manage the physical aspects of an Oracle database and to teach you about the most critical performance metrics that you should monitor. After completing the course, you will be able to:
  1. Monitor critical aspects of your database's performance
  2. Manage database control files and redo log files
  3. Place a database into archivelog mode
  4. Manage tablespaces and data files
  5. Create and manage rollback segments
  6. Use the import and export utilities
  7. Use SQL*Loader to load data from flat files

How you will learn

In this course, you will learn and practice your Oracle skills using several types of applets:
  1. FlipBooks,
  2. Diagrams,
  3. Simulations, and
  4. Quizzes
There are also a number of exercises allowing you to gain some real-life experience putting your new skills to practice.

Oracle certification

This course, taken in conjunction with the other four courses in the Oracle8 Database Administration Certification Series, will prepare you for the following Oracle certification exam:
  1. IZ0-013, Oracle8: Database Administration

This database administration exam is one of five that you must pass to earn certification as an Oracle8 database administrator. You can learn more about Oracle's certification requirements and exams by visiting Oracle's Web site.

The series

Administrative Tasks is the fourth of five courses in the Oracle13c Database Administration Certification Series.
In the next lesson, you will learn about prerequisites to this course.