Ultra Spectra

Oracle Certification


sponsored certification

Ministry of Information Technology


Ok, now I am going to upload the summary of each day’s lecture here. The notes are available online (will put up the link as well). Just keep looking for the latest buzz in the course. I am sure that’ll gona be a smart course for the interested people.

Course Outline:

Session 01~ DBMS Concepts

  • Day 01~           Introduction to DBMS
  • Day 02~           Payroll System

Session 02~ SQL 10g

  • Day 03~           Retriving Data using SQL, Restring and Sorting Data
  • Day 04~           Using Simple Row Functions
  • Day 05~           Using Group Functions

Day 06~ Workshop 01

  • Day 07~           Joins
  • Day 08~           Sub Query Concepts
  • Day 09~           Data Definition Language

Day 07~ Workshop 02

  • Day 11~           Data Manipulation Language
  • Day 12~           Constraints
  • Day 13~           DBA Activities

Day 14~ Workshop 03

Session 03~ PL/SQL 10g

  • Day 15~           Introduction to Programming Languages
  • Day 16~           Interacting with Oracle Server
  • Day 17~           Control Structures in PL/SQL

Day 18~ Workshop 04

  • Day 19~           Basic Loops
  • Day 20~          Cursors and Records
  • Day 21~           Exception Handling

Day 22~ Workshop 05

  • Day 23~           Procedures and Functions
  • Day 24~           Triggers Concepts

Day 25~ Workshop 06

Session 04~ Oracle Form Developer 10g

  • Day 26~           Introduction to Oracle 10g Form Developer/Working in Form Environment
  • Day 27~           Creating Basic Form Module
  • Day 28~           Creating Master detail Forms/Working with Block and Frames

Day 29~ Workshop 07

  • Day 30~           Working with Text Items
  • Day 31~           Creating LOV’s
  • Day 32~           Creating Input and Non-Input Items

Day 33~ Workshop 08

  • Day 34~           Canvas Types
  • Day 35~           Associate Triggers in Forms Triggers
  • Day 36~           Validation + Alerts

Day 37~ Workshop 09

Session 05~ Oracle 10g Reports

  • Day 38~           Introduction Tabular and Group Reports
  • Day 39~           Master Detail Resports, Summary Reports and Formula Reports
  • Day 40~           Parametrized Reports and Report Triggers

The certification completed with a one week extention time for real time development of a Student management system module.

1 Response to "Oracle Certification"

Bold = Topics Done

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

My Gravatar

Ultra Spectra is a personal interest blog for publishing news articles, sharing interesting information or the research.

UltraSpectra’s Blogging World



Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 7 other followers

Share this Blog

Bookmark and Share


Tell a Friend
October 2018
« Jul    

RSS UltraSpectra’s RSS

  • An error has occurred; the feed is probably down. Try again later.

My Twtter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

Blog Stats

  • 130,078 Visits

Top Clicks

  • None
%d bloggers like this: