WEEK 1

DAY 1

3

IT ASSISTANT COURSE

·         Inauguration Ceremony

·         Registration of Participants

·         Distribution of Training Kits and Lesson Plan

·         IT Awareness Paper (Screening Test)

Computer Fundamentals

   Evolution of Computers

   Computer Generations

·       First Generation Computers

·       Second Generation Computers

·       Third Generation Computers

·       Fourth Generation Computers

DAY 2

4

   Overview of Computer Organization

·   Primary & Secondary Storage

·   Input-Output Devices

·   Operating Systems

·   File Organizations

   Computer Software

   Overview of Data Communication & Computer Networks

  Information Technology & Society

   I.T. Organizations

DAY 3

PC Hardware

   Computer Introduction,

   Operating Systems,

   Booting,

   Motherboards,

   Processor,

DAY 4

   Interface Card and Slot,

   RAM, ROM, BIOS,

   Elementary of DOS

   Peripherals (HDD, FDD, Keyboard, Mouse, Monitor, CD ROM, SMPS).

DAY 5

   Assembling of Computer System,

   Hard disks Partitions,

   File systems,

   HDD Formatting,

   Installing printer,

   Types of printer,

   Difference between local printer and Network printer

DAY 6

Module Test, Viva & Modular Feedback

(Computer Fundamentals and PC-Hardware)

Computer Networks

Introduction to Internetworking

·                     Networking Basics

·                     Networking media, cables & connectors

·                     Types of Networks

·                     Protocols

·                     OSI reference model

WEEK 2

DAY 1

TCP/IP Protocols & addressing

·         TCP/IP Model

·         What is TCP/IP protocol

·         Comparison of OSI layer and TCP/IP suite

·         What is Network Addressing

·         Functionality of IP, TCP, UDP, ICMP protocols

·         Understanding FTP, Telnet, SMTP, SNMP – upper layer protocols

DAY 2

IP Addressing

   IP addressing scheme

   Classful Addressing

DAY 3

Subnetting

·         Subnetting fundamentals

·         Subnetting in Class A, B & C

DAY 4

Module Test, Project/Viva & Modular Feedback

(Computer Networks)

DAY 5

5

Programming In C

   Introduction To Programming Concepts

   Programming Paradigms

   Overview of C

   Writing Simple C Programs

   Data Types, Operators, and Expressions

DAY 6

6

   Control Structures & Decision Making I

·         If construct

·         If-else construct

·         Switch-Case

   Control Structures & Decision Making II

·         While Loop

·         Do-while Loop

·         For Loop

WEEK 3

DAY 1

7

   Functions                                                                 

   Methods of Calling a Function

·         Call by value

·         Call by reference

·         Call by address

DAY 2

8

   Arrays

   Strings

DAY 3

10

   Pointers

DAY 4

11

   Structured Data Types

·         Structures

·         Unions

·         Enumeration

DAY 5

12

   File Handling

   Operations on Files

   Operations on Files

DAY 6

14

Module Test, Project/Viva & Modular Feedback

(C-Programming)

WEEK 4

DAY 1

Database Management & MS Access

   Overview of Database Management Systems

·         Databases and Database Users

§  Introduction

§  Characteristics of Database Approach

§  Actors on the Scene

§  Workers Behind the Scene

§  Advantages of Using DBMS

·         Implications

DAY 2

   Database System Concepts and Architecture

·         Data Models, Schemas, and Instances

·         Architecture and Data Independence

   Data Modeling Using Entity-Relationship Model

·         High-level Conceptual Data Model

·         Entity Types, Entity Sets, and Attributes and Keys

·         Relationships, Relationship Types, Roles and

                                                         Constraints

DAY 3

·         ER-Diagrams                                       

·         Normalization

DAY 4

MS Access

   Introduction

·       Microsoft Access

·       Data Sheets

·       Forms & Reports

   Database Fields on Sheets

   Managing Data Fields

   Data Fields on Forms & Reports

   Data Filed Design

·         Properties of Data Fields

DAY 5

   Operators & Operands

   Introduction to Data Types

·         Using Data Types

·         Introduction to Relationships

   Managing Relationships

   Referential Integrity

   Introduction to Data Analysis

   Structured Query Language

·         Queries & Relationships

   Exploring Data Analysis

   Data Analysis With Charts

DAY 6

   Formatting Charts

   Action Queries

   Data Maintenance, Import / Export

   Tables & Queries Aesthetics

   Characteristics of Forms

   Windows Controls

   Types of Forms

   Sub Forms

   Introduction to Expressions

   Controls & Expressions

WEEK 5

DAY 1

   Built-in Functions

   Series-based Functions

   Macros

   Subroutines

   Reports

Module Test, Project/Viva & Modular Feedback

(DBMS & MS-Access)

DAY 2

Oracle 9i – SQL, Pl/SQL

    Structured Query Language (SQL)

• Introduction

• Restricting and Sorting Data

• Single Row Functions

• Displaying Data from Multiple Tables

DAY 3

·         Writing Subqueries

• Producing Readable Output with iSQL*Plus

• Manipulating Data

DAY 4

• Creating and Managing Tables

·         Including Constraints

·         Creating Views

DAY 5

• Enhancements to the GROUP BY Clause

• Other Database Objects

• Using Set Operators

DAY 6

   Programming Language/ Structured Query Language (Pl/SQL)

·         Introduction to Pl/SQL

·         Cursors

WEEK 6

DAY 1

• Creating Procedures

• Creating Functions

DAY 2

• Creating Triggers

DAY 3

   Oracle 9i Architecture & Database Administration

·       Oracle Database architecture

·       Oracle instance

·       Tablespaces

·       Data files

·       Log files

·       Control files

·       Oracles processes

DAY 4

• Managing the physical database structure

  • Managing control files

  • Maintaining redo log file

    • Controlling log switches and checkpoints

    • Multiplexing and maintaining redo log files

·         Sizing data, control files and log files

·         Archive log and no archive log

·         Using Database Configuration Assistant to create a database

DAY 5

• Tablespaces

• Tablespaces and Datafiles

• Type of tablespaces (Permanent,Temporary,Undo)

• Undo tablespace management

• Tablespace(offline,online,read only, read write)

• Resizing of tablespace

• Adding datafile to a tablespace

• Dropping tablespace

DAY 6

• Users, Roles and Privileges

• Creating new database users

• Identifying system and object privileges

• Granting and revoking privileges

• Creating roles and assigning to users

WEEK 7

DAY 1

• Backup and Recovery

  • Describing the basics of database backup, restore and recovery

  • Listing types of failures that may occur in an oracle environment (including recovery from these errors).

  • Defining backup and recovery strategy

  • Multiple archival destinations and processes

  • Identifying the importance of checkpoints, redo log files and archived log files

• Offline backup

• Online backup

DAY 2

• Backup and Recovery

  • Recovery manager

  • Catalogue management

  • Configuring and using recovery management

DAY 3

•      Backup and Recovery

  • Logical backups

    • Export

    • Import

§  SQL Loader

DAY 4

Module Test, Project/Viva & Modular Feedback

(Oracle-9i SQL,PL/SQL & DBA)

DAY 5

Introduction To Linux, Viruses (Effects & Protection)

   Linux Ideas and History

   Red Hat Enterprise Linux Introduction

   Red Hat Enterprise Linux Installation

DAY 6

   Running Commands and Getting Help

   Browsing the File system

WEEK 8

DAY 1

   Using the bash Shell

   Standard I/O and Pipes

   Investigating and Managing Processes

DAY 2

   Users, Groups, and Permissions

DAY 3

   vim: An Advanced Text Editor

DAY 4

   Introduction to Viruses and its Effects

   Protection Methods Against Viruses

DAY 5

Open Office With Linux

   Introduction of Open Office Writer Module

   Editing Text & Working with Objects

   Customizing text documents

DAY 6

   Introduction the Open Office Calc Module

   Working with Formulae and Functions

WEEK 9

DAY 1

   Managing Data

   Enhancing Spread sheets

   Format Setting

DAY 2

   Working with Charts

   Enhancing Charts

DAY 3

Module Test, Project/Viva & Modular Feedback

(Linux and Open Office)

DAY 4

Windows 2003 Basic & Advanced Administration

   Introduction to Windows Family Operating Systems

   Loading, Installing, Setting up and Trouble Shooting

   Versions of Windows Server 2003

DAY 5

   DNS (Domain Name Server)

• Configuration

• Zone Transfers

• Forwarders

• DNS Backups

DAY 6

   DHCP (Dynamic Host Configuration Protocol)

• Configuration

• Reservation

• DHCP Backup

WEEK 10

DAY 1

   ADS (Active Directory Service)

• Installation & Un-installation

• ADS Backup

DAY 2

   User Management in Windows 2003

   User Profiles

   OU, Group Policy, Auditing

DAY 3

   Group Management

   Quota Management

   Registry

DAY 4

   IIS (Internet Information Service)

DAY 5

   Exchange Server

DAY 6

   Backup & Restoring Data

WEEK 11

DAY 1

   MMC (Microsoft Management Console)

·         DFS (Distributed File System)

·         EFS (Encrypted File System)

·          

DAY 2

   Software Deployment

   Printer Management

   File Server

   Remote Desktop Connection

DAY 3

   Module Test, Project/Viva & Modular Feedback

(Windows)

DAY 4

Web Designing

   Introduction to Web-Designing I

·   HTML (Hyper-text Markup Language)

·   Basic Tags

·   Hyper-linking

DAY 5

   HTML (Hyper-text Markup Language)

·   Working with Images

·   Working with Tables

·   Working with Forms

DAY 6

        Cascading Style Sheets

WEEK 12

DAY 1

   Introduction to Web-Designing II

·   JavaScript

·   Introduction to Scripting

·   Client-Side v/s Server-side Scripting

·   Loops

DAY 2

   JavaScript

·   Arrays

·   Functions

DAY 3

Module Project/Viva & Modular Feedback

(Web Designing)

DAY 4

Microsoft .NET

Object Oriented Concepts

   Introduction to Object Oriented Programming Concepts,

   Classes, Objects, functions.

   Principles of OOD: Encapsulation, Polymorphism, Inheritance

DAY 5

   Concepts of constructor and destructor,

   Operator Overloading

DAY 6

Microsoft .NET

   .NET Overview,

   .NET Framework,

   MSIL ( Microsoft Intermediate Language ),

   CLR ( Common Language Runtime )

WEEK 13

DAY 1

C#

   Overview of C# ,

   Classes & Objects,

   Inheritance

DAY 2

   Properties,

   Memory Management.

DAY 3

   Delegates,

   Event Handling

DAY 4

   Window Forms,

   Generics,

   Assemblies

DAY 5

ASP.NET

   Introduction to ASP.NET

DAY 6

   Web Server Controls

WEEK 14

DAY 1

   Controls Contd.

DAY 2

   Controls Contd.

DAY 3

   Master Pages,

   Site Navigation

DAY 4

   State Management

DAY 5

ADO.NET

   Managed Providers,

   ADO.NET Objects,

DAY 6

   The Connection Object ,

   The Command Object and DataReader

WEEK 15

DAY 1

   The Dataset and DataTable Objects

DAY 2

Module Test, Minor Project & Modular Feedback

(Microsoft .NET)

DAY 3

Final Project Work

DAY 4

Final Project Work

DAY 5

Final Project Work

DAY 6

Final Project Work

WEEK 16

DAY 1

Final Project Work

DAY 2

Final Project Work

DAY 3

Final Project Work

DAY 4

Final Project Work

DAY 5

Final Project Work

DAY 6

Final Project Work

WEEK 17

DAY 1

Final Project Work

DAY 2

Final Project Work                      

DAY 3

Final Project Work                      

DAY 4

Final Project Work

DAY 5

Project Submission and Viva

DAY 6

Certificate Distribution & Valedictory Session

(End of Course)