maintopbg

Oracle 9i Developer


Oracle Certification is a valuable Industry recognized certification that signifies a proven level of knowledge & skills. The Oracle Workforce Development Program (WDP) is a initiative, where Oracle provides software curriculum, training and certification resources to educational institutions to deliver Oracle training as part of certificate and non-degree programs offered via Continuing Education. Oracle WDP program covers official Oracle curriculum and prepare you to Oracle Certified Professional(OCP) exam and other Oracle International Certification exams.


Introduction to Oracle 9i : SQL

  • Writing Basic SQL Select Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Affregating Data using Group Functions
  • Subqueries
  • Implementing ADO.NET With XML in ASP.NET
  • Manipulating Data
  • Creating and Managing Tables Including Constraints
  • Creating Views
  • Other Database Objects
  • Controlling User Access
  • Using Set Operators
  • Date Time Functions
  • Enhancements to the Group by clause
  • Advanced Subqueries
  • Hierarchical Retrieval

Oracle 9i: Forms

  • Introduction to Oracle Forms Developer and Oracle Forms Services
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment
  • Creating a Basic Form Module
  • Working with Data Blocks, Frames, Text Items
  • Creating Lovs and Editors
  • Creating Additional Input / Non Input Items
  • Creating Windows and Content Canvases
  • Working with other Canvas Types
  • Producing Triggers, Debugging Triggers
  • Adding Functionality to Items
  • Run Time Message and Alerts
  • Query Triggers, Validation, Navigation
  • Transaction Processing, Writing Flexible Code
  • Sharing Objects and Code
  • Introducing Multiple Form Applications

Oracle 9i: Programming with PL/SQL

  • Introduction to PL/SQL
  • Declaring Variables
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control Structure
  • Working with Composite Data Types
  • Writing Explicit Cursors
  • Advanced Explicit Cursor Concepts
  • Handling Exceptions
  • Creating Procedure, Functions
  • Managing Subprograms
  • Creating Packages
  • More Package Concepts
  • Using Oracle Supplied Packages
  • Creating Database Triggers
  • Managing Dependencies
Oracle 9i : Reports

  • Introduction to Oracle 9i Reports Developer
  • Designing and Running Reports
  • Creating a Paper Reports
  • Enhancing a Basic Paper Report
  • Managing Report Templates
  • Creating a Web Report
  • Enhancing Reports using The Data Model:
  • Queries and Groups, Data Sources & Creating Columns
  • Controlling The Paper Layout
  • Common Properties, Specific Properties
  • Web Reporting
  • Extending functionally using XML
  • Creating and using Report Parameters
  • Embedding a Graph in a Report
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers, SRW Package
  • Oracle 9i as Reports Services
  • Building Reports: Efficiency Guidelines

Oracle 9i DBA


Oracle DBA Certification is a valuable Industry recognised certification that signifies a proven level of knowledge & skills. The Oracle Workforce Development Program (WDP) is a initiative, where Oracle provides software curriculum, training and certification resources to educational institutions to deliver Oracle training as part of certificate and non-degree programs offered via Continuing Education. Oracle WDP program covers official Oracle curriculum and prepare you to Oracle Certified Professional(OCP) exam and other Oracle International Certification exams.

Introduction to Oracle 9i: SQL

Writing Basic SQL Select Statements Restricting and Sorting Data Single-Row Functions Displaying Data from Multiple Tables Aggregating Data using Group Functions Subqueries 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 Date Time Functions Enhancements to the Group by Clause Advanced Subqueries Hierarchal Retrieval

DBA Fundamentals - I

Oracle Architecture Components Getting Started with Oracle Server Managing an Oracle Instance Creating a Database Using Data Dictionary and Dynamic Performance Views Maintaining The Control File Maintaining Redo Log Files Maintaining Tablespaces and Datafiles Storage Structure and Relationship Managing Undo Data Managing Tables Managing Indexes Maintaining Data Integrity Managing Password Security and Resources Managing Users Managing Privileges Managing Roles Auditing Loading Data into a Database Using Globalization Support



DBA Fundamentals - II


Networking Overview Oracle Net Architecture Basic Oracle Net Server Side Configuration Naming Method Configuration Usage and Configuration of the Oracle Shared Server Backup and Recovery Overview Instance and Media Recovery Structure Configuring the Database Archiving Mode User-Managed Backups RMAN Backups / Maintenance User-Managed Complete Recovery RMAN Complete / Incomplete Recovery Recovery Catalog Creation & Maintenance Transporting Data between Databases Workshop

Performance Tuning

Overview of Oracle 9i Performance Tuning Diagnostic and Tuning Tools Sizing the Shared Pool Sizing other SGA Structures Sizing the Buffer Cache Database Configuration and I/O Issues Optimizing Sort Operations Diagnosing Contention for Latches Tuning Undo. Segments ' Monitoring and Detecting Lock Contention Tuning the Oracle Shared Server SQL Statement Tuning Using Oracle Blocks Efficiently Application Tuning Tuning the Operating System & Resource Manager Workshop Overview Project Work


Newsletter