DBA II: Oracle 10g Administration Workshop I

This module is the first step to be a DBA professional, and its purpose is to provide the necessary skills to install and maintain an Oracle Database.

The student wil conceptually understand the database architecture and the interaction between all its components. Besides, he will be able to create and manage different structures such as Performance Monitoring, Securing, User Administration and BackUp Techniques.

Labor profile

The graduates in this module are ready to perform different jobs that require basic skills to create, maintain and install an Oracle 10g Database. The training is suitable for profiles of Sales Consultants, Support Engineers, Project Managers, Databases Designers and Administrators, and Technical Consultants.

Duration

The course is a module of one semester with a timeframe of four hours per week.

Requirements

Knowledge of SQL.

Instructors

The Instructor Training is carried out twice a year to guarantee the quality of the educational service. Instructors from all the Proydesa Network come to Fundación Proydesa to prove their competences and learn new pedagogical techniques that allow them to do a successful personalized follow-up of each student.

All the instructors of the Proydesa Network are certified and work in key positions within leader companies of the country.

Study materials

Every student has access to state-of-the-art online multimedia contents in Spanish through a User ID and a Password, specially developed by Fundación Proydesa.

This material is structured in such way that the student can take self-tests, consult graphic schemes and make hypertext navigation.

To complete the in-person classes taught by the qualified instructor, an Oracle WDP Official Kit it is added that has didactic  material printed in Spanish, and that is compulsory for the career.

As a member of the Proydesa Network, they have access to documentation in electronic format, to Web Conference seminars and the excluisve Proydesa Network Job Portal, where their résumés are validated by a certified instructor and they can reach more than four hundred leader companies in the sector.

The most important contents

Administration Workshop I module.

• Introduction and installation of an Oracle Database

• Creation of an Oracle Database

• Oracle Database storage structure management

• User security administration

• Scheme objects management

• Data and simultaneity management

• Undo data administration

• Oracle Database security

• Oracle network

• Performance management

• Data recovery, backup and flashback

Lab guides

The purpose of the exercises will be to solve challenging situations about Oracle Databases specially mounted for this purpose.

Exams

Assessment exams, one written and one in a hands-on lab environment are taken during the course.

All the exams are taken in-person using the Internet and the User ID and Password

Certificate and international certification

At the end of the module, the graduate receives a certification that he has passed issued by the Local Academy, Fundación Proydesa and Oracle.

Likewise, the student has the possibility to take the Oracle 10g Database Administrator Certified Associate (OCA) international certification, for which Proydesa Network and Oracle give a discount voucher.

| Más...