|
 |
Individual & Students
IT Courses |
|
IT COURSES
|
 |
| |
 Course Schedule |
 Computers For Beginners |
Course Code |
B 01 |
| Duration |
1 month (Theory 40 Hours - Practical 40 Hours) |
| Prerequisite |
Nil |
| Objective |
This course will provide functional knowledge required to use a computer. |
|
|
Module |
Topics |
Hours |
1 |
Computer Overview
|
12 Hours |
| |
Computer Basics, parts of a computer and its functions |
|
2 |
Microsoft Windows
|
16 Hours |
| |
Functions of the Operating System, Introduction to MS window, Methods of managing and maintaining a computer, File management using MS Explorer. |
|
| 3
|
Internet |
16 Hours |
| |
Introduction to the Internet, How Internet works, Introduction to HTML / MS Front page, Creating your own Web Pages.. |
|
Total Hours |
44 Hours |
SCIT Evaluation policy: Practical examination |
|
|
| Programming For Beginners |
| Course Code |
S 03 |
| Duration |
3 month (Theory 120 Hours - Practical 120 Hours) |
| Prerequisite |
Experience with using a computer and MS Operating system OR completion of the course B 01 (Computers for Beginners) or equivalent.The course is design for the audience with no programming and databases knowledge. |
| Objective |
This course provides conceptual knowledge about programming and use of database. It also provides hands-on experience on VB MS Access. At the end of the course student will do a project. |
|
Module |
Topics |
Hours |
1 |
MS Visual Basic Programming
|
140 Hours |
| |
Features of Visual Basic, Programming Concepts, Logic Building, Basic and Advanced Controls, their properties, Events, Menus and Dialog Boxes, Error Handling, Text File Input/ Output, Database Handling Techniques - OLEDB, DSN, DAO, RDO, ADO, Introduction to COM and ActiveX dynamic link libraries, code components and ActiveX exe , ActiveX Controls. |
|
2 |
MS Access
|
80 Hours |
| |
Introduction to Database, Features of MS -Access, Setting Entity Relations in a Database, Creating Tables, Data Definitions using MS - Access, Setting Constraints in MS- Access table data, Updating data, Data Retrieval, Queries using MS - Access, Report Generations, Data Connectivity of MS Access with VB. |
|
3 |
Project
|
20 Hours |
Total Hours |
240 Hours |
SCIT Evaluation policy: Practical examination |
|
|
| Java Technology -Basic |
| Course Code |
S 04 |
| Duration |
3 month (Theory 120 Hours - Practical 120 Hours) |
| Prerequisite |
Experience in any programming language OR completion of the Course S 03 (Programming For Beginners) or equivalent. |
| Objective |
This course will prepare students for SCJP. Sun offers two exams at the programmer level - SCJP 1.4(Exam No. CX-310-035) and SCJP 1.2(CX-310-025).
SCJP 1.2 contains AWT while SCJP 1.4 includes assertions instead of AWT. |
|
Module |
Topics |
Hours |
1 |
OOP concepts
|
3 Hours |
| |
Features of Object Oriented Programming, Difference between non-OOP and OOP, Advantages of OOP |
|
2 |
Introduction to Sun Java
|
3 Hours |
| |
Features of Sun Java, Language Fundamentals, Operator and Assignments, Declaration and Access Control |
|
3 |
Sun Java Classes |
20 Hours |
| |
What are Object Classes - Boolean, Number, Void, Math, String, StringBuffer, Object Class Methods |
|
4 |
Inheritance |
20 Hours |
| |
Inheritance with default access, Inheritance with public and protected access, Inheritance with private access |
|
5 |
Sun Java Interfaces/Classes |
12 Hours |
| |
Interface Declarations, Interface Members, Field Declarations, Abstract Method Declarations, Member Type Declarations |
|
6 |
Graphics and Images |
12 Hours |
| |
How Graphics and Images are handled in Java |
|
7 |
I/O Handling |
10 Hours |
| |
|
|
8 |
Exceptions/Packages |
12 Hours |
| |
Causes of Exception, Compile Time checking of Exceptions, Handling of an Exception, Examples of Exceptions, The Exception Hierarchy |
|
9 |
Multithreaded Programming |
28 Hours |
| |
What is a Thread, Advantages of using Threads in a Java Program, Execution order of a Thread, what is multithreaded programming |
|
10 |
Streams & File Handling |
19 Hours |
| |
|
|
11 |
Applet Programming |
25 Hours |
| |
What is an Applet, Difference between an Application and an Applet, Execution of an Applet, Methods used in Applet class, classes and methods used in applet. |
|
12 |
AWT |
20 Hours |
| |
What is Abstract Window Toolkit, AWTs class hierarchy, their subclasses and is methods |
|
13 |
AWT Event classes |
10 Hours |
| |
java.util.EventObject super class, Some methods related to Events, AWT event classes, Event classes for GUI controls , Event Listeners |
|
14 |
Layout Managers |
|
| |
Different types of Layout Managers, their uses with examples |
9 Hours |
15 |
Collections |
10 Hours |
| |
What are Collections, How it's used. |
|
16 |
Assertions |
5 Hours |
| |
Why Assertions are used, how they are used |
|
17 |
Introduction to JDBC/RMI/JAVA-Beans |
22 Hours |
| |
|
|
Total Hours |
240 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| |
| Java Technology -Advanced |
| Course Code |
S 05 |
| Duration |
3 months (Theory 120 Hours - Practical 120 Hours) |
| Prerequisite |
Experience in java programming language and DBMS concept OR completion of the Course S 04 (Java-Basics) or equivalent. |
|
Module |
Topics |
Hours |
1 |
Multithreaded Programming
|
40 Hours |
| |
Thread Priorities, Synchronization, Inter-thread Communication |
|
2 |
Swing and VAJ
|
44 Hours |
| |
Basic Swing concepts, Using Visual Age for Java for application development |
|
3 |
Server Side Computing |
46 Hours |
| |
Servlets, Using Java Web Server, Understanding HTTP, Thin Client Computing, Three Tier Databases |
|
4 |
Enterprise Java Beans |
20 Hours |
| |
Component development with VAJ |
|
5 |
RMI |
30 Hours |
| |
What is RMI, Why need of RMI, Benefits of using RMI with various examples. |
|
6 |
Java database Connectivity |
30 Hours |
| |
What is JDBC, how it's connected to Oracle with examples |
|
7 |
CORBA |
30 Hours |
| |
|
|
Total Hours |
240 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| |
| Oracle 8i -Basic |
| Course Code |
S 06 |
| Duration |
3 months (Theory 120 Hours - Practical 120 Hours) |
| Prerequisite |
Experience in any programming language and basic knowledge about the Database system OR completion of SCIT's S 03 (Programming for Beginners) course or Equivalent |
| Objective |
This course prepares for the Oracle Application Developer's Certification Exam OCP 1ZO-001. |
|
Module |
Topics |
Hours |
1 |
Oracle Concepts.
|
22 Hours |
| |
What is an RDBMS? RDBMS concepts, Nonprocedural data access SQL, Concept of Client/server computing, direction, distribution, Overview of Oracle architecture ,Oracle files, System & User processes, Oracle memory, storage, System & data objects, Protecting your data, backup & recovery, distributed database. |
|
2 |
Types of Oracle Software installation
|
6 Hours |
| |
|
|
3 |
Oracle Tools & Utilities |
23 Hours |
| |
SQL plus, PL/SQL, Enterprise Manager, Oracle Net & Assistant, SQL Easy Net Configuration |
|
4 |
Oracle Instance |
10 Hours |
| |
|
|
5 |
Managing Schema Objects |
52 Hours |
| |
Tables, Partition, View, Synonyms, Sequence, Clusters, Schemas, Indexes |
|
6 |
Managing Privileges & Roles |
30 Hours |
| |
Types of privileges, Granting System Privileges, Granting Object Privileges, Creating & Granting Roles |
|
7 |
Managing Locks (Transaction Processing) |
20 Hours |
| |
Types of Locks, Monitor Locking Activity, Dead Locks |
|
8 |
PL/SQL |
55 Hours |
| |
Creating Variables, Anonymous, Blocks, Cursors, Exceptions, Triggers, Procedure, Functions, Packages |
|
9 |
Object Oriented Programming |
22 Hours |
| |
Object - Relation Approach, Creating & Using Objects, Nested Tables & Arrays, Collection & Records |
|
Total Hours |
240 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| |
| Oracle 8i -Advanced |
| Course Code |
S 07 |
| Duration |
3 months (Theory 120 Hours - Practical 120 Hours) |
| Prerequisite |
Oracle PL/SQL or completion of SCIT's S 06 (Oracle - Basics) course or equivalent. |
| Objective |
This practical foundation course is an essential toolkit for all Database Administrators covering the practical skills needed by the DBA to perform the Oracle database administration function within their enterprise. Suitable for Oracle Database Administrators, Oracle support Engineers.
This course prepares for the following OCP Exams:
Exam 1ZO-023 and Course: Oracle8i: Architecture and Administration
Exam 1ZO-024 and Course: Oracle8i: Performance and Tuning
Exam 1ZO-025 and Course: Oracle8i: Backup and Recovery
Exam 1ZO-026 and Course: Oracle8i: Network Administration |
|
Module |
Topics |
Hours |
1 |
Architecture and Administration
|
10 Hours |
| |
|
|
2 |
Managing Database
|
30 Hours |
| |
Parameter files (INIT,ORA), Oracle SID, Startup & Shutdown, Data Dictionary, Redo Log, Control Files, Trace & Alert file, Database models (No-Arc/Arc/Change) |
|
3 |
Managing Database Storage (Disk Space) |
40 Hours |
| |
Object storage - Oracle block, segments & extents, growth pattern, additionROWID, Storage clauses, Rollback segments, Table spaces, Temporary SegmentsAnalyzing storage, Estimating storage for table space. |
|
4 |
Managing Users |
42 Hours |
| |
Introduction, Users Needs( User wants/ User need/ User access/ User settings), User Authentication Methods (Password & OS Authentication), User Configuration Setup (Profiles/ Default & Temporary Database), Resources Management (Using Profiles/ Quotas ), User Database Accounts ( Create / Modify / Delete / Change ), Special Account Considerations |
|
5 |
Backup & Recovery |
42 Hours |
| |
Importance of Backups, Terminology, Requirements for Backups, Types of Backups ( Control File / Redo Log / Cold / Hot ), Alternative Backups Methods ( Offline Copy / Export / SQL * Loader), Types of dB Failure ( Table Space / Control file / Redo Logs / Archive Logs), Recovery Methods ( Cold / Full / Time-based / Cancel-based), Sample Database backup's Script ( Hot / Cold ) |
|
6 |
Performance Tuning & Optimizing |
42 Hours |
| |
Concepts in database tuning (Application / Database / OS ), Performance Tools (Viewing SGA / Parameter Settings, SQL * Trace ), Tuning Database SGA(Examining SGA / Changing SGA), Contention Issues (I/O Contention & Load Balancing, Redo log Contention, Checkpoints), Database Objects (Tables & Indexes / Views / Triggers ), Database Locking ( Types & Classes of Locks, Checking Locking) |
|
7 |
Database Security |
32 Hours |
| |
Authentication, Why Protect Password ( Control / Protection / Integrity), Privileged Accounts ( SYS / SYSTEM / O.S Group DBA), Object Vs System Security, Object Security model (Object ownership / Capacity planning ), Defining Database Roles ( Create / Modify / Set (user / System) Roles), Database Auditing (Statement / Object level auditing, Audit trial) |
|
| |
Types of Locks, Monitor Locking Activity, Dead Locks |
|
8 |
Network Administration |
10 Hours |
Total Hours |
240 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| |
| Networking Fundamentals (3 Months) |
| Course Code |
N 01 |
| Duration |
3 months (Theory 120 Hours - Practical 120 Hours) |
| Objective |
This course will deliver the knowledge in the area of computer hardware, Operating system and Internet Basics. This course is designed for the beginner, who wants to pursue their carrier in the Computer Networks and work as a Network administrator. The course provides functional understanding of various networking devices and their roles in the computer network. This also focuses on various Internet services and protocols which are commonly used. With hands on experience student will be able to configure, administer and mange servers.
Depending upon the requirement this course can be delivered on Microsoft or Linux Platform. |
| Prerequisite |
Experience with using a computer and MS Operating system OR completion of the course B 01 (Computer Basics) or equivalent.
|
|
Module |
Topics |
Hours |
1 |
Computer Overview
|
20 Hours |
| |
Introduction to various parts of the computer and functions.
Assembling of the computer
Geometry of the Hard disk
Introduction to Bootloader, partitions, Format |
|
2 |
Introduction to Computer Networks
|
20 Hours |
| |
Benefits of the network
Various types of the Network
Network Model - OSI
Media and devices
Topology |
|
3 |
Network Operating system
|
40 Hours |
| |
Introduction to Operating system and its functions
Installations of the Network operating system
Configuration of various devices |
|
4 |
Introduction to Internet
|
45 Hours |
| |
Configuration of Modem
Configuration of Dial-up connection
Accessing Internet |
|
5 |
Building LAN
|
45 Hours |
| |
Introduction to devices required to build LAN
Cables and crimping
Network protocols
Sharing of resources
Configuration of servers. |
|
6 |
Introduction to TCP/IP suite |
35 Hours |
| |
|
|
7 |
Introduction to network devices |
35 Hours |
| |
Hub/ Bridge
Switch/ Router |
|
| |
|
|
Total Hours |
240 Hours |
|
|
|
| Red-Hat Linux for Beginners |
| Course Code |
N 02 |
| Duration |
1 month (80 Hours) |
| Prerequisite |
Experience of using a computer and a web browser OR Completion of SCIT's B 01 (Computer Basics) course or equivalent. |
| Objective |
This course will give basic knowledge about the Linux Operating System and hands-on lab work.
|
|
Module |
Topics |
Hours |
1 |
Features of Linux
|
5 Hours |
| |
a. Introduction to Open source
b. Advantages and disadvantages
c. Hardware requirement
Distributions |
|
2 |
Installation of Linux OS
|
20 Hours |
| |
a. Boot loader - LILO / GRUB
b. Partition table
c. Installation methods for Server, Custom & Workstation |
|
3 |
Basic Commands |
25 Hours |
| |
a. Vi editor
b. Linux commands
c. Mounting of devices
d. File Systems
e. Process Management commands |
|
4 |
Linux desktops |
5 Hours |
| |
a. Gnome
b. KDE |
|
5 |
Introduction to Open Office |
5 Hours |
| |
|
|
6 |
Introduction to Shell Programming |
20 Hours |
| |
|
|
Total Hours |
80 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| Red-Hat Linux System and Networking Administration (Preparatory Course) |
| Course Code |
N 03 |
| Duration |
3 month (240 Hours) |
| Prerequisite |
Experience with using a computer and Exposure to Linux operating system is required OR Completion of SCIT's N 02 (Red Hat Linux for beginners) or equivalent.
|
| Objective |
Preparatory course for RedHat Certification. |
|
Module |
Topics |
Hours |
1 |
User Administration and File System Management
|
30 Hours |
| |
|
|
2 |
Booting procedure of the Linux Operating System
|
10 Hours |
| |
|
|
3 |
System Administration tools |
10 Hours |
| |
|
|
4 |
Kick Start |
5 Hours |
| |
|
|
5 |
Kernel configuration |
5 Hours |
| |
|
|
6 |
Network Configuration |
10 Hours |
| |
|
|
7 |
Windows and Linux connectivity - SAMBA |
10 Hours |
| |
|
|
8 |
Configuration Of Internet Server |
120 Hours |
| |
BIND/Web Server - Apache/FTP/DHCP/Mail server
Proxy/NFS/NIS
Hands-on Lab |
|
9 |
Network level security |
40 Hours |
|
i. IP tables
ii. Hands-on Labs |
|
Total Hours |
240 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| |
| MCSE I-VII (Preparatory Course) |
| Course Code |
N 06 |
| Duration |
6 months. (480 Hours)
|
| Prerequisite |
Hands-on experience on MS Windows platform and familiarization to networking OR completion of SCIT's N 01 (Networking Fundamentals) course. |
| Objective |
Preparatory course for MCSE, MCP certifications. |
| Certification Details |
MCP: Passing any exam listed in Topics makes you a Microsoft Certified Professional (MCP). MCSE: All seven papers have to be cleared. |
|
Module |
Topics |
Hours |
1 |
Four core networking exams
|
204 Hours |
| |
Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment
Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
Exam 70-293: Planning, Maintaining a Microsoft Windows server 2003 Network Infrastructure.
Exam 70-294: Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
|
|
2 |
Core Exam: Client operating system
|
80 Hours |
| |
Exam 70-210: Installing, Configuring, and Administering Microsoft Windows 2000 Professional |
|
3 |
Core Exam: Design |
80 Hours |
| |
Exam 70-298: Designing Security for a Microsoft Windows Server 2003 Network |
|
4 |
Elective exam |
80 Hours |
| |
Exam 70-227: Installing, Configuring, and Administering Microsoft Internet Security and Acceleration (ISA) Server 2000, Enterprise Edition. |
|
Total Hours |
480 Hours |
SCIT Evaluation policy: For each paper separate evaluation will be conducted. Theory paper & Practical examination |
|
| |
| N 07 :: CISCO (CNNA Preparatory Course) |
| Course Code |
N 07 |
| Duration |
3 month (240 Hours) |
| Prerequisite |
Hands on experience on any network operating system and familiarization to networking Or completion of the course N 01 (Networking Fundamentals). |
| Objective |
Preparatory course for CCNA certification |
| Certification Details |
For obtaining CCNA certification two options are provided by Cisco while the topics remain the same:
- Exam No. 640-801 or
- Exam No. 640-811 & 640-821
|
|
Module |
Topics |
Hours |
1 |
Internetworking
|
6 Hours |
| |
OSI Model, Ethernet Networking, Ethernet cabling, Cisco model
|
|
2 |
Internet Protocol
|
14 Hours |
| |
TCP/IP model, DoD model, IP addressing, NAT |
|
3 |
IP Sub-netting and VLSM |
10 Hours |
| |
Subnetting Basics, Subnet Masks, CIDR, VLSM |
|
4 |
Introduction to Cisco IOS |
10 Hours |
| |
Configuration of IP addresses and subnet masks, and gateway addresses on routers and hosts, Configuration of a switch, Implementation of a LAN, Configuration of a router, Hand-on Labs |
|
5 |
IP Routing |
30 Hours |
| |
Design a simple LAN using Cisco Technology, Design an IP addressing scheme to meet design requirements, Select an appropriate routing protocol based on user requirements, Design a simple internetworking using Cisco Technology, Configuration of IP addresses and subnet masks, and gateway addresses on routers and hosts, Hand-on Labs |
|
6 |
Enhanced IGRP and OSPF |
20 Hours |
| |
EIGRP features & Operations, Configuration of EIGRP, OSPF Basics, Configuration of OSPF, Configuration of routing protocols as per user requirements, Hands-on Labs |
|
7 |
Layer 2 switching |
20 Hours |
| |
Spanning Tree Protocol, LAN switch types, Hands-on Labs |
|
8 |
VLAN |
20 Hours |
| |
VLAN Basics, Configure a switch with VLANS and inter-switch communication, Implement a LAN, Customize a switch configuration to meet specified network requirements, Hands-on Labs. |
|
9 |
Managing Cisco Internet-works |
30 Hours |
| |
The internal components of a Cisco Router, Router Boot Sequence
Managing system image and device configuration files, Utilize the OSI model as a guide for systematic network troubleshooting, Perform LAN and VLAN troubleshoot, Troubleshoot IP addressing and host configuration.
Hands-on Labs |
|
10 |
Managing Traffic with Access List |
40 Hours |
| |
Develop an access list to meet user specifications, Implement access lists
Troubleshooting an access list, Evaluate rules for packet control,
Hands-on Labs |
|
11 |
Wide Area Networking Protocols |
40 Hours |
| |
Introduction to various WAN protocols (ISDN, PPP, HDLC, Frame Relay), Choose WAN services to meet customer requirements, Implementation of Simple WAN protocols, Perform Simple WAN troubleshooting, Evaluate key characteristics of WANs, Hands-on Labs |
|
Total Hours |
240 Hours |
SCIT Evaluation policy: Theory paper & Practical examination |
|
| Webpage Design (3 Months) |
| Course Code |
W 01 |
| Duration |
3 months (Theory 120 Hours - Practical 120 Hours) |
| Objective |
To create, format and publish a small website using HTML. In this course students will learn to create web pages incorporating formatted text, images, hyperlinks and tables. They will also learn the basics of publishing and registering the site on the World Wide Web. |
| Prerequisite |
Experience with using a computer and a web browser is required OR Completion of B 01 (Computer Basics) or equivalent.
The course is designed for the audience with no knowledge about HTML. |
|
Module |
Topics |
Hours |
1 |
Introduction to the programming and logic building
|
35 Hours |
| |
|
|
2 |
HTML
|
85 Hours |
| |
Introduction to HTML
Introduction to Web design
The structure of HTML document
Document type declarations
The Head element
The HTML body
Text level elements
HTML body: Hyperlinks |
|
3 |
MS Front Page |
22 Hours |
| |
Designing and editing web pages |
|
4 |
JavaScript overview |
65 Hours |
| |
Introduction to Scripting
Variables, Data-types
Operators
Statements, functions and events |
|
5 |
Internet Basics |
33 Hours |
| |
Introduction to World Wide Web /URL
Familiarization with Web Server
Familiarization with DNS Server |
|
| |
|
|
Total Hours |
240 Hours |
SCIT Evaluation policy: Final evaluation will be of 200 points. Theory paper (Descriptive) of 100 points & Practical examination of 50 points will be conducted. Assignments will have 50 points. |
|
|
|
|
 |
 |
 |
|
Japan to India |
|
IT Study Abroad Program |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
