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