Previous   Next   Index

 

P381 - PROGRAMME ON DATA MANAGEMENT FOR GENISYS IMPLEMENTERS / I.T. OFFICERS 

(COMPANY SPECIFIC PROGRAMME FOR UNITED INDIA INSURANCE CO. LTD.)

 

Background:

 

United India Insurance Co. is at present using Client-Server environment for their day-today business transactions and consolidating the day-today business transactions through GEM server for business decision support. The current database platform is Oracle. Now, the company is in the process of migrating from Client-Server to Centralized Database System by implementing Core Insurance, using Microsoft technology. Hence, it is necessary for the users to know how to retrieve the data from Oracle database using Structured Query Language. Since Decision Support System is based on GEM, the users should know how to fetch the data in desired form, using Oracle Discoverer (Business Intelligence). It is also necessary for the users to know the migration of Oracle database to Microsoft platform through Open Database Connectivity (ODBC).

 

Objectives:

 

At the end of this programme participants will be able to:

  • Retrieve the data by using SQL and Oracle Discoverer
  • Migrating the oracle data into SQL platform

 

Contents:

 

·     Introduction to computer & database

·     Structured query language (SQL)

·     Oracle discoverer using GEM database

·     Open database connectivity (ODBC) – Migration of data from Genisys to Microsoft Access & Microsoft Excel.

·     Troubleshooting

Participants’ Profile:

Any participant having the flair of learning Information Technology and it’s application in General Insurance.

Duration:       1 week

 

Dates: I)  21.04.2008 - 26.04.2008

            II) 16.06.2008 - 21.06.2008

            III) 30.06.2008 - 05.07.2008

            IV) 04.08.2008 - 09.08.2008

            V)  15.09.2008 - 20.09.2008