DBA I: Oracle 10g SQL Fundamentals

This module is a complete introduction to the Relational Databases and the SQL query language. Its objective is to provide the necessary skills for the developer to identify the main components of an Oracle 10g Database.

Labor profile

The graduates in this module are trained to carry out tasks that require skills related to SQL programming language, an essential requirement to manage the database components.

They can deal with different SQL declarations, create reports or tables to load data and organize data among other activities.

Duration

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

Requisites

No previous knowledge required.

Instructors

The Instructor Training program 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 sel-tests, consult graphic schemes and make hypertext navigation.

To complete the in-person classes taught by the qualified  instructor, an Oracle WDP Official Kit 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 exclusive 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

- SQL Fundamentals Module:
• Main components of an Oracle 10g Database.
• Writing of SQL sentences.
• Use of iSQLPlus.
• Logic conditionals AND, OR, NOT.
• Grouping functions.
• Data visualization in multiple tables.

Lab guides

The prupose 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.

Certification

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

| Más...