Aptech Computer Education - Oracle 9i DBA Fundamentals -1 (Paper 3)

Oracle 9i DBA Fundamentals - 1 (Paper 3)

A Database Administrator’s (DBA) role is of paramount importance since it deals with critical issues of database design and management. This paper gives a firm foundation in basic database tasks. By the end of this segment, students will be able to design, create and maintain an Oracle database

Who will the course benefit?

Students and working professionals who wish to gain expertise in Oracle database administration

What skills will the student gain?


Prerequisites
Prior knowledge of Oracle 9i SQL is necessary

Duration
40 hours

Certification
Certificate of participation (Additionally, students can appear for Oracle 9i DBA - 1 vendor certification)

After the completion of this course, the student will be able to:

Describe the Oracle architecture

Identify the features of the Oracle Universal Installer

Explain the start-up and shutdown of an Oracle instance

Describe the process of database creation

Explain data dictionary and dynamic performance views

Explain control file and redo log files

Explain managing tablespaces and datafiles

Describe the different types of indexes and their uses

Explain resource management and privileges

Explain auditing

Describe globalisation support in Oracle

> Back