IIUSA

Excellence in Information Technology Education

Search

 

 

Oracle Certified Developer

IIUSA-366: Oracle 9i: Program with PL/SQL

Course length: 40 hrs
Prerequisites: Ordinary expertise using a Web browser.
Tuition: $2305

This course expands the concepts of relational databases and the knowledge of the SQL and PL/SQL programming languages. Students will learn and practice how to write advanced queries, use correlated subqueries, and gather data from hierarchical relationships. Students will learn to create professional looking reports using advanced formatting options. Finally, students will learn how to create PL/SQL blocks of application code that can be used in Oracle applications.

Special notes: This course prepares students for Oracle exam 1ZO-101 [Develop PL/SQL Program Units].

IIUSA-367: Oracle 9i Forms Developer: Build Internet Applications

Course length: 40 hrs
Prerequisites: IIUSA-366 iOracle 9i: Program with PL/SQL
Tuition: $2305

In Build Internet Applications I, students build and test interactive Internet applications. Working in a graphical user interface (GUI) environment, students learn to customize Forms with user input items such as check boxes, list items, and radio groups. They also learn to modify data access by creating event-related triggers. Students will be provided with courseware and access to exam preparation software.

Special notes: This course prepares students for Oracle exam 1ZO-131 [Build Internet Applications I].

IIUSA-358: Oracle iDS Forms: Build Internet Applications II (6i)

Course length: 24 hrs
Prerequisites: IIUSA-357 Oracle iDS Forms: Build Internet Applications I (6i)
Tuition: $1538

In Build Internet Applications II students broaden their application building skills using Oracle Forms Developer, a productive development environment for building enterprise-class Internet database applications. Students create multiple-form Internet applications and learn to manage multiple transactions across modules. By adding custom menus, reports, and charts they also learn to enhance their applications. Finally, the course teaches students to enhance the user interface for Web-deployed forms using Java Beans. Students will be provided with courseware and access to exam preparation software.

Special notes: This course prepares students for Oracle exam 1ZO-132 [Build Internet Applications II].

IIUSA-361: Oracle 9i: Introduction to Oracle9i: SQL

Course length: 40 hrs
Prerequisites: IIUSA-349 Data Modeling and Relational Database Design or prior experience with relational databases. Suggested: Ability to use a graphical user interface (GUI).
Tuition: $2305

This course offers students an extensive introduction to data server technology. The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. They also learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts.

Course Topics

  • Control data and user access
  • Control transactions
  • Create and maintain database objects
  • Perform multitable INSERT commands and use external tables
  • Retrieve, insert, update, and delete data
  • Use GROUPING SETS and the WITH clause
  • Use iSQL*Plus to format reports
  • Use the new single-row DATETIME and NVL2 functions introduced in Oracle9i
  • Write SQL scripts that use SQL to generate SQL
  • Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
  • Describe relational and object relational database concepts
  • Use advanced techniques to retrieve data by using ROLLUP, CUBE, set operators, correlated subqueries, and hierarchical queries
  • Use basic iSQL*Plus commands

Special notes: This course prepares students for Oracle exam 1Z0-007 [SQL].