StarCom Group Software/Networking Training Center

Oracle Developer

Oracle Application Developer I (PL/SQL)


This course will help participants understand how Oracle tools and methodologies can be used to fulfill real-world business information requirements. Participants will learn how to design and create database structures to store, retrieve, update and display data in a relational database. Participants will also learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, web pages and applications developed by third party tools like Visual Basic, Visual C++, etc, and will use Oracle Procedure Builder to develop and debug PL/SQL programs. This course is designed to quickly guide participants through basic to advanced techniques for application development in a wide Client/Server and Web environment, which will be covered in the second part (II) of this course.

Oracle Server

Introducing Oracle Server Concepts and Architecture, like databases and information management, the Oracle server (memory, structure and processes), database structure and space management, data access, data concurrency and consistency, distributed processing and distributed databases, database security, data access, database backup and recovery, model, the object-relational model.

Oracle SQL: DDL and DML

  • Retrieve and Display Information. Query, display and format data. Save, retrieve and run queries. Build and format reports. Group and summarize data.
  • Manipulate Information. Insert, update, automatically generate and delete data. Control transaction processing.
  • Create Tables and Data Structures. Create, confirm, modify and remove tables to store data. Apply business rules to ensure data integrity. Restrict user access into tables. Improve query performance.
  • Control User Access. Grant, confirm and remove system and object privileges. Create and remove user roles.
  • Perform Computations with Data. Perform calculations with numeric, date and character data. Count, group and summarize data.
  • Display Data from Multiple Tables. Display data and create a view of multiple tables.
  • Nest Queries. Nest, subqueries within another SQL command.

Develop Applications Using Procedural Capabilities (PL/SQL)

  • PL/SQL fundamentals. Describe PL/SQL block structure. Define input and output values. Describe PL/SQL control structures. Insert and manipulate data with PL/SQL. Execute SQL statements from a PL/SQL block. Discuss a typical development cycle.
  • Develop and Debug PL/SQL Programs in Procedure Builder. Create, manage, and execute program units using the Object Navigator and the PL/SQL Interpreter. Define and compile procedures using the Program Unit Editor. Control the execution of a PL/SQL program unit. Test possible solutions by making changes to variables and procedures at runtime.
  • Prototype PL/SQL Blocks. Manipulate multiple rows with cursors. Pass
  • Implement and Test PL/SQL Blocks. Modularize code. Pass values from one program construct to another. Handle errors. Follow programming standards.

Other Training Activities:

  • Introducing the usage of Oracle tools like SQL*Plus, Procedure Builder, Enterprise Manager, etc;
  • In-Class Lab Exercises; Off-Class Lab Exercises and Written Exercises; Business Case Studies.
  • Oracle Product and third-party tools support, like SQL *Net V2.x, Oracle Developer/2000, Oracle Designer/2000, MS Visual Studio, etc.

Required Prerequisites:

General programming and database knowledge.

Class and Lab Environment:

Oracle Enterprise Server 7.3.3 and Oracle Server 8.0.3 running on Windows NT and SUN Solaris UNIX. Oracle Web Application Server 2.1 and 3.0 running on Windows NT and SUN Solaris UNIX. Pentium Workstation installed with NT Workstation 4.0, TCP/IP, Oracle Network, Oracle Client, Oracle Developer/2000 1.4W, PC X Server connecting to UNIX, MS Visual Studio, 24 hour on-line Exercises through Internet, etc.


50 hours, 6 hours a week.