Jurassic Institute of Management and Technology ORACLE (Application Development Track) Jurassic Institute of Management and Technology

Ministry Approved Certificate

Course Overview

(Oracle 10g- Introduction to SQL and PL/SQL
Course Contents:

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single Row Functions to Customize Reports
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data From Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the SET Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • Controlling User Access
  • Generating Reports by Grouping Related Data
  • Managing Data in Different Time Zones
  • Searching Data Using Advanced Sub queries
  • Hierarchical Data Retrieval
  • Introduction to PL/SQL Objects
  • Procedural Language
  • PL/SQL Blocks, Anonymous Blocks and Named Blocks
  • Creating PL/SQL Procedures and Functions
  • Understanding Triggers
  • Packages

Oracle 10g- Oracle Developer Forms 10g
Course Outline:

  • Introducing Oracle Forms Developer and Forms Services
  • Creating Forms Modules
  • Working with Data Blocks and Frames
  • Working with Input Items
  • Working with Non input Items
  • Creating Windows and Canvases
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run-Time Messages and Alerts
  • Query Triggers
  • Validation
  • Navigation
  • Transaction Processing
  • Writing Flexible Code
  • Sharing Objects and Code
  • Introducing Multiple Form Applications

Oracle 10g- Oracle Developer Reports

Course Outline:

  • Introduction to Oracle Reports Developer
  • Designing and Running Reports
  • Working in Oracle Reports Developer
  • Creating a Paper Report
  • Enhancing a Basic Paper Report
  • Managing Report Templates
  • Controlling the Paper Layout: Common Properties
  • Creating and Using Report Parameters
  • Embedding a Graph in a Report
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers

Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained  over 4,00,000 students.

See all Jurassic Institute of Management and Technology courses

IT, Computing and Technology Related Questions

Enquire about this course

You may add more courses here,
your list will be saved.

Rate our content