Oracle 10g Application Developer Certification

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database

Course Objectives

Specific subject areas to be explored and objectives to be reached are:

• A summation of relational database principles and an introduction to the Oracle relational database server.
• Using the iSQL*Plus web-based database interface and other traditional interfaces.
• Writing simple SQL queries and moderately complex SQL queries using various join techniques.
• Summarizing, grouping and sorting data.
• Advanced query techniques such as correlated sub queries.
• Developing simple SQL*Plus reports.
• Creating and maintaining database tables.
• Taking advantage of new features such as the use of regular expressions.

Course Benefits

Specific subject areas to be explored and objectives to be reached are:

• A summation of relational database principles and an introduction to the Oracle relational database server.
• Using the iSQL*Plus web-based database interface and other traditional interfaces.
• Writing simple SQL queries and moderately complex SQL queries using various join techniques.
• Summarizing, grouping and sorting data.
• Advanced query techniques such as correlated sub queries.
• Developing simple SQL*Plus reports.
• Creating and maintaining database tables.
• Taking advantage of new features such as the use of regular expressions.

Course Duration

40 hours