International Centre for Information Systems and Audit, (iCISA)

 

            Office of the Comptroller and Auditor General of India,

 

       A-52, Sector 62, Noida – 201301 (UP), India

 

 

 

                                                                                         

 

 

 

 

 

            Training Programme on

 

“DATA DOWNLOADING”

 

For SAI OMAN

 

(19th October to 31st October 2009)

 

 

                                                                                                   

 

First Week

 

Date & Days

Session 1

1000 – 1115  Hrs.

Session 2

1145 – 1300 Hrs.

Session 3

1400 – 1515

\Hrs.

Session 4

1545 – 1700 Hrs.

 

19th Oct, 2009

Monday

Introduction , writing SQL statements

Ms. Amita Anand

Restricting and Sorting Data

Ms. Amita Anand

Using Single Row Functions

Ms. Amita Anand

Group Functions

Ms. Amita Anand

20th Oct  2009

Tuesday

Joins

Ms Amita Anand

Subqueries

Ms Amita Anand

Set Operators

Ms Amita Anand

Manipulating Data

Ms Amita Anand

21st  Oct .2009

Wednesday

DDL Statements

Ms. Amita Anand

Schema Object

Ms. Amita Anand

Managing Data

Ms. Amita Anand

Controlling User Access

Ms. Amita Anand

22nd Oct .2009

Thursday

Manage Schema Objects, LOBs

Mr. Asif Husain Khan

Adv Group by Clause, Managing data in different time zone

Mr. Asif Husain Khan

Adv  Subqueries

Mr. Asif Husain Khan

Hierarchial Retrival, Regular Expressions

Mr. Asif Husain Khan

23rdOct,2009

Friday

Ways of Moving Data, create and use directory objects

SQL Loader

Data Pump, Import export

Data Pump, Import export

24th Oct ,2009

Saturday

Agra Visit

25th October ,2009

Sunday

Delhi  Visit

Tea break 11:15 am to 11.45 am,   Lunch break 1.00 pm to 2.00 pm,   Coffee break 3.15 pm to 3.45 pm

 

 

 

 

 

 

                                                           

Second Week

 

 

Date & Days

Session 1

1000 – 1115  Hrs.

Session 2

1145 – 1300 Hrs.

Session 3

1400 – 1515

\Hrs.

Session 4

1545 – 1700 Hrs.

 

26th Oct, 2009

Monday

Overview of Excel

Overview of Access (1400 – 1700 Hrs.)

Data download Case of Access (1700-1900 Hrs. with tea break of 1800 Hrs. )

K.P. Singh, S C Nathani, IT Audit Wing,

O/o the C&AG of India

G. Srinivas

Director (GASAB/IS) O/o the C&AG of India

27th Oct, 2009

Tuesday

Data download Exercise / Case of Excel

Overview of IDEA

K.P. Singh, S C Nathani,IT Audit Wing,

O/o the C&AG of India

Neelesh Kr. Sah, Director & S Murali Krishnan AAO (IT Audit)

O/o the C&AG of India

28th Oct, 2009 Wednesday

Introduction to SAP

 

History of SAP and

SAP R/3 Architecture

 

Mr. Ranjit Kumar

Mr. Ranjit Kumar

29th Oct, 2009

Thursday

SAP R/3modules

Module FI, CO, SD, MM, PP, QM, PS

 

Module HR: Industry Solutions

SAP Product Over view

 

Mr. Ranjit Kumar

Mr. Ranjit Kumar

30th Oct, 2009

Friday

SAP Organizational units

 

Navigation

Data Extraction using MIS

 

Mr. Ranjit Kumar

Mr. Ranjit Kumar

31st Oct, 2009

Saturday

Data download Exercise/ Case of Excel

Valediction

Mr. S. Murali Krishnan, IT Audit Wing

O/o the C&AG of India

S.K. Bahri, DG (iCISA)/

Santosh Kumar, Director (iCISA)