ORACLE

 ORACLE  FORMS - SQL - 50 Hours                                              

• Introduction
• Writing Basic SQL Statement
• Restricting & Sorting Data
• Single Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data using Group Functions
• Sub-Queries
• Producing Readable Output with iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views & other Database Objects
• Controlling User Access
• Using Set Operators
• Oracle 9i Datetime Functions
• Enhancements to the Group BY Clause
• Advanced Sub-Queries
• Hierarchical Retrieval
• Oracle 9i Extensions to DML and DDL Statements


PL/SQL -50 Hours

• Introduction
• Declaring Variables
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data Types
• Writing Explicit Cursors and advanced Explicit Cursor
• Handling Exceptions, Creating Procedures
• Creating Functions, Managing Subprogram
• Creating Packages, More Package Concepts
• Oracle Supplied Packages
• Manipulation Large Objects
• Creating Database Triggers
• Managing Dependencies


Build Internet Applications                                                                                                     

• Create Form modules
• Including components in multiple windows
• Link one Form module to another
• Implement Triggers
• Reuse Objects and Code
• Test Form modules in a Web browser
• Debug form modules in a 3-Tier environment
• Working with Data Blocks
• Frames
• Canvases
• Triggers
• Alerts
• Messages
• Writing Flexible Codes
• Sharing Objects and Codes
• Transaction Management

  ORACLE DATABASE  -  SQL - 50 Hours

• Introduction
• Writing Basic SQL Statement
• Restricting & Sorting Data
• Single Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data using Group Functions
• Sub-Queries
• Producing Readable Output with iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views & other Database Objects
• Controlling User Access
• Using Set Operators
• Oracle 9i Datetime Functions
• Enhancements to the Group BY Clause
• Advanced Sub-Queries
• Hierarchical Retrieval
• Oracle 9i Extensions to DML and DDL Statements

Oracle 9i Forms Developer-- 60 Hours

DBA Fundamental I - 45 Hours

• Oracle Architectural Components
• Getting Started with Oracle Server
• Managing an Oracle Instance, Creating a Database
• Data Dictionary Contents and Usage
• Maintaining the Control File, Redo Log Files
• Managing Tables paces and Data Files
• Storage Structures and Relationships
• Managing Undo Data, Tables, Indexes
• Maintaining Data Integrity, Managing Password
• Managing Security, Resources, Users, Privileges & Roles
• Loading Data Into a Database & Globalization Support

DBA Fundamental II - 45 Hours

• Basic Oracle Net Architecture, Server-Side Configuration
• Basic Oracle Net Services Client-Side Configuration
• Usage and Configuration of the Oracle Shared Server
• Backup and Recovery Overview
• Instance and Media Recovery Structures
• Configuring the Database Archiving Mode
• Oracle Recovery Manager Overview and Configuration
• User Managed Backups, RMAN Backups
• User Managed Complete & Incomplete Recovery
• RMAN Complete Recovery, Incomplete Recovery & Maintenance
• Recovery Catalog Creation and Maintenance
• Transporting Data between Databases

  Performance Tuning - 45 Hours

• Overview of Oracle 9i Performance Tuning
• Diagnostic and Tuning Tools
• Sizing the Shared Pool & the Buffer Cache
• Sizing the other SGA Structures
• Database Configuration and I/O Issues
• Optimizing Sort Operations
• Diagnosing Contention for Latches
• Tuning Rollback Segments
• Monitoring and Detecting Lock Contention
• Tuning the Oracle Shared Server
• Application Tuning, Using Oracle Blocks efficiently
• SQL Statement Tuning, Tuning the OS and using Resource Manager