Ultra Spectra

Oracle Certification


emblem

sponsored certification

Ministry of Information Technology

ORACLE 10g

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ 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

UltraSpectra

UltraSpectra

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

Subscribe

Tell a Friend
May 2017
M T W T F S S
« Jul    
1234567
891011121314
15161718192021
22232425262728
293031  

RSS UltraSpectra’s RSS

  • CISA Training – Schedule
    UltraSpectra (Pvt.) Ltd. bring to you specially designed courses for Certified Information Systems Auditor (CISA) Examination. Program Overview Certified Information Systems Auditor (CISA®) is an audit professional certification sponsored by the Information Systems Audit and Control Association (ISACA). CISA® course certification demonstrates one’s exception […]
  • Job Opening
    Job Description: UltraSpectra Pvt. Ltd. immediately requires highly talented and experienced PHP Developer and Designer with good communication skills and a proven track record in PHP Development. As a PHP Developer, you will be required to work in PHP, MySQL & AJAX. Minimum 2 years of experience or strong project portfolio in Web Development. Qualificat […]
  • Tips For Post Event Engagement With Your Attendees
    Successful marketing plays a vital role in making the event organized be remembered. If the brand managers only rely on conducting a huge scale event for their brand promotion and forget what needs to be done afterwards, then the show was of no use. Following are some tips for your event attendees to remember the

My Twtter Updates

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

Blog Stats

  • 129,629 Visits

Top Clicks

  • None
%d bloggers like this: