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 9i : SQL (Exam – IZ0– 007)
Course Content
Duration : 45 Hrs.
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 9i Extensions to DML and DDL Statements
Oracle 9i : Program with PL/SQL (Exam – IZ0– 147)
Course Content
Duration : 45 Hrs.
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 9i Forms Developer: Build Internet Applications (Exam – IZ0– 141)
Course Content
Duration : 45 Hrs.
Introduction to Oracle Forms Developer and Oracle Forms Services
Introduction