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
Introduction