International Centre for Information Systems and Audit A-52,

Sector 62, Institutional Area, Noida.

Course on “Data Downloading” (6th to 10th July, 2009)

Course Schedule

Day	Session I ( 10.00 AM to 11.15 AM)	Session II (11.30 To 1.00 PM)	Session III (2.00 PM to 3.30 PM)	Session IV ( 3.45 PM to 5.00 PM)
6/07/2009 Monday	Text Files, Data Representation, ASCII Files Introduction to Windows XP Import/Export – Concept Excel Files/Access Files, CSV Format etc.Under-standing Flat Database (COBOL)Character/Field/Record/Database Dbase –V :: Import from Text files and Export to Text Files, SDF Format, Delimited Format, Taking Backup Case Study. Faculty: M/S NETSOFT
07/07/09 Tuesday	Working with Visual FoxPro Similarities between dBase and Visual FoxPro Import from Text files and Export to Text Files SDF Format, Delimited Format, Taking Backup Understanding SQL Server 2000Enterprise Manager SQL Overview Data Backup and Restore Import Data from Text Files Export Data to Text Files Import from Dbase Export to Dbase Selective Export Selective Import Introduction to ODBC Import and Export using ODBC Case Study-Scenario. Faculty: M/S NETSOFT
08/07/09 Wednesday	Import from Dbase Export to Dbase Understanding SQL Server 2008SQL Server Management Console Data Backup and Restore Import/Export to/from SQL Server 2000Introduction to DB2Working in Control Centre Export and Export in DB2 Receiving Data from dBase, Visual FoxPro, Txt Files Sending Data to dBase, Visual FoxPro, Txt Files. Faculty: M/S NETSOFT
09/07/09 Thursday	Introduction to Linux Learning Basic Commands in Linux Mkdir, cd, ls, ll, rm, cp, clear, cal, tar, bzip, mkfs etc. Converting a Unix/Linux file to DOS formatDB2 on Linux Introduction to Sybase Working in Sybase Central Export and Export in Sybase Receiving Data from dBase, Visual FoxPro, Txt Files Sending Data to dBase, Visual FoxPro, Txt Files Sybase on Linux Bcp Command. Faculty: M/S NETSOFT
10/07/09 Friday	Working with Oracle Working with SQL PLUS Import and Export in Oracle Imp command Exp command Taking Backup of Oracle Database Restoring Database from Backup Understanding Different Database Formats XML Format Using XML to Represent a Database Advantages of using XML Limitations of using XML Case Study-Scenario on Oracle and XML. Faculty: M/S NETSOFT

Registration: 9:00 AM to 10:00 AM, Tea Break: - 11:15 – 11:30 AM & 3:30 – 3:45 PM, Lunch Break: - 1.00 PM – 2.00 PM