RelationalDBDesign RelationalDBDesign


DBA Admin Tasks   «Prev  Next»
Lesson 2Prerequisites
Objective Verify that you have the right background for this course.

DBA Administrative Tasks Prerequisites

This course is designed for professionals who want to become certified Oracle database administrators. Managing an Oracle database requires a broad range of technical knowledge. To take this course, you need to be very comfortable working in your current operating requirement. Specifically, you should:
  1. Be comfortable installing and configuring software.
  2. Know your operating system reasonably well. You must be comfortable navigating to different directories, editing text files, copying files, running programs, and so forth.
  3. Have access to a text editor, such as Notepad or VI.
  4. Preferably have access to an Oracle8 or Oracle8i database, so that you can follow along with the examples and create the course project. You can take the course if you do not have access to Oracle13c you will just have to skip the hands-on exercises.
  5. Have a basic understanding of relational databases and how they are used.
  6. Be reasonably familiar with Structured Query Language ( SQL). You don’t need to be an expert, but you should be able to write simple SELECT statements. You need to understand what it means to join two tables, and you should know how to do that.
  7. Be comfortable using command-line utilities as opposed to always using a graphical user interface (GUI).

Platform requirements

Administrative Tasks is supported on UNIX (Linux is OK) and Windows Server platforms. Any operating system-specific examples (there aren’t many) are provided in both Windows Server and UNIX versions. But nowadays with cloud virtualization, anything is possible. If you are taking this course using some other operating system, you need to be comfortable translating a UNIX (or NT) example into the appropriate commands for that system. Our tutors will not be able to support you.

Previous courses

This course is the fourth in a five-part series. It is best if you take the previous three courses before taking this one. However, if you have a good understanding of Oracle's architecture and are comfortable creating databases, users, and schema objects such as tables and views, you should be able to get through this course.
In the next lesson, you will learn what you need to take this course.