 |
You
will be able to... |
| |
| - |
Build robust
and scalable Oracle9i database applications |
| - |
Establish a data model
and a storage framework
|
| - |
Develop powerful and efficient
SQL statements |
| - |
Write reusable structured
PL/SQL code with cursors, procedures and
triggers |
| - |
Improve application performance
by utilizing indexes and optimizing PL/SQL |
| - |
Appear for OCA and OCP Certification
Exams for Developer Track |
|
| |
|
|
Who should attend... |
| |
| This course is valuable
for those who are, or will be, working with
Oracle9i. Experience with relational databases
and familiarity with basic programming concepts
are helpful. Computer Fundamentals and Windows
Operating System knowledge is an advantage.
Any Programming Language, DBMS like Dbase
or FoxPro are preferred and Oracle 9i SQL and PL/SQL |
|
| |
|
|
Introduction
to Oracle 10g : SQL (Exam – IZ0– 007) |
| |
Course Content |
| |
Duration : 56 Hrs. |
| |
Prerequisite: Computer Fundamentals,
Windows Operating System |
| |
 Introduction |
| |
Writing Basic SQL SELECT Statements |
| |
Restricting and Sorting Data |
| |
Single- Row Functions |
| |
Displaying Data from Multiple Tables |
| |
Aggregating Data Using GroupFunctions |
| |
Subqueries |
| |
Producing Readable Output with iSQL *Plus |
| |
Manipulating Data |
| |
Creating and Managing Tables |
| |
Including Constraints |
| |
Creating Views |
| |
Other Database Objects |
| |
Controlling User Access |
| |
SQL Workshop |
| |
Using SET Operators |
| |
Oracle 9i Datetime Functions |
| |
Enhancements to the GROUP BY Clause |
| |
Advanced Subqueries |
| |
Hierarchical Retrival |
| |
Oracle 10g Extensions to DML and DDL Statements |
| |
|
Oracle 10g : Program
with PL/SQL (Exam – IZ0– 147) |
| |
Course
Content |
| |
Duration : 52 Hrs. |
| |
Prerequisite : Oracle 10g
SQL |
| |
Introduction
to PL/SQL |
| |
Declaring Variables Writing Executable Statements |
| |
Interacting
with Oracle Server |
| |
Writing
Control Structures |
| |
Working
with Composite Data Types |
| |
Writing Explicit Cursors |
| |
Advanced Explicit Cursor Concepts |
| |
Handling
Exceptions |
| |
Creating
Procedures |
| |
Creating Functions |
| |
Managing Subprograms |
| |
Creating Packages |
| |
More Package Concepts |
| |
Oracle Supplied Packages |
| |
Manipulating Large Objects |
| |
Creating Database Triggers |
| |
More Trigger Concepts |
| |
Managing Dependencies |
| |
|
|
Oracle
10g Forms Developer: Build Internet Applications
(Exam – IZ0– 141) |
| |
Course
Content |
| |
Duration
: 60 Hrs. |
| |
Prerequisite: Oracle 10g SQL and
PL/SQL |
| |
Introduction
to Oracle Forms Developer and Oracle Forms Services |
| |
Running
a Forms Developer Application |
| |
Working in Forms Developer Environment |
| |
Creating a Basic Form Module |
| |
Working
with Data Blocks and Frames |
| |
Working
with Text Items |
| |
Creating LOVs and Editors |
| |
Creating
Additional Input Items |
| |
Creating Non – Input Items |
| |
Creating
Windows And Content Canvases |
| |
Working
with Other Canvas Types |
| |
Introduction to Triggers |
| |
Producing
Triggers |
| |
Debugging
Triggers |
| |
Adding Functionality to Items |
| |
Runtime Messages and Alerts |
| |
Query
Triggers |
| |
Validation |
| |
Navigation |
| |
Transaction
Processing |
| |
Writing
Flexible Code |
| |
Sharing
Objects and Code |
| |
Introducing
Multiple Form Applications |
