This module provides the fundamental concepts and terminologies related to computer software, operating systems and software. In addition, this module covers the different types of applications currently being used. It expounds on why the essential knowledge and discipline is required for all phases of the software development life cycle.

1. Computer Hardware vs Computer Software
2. Understanding of Operating System and Types
3. Windows and DOS
4. Mac OS X
5. Linux

This module provides the fundamental concepts and terminologies related to computer software, operating systems and software. In addition, this module covers the different types of applications currently being used. It expounds on why the essential knowledge and discipline is required for all phases of the software development life cycle.

1. Computer Software Usages in our life
2. Types of Computer Software and Application Architecture
3. Introduction to Standalone Application
4. Introduction to Client Server Application
5. Introduction to Web Application / Web Site
6. Introduction to Cloud Application

This module provides the fundamental concepts of networking and the keywords related to inter connected computers. In addition, this module covers Internet concepts and all the keywords related to the Internet. It expounds on why essential knowledge and discipline is required for all phases of the development life cycle.

Main Topics Covered:

1. Networking Basics
2. Brief history of computers and networks
3. What is a LAN, WAN and MAN?
4. Understanding the OSI Reference Model
5. Network Cards
6. Hubs, Bridges, Switches, Routers
7. Firewalls
8. Understanding Networking Protocols
9. IPv4 (formerly known as TCP/IP)
10. Planning for your addressing needs

This module provides the fundamental concepts of networking and the keywords related to inter connected computers. In addition, this module covers Internet concepts and all the keywords related to the Internet. It expounds on why essential knowledge and discipline is required for all phases of the development life cycle.

Main Topics Covered:

1. Understanding an IP address and subnet mask
2. What is the default gateway?
3. Configuring IP addresses on your network
4. Name Resolution Technologies
5. Host File
6. What is DNS?
7. Domain names
8. Top-level domains (TLDs)
9. What is the Intranet and Internet?
10. How does the Internet Work?

This module provides the fundamental concepts of terminology of HTML, DHTML and familiarity with the browser terminology. Students will learn the structure and syntax of HTML, including cascading style sheets, dynamic Web pages using JavaScript and DHTML, and the creation and use of XML documents. The course also reviews formatting text, incorporating graphics, adding interactive forms, creating tables, advanced Web page structuring, and Web page design. Understand and design list in ordered, unordered, definition lists and nested font tags and attributes to perform page layout using colors, background, fonts horizontal rules, address tags and etc.

Main Topics Covered:

1. Introduction to HTML
2. A Simple HTML Document
3. The HTML structure using markup
4. HTML Elements and Tags
5. XHTML vs. HTML

Main Topics Covered:

1. Paragraphs, Headings, Formatting and Text
2. HTML Links, Images
3. HTML Input, Lists
4. HTML Tables
5. HTML Forms

Main Topics Covered:

1. DIV, SPAN, FRAME
2. Create, modify, and format a basic layout
3. Table based layout and Div based layout
4. What is Style Sheets?
5. Create an embedded style sheet or Linking to an external style sheet

Main Topics Covered:

1. Introduction to JavaScript for HTML
2. Introduction to XML Documents
3. Introduction to JSON Documents
4. A Quick Overview of Web Development
5. Client-side Programming
6. Server-side Programming

This module covers fundamentals of database architecture, database management systems, and database systems; principles and methodologies of database design, and techniques for database application development. In addition, this module covers the SQL to work with the database.

Main Topics Covered:

1. History of Data Storage and Database
2. What is Database and Types of databases
3. Different vendor Database
4. DBMS and RDBMS
5. Data, Database and Database Management System
6. Relational Database - Instance, Schema, Data dictionary and Data types

Main Topics Covered:

1. Relational Database - Table, Record, Field
2. Relational Database - Primary key, Foreign key, Unique key, Composite Key
3. Index, Constraints, Triggers
4. Relationships between Tables
5. Database Normalization
6. Introduction to ER diagram

Main Topics Covered:

1. Introduction SQL
2. Introduction to Data Definition Language (DDL) Create, Alter, Drop, Truncate, Rename
3. Introduction to Data Manipulation Language (DML) Select, Insert, Update, Delete
4. Introduction to Data Control Language (DCL) Grant, Revoke
5. Introduction to Transition Control Language (TCL) Commit, Savepoint, Rollback
6. Introduction to Aggregate Functions - GROUP BY, ORDER BY, HAVING, COUNT(*)
7. Introduction to Aggregate Functions - AVG(), SUM(), MAX(), MIN()
8. Introduction to SQL Functions SUBSTR, UPPER, INITCAP, RTRIM, SYSDATE
9. Introduction to Joins Equijoin, Inner Join, Outer Join, Non-equijoin
10. Sub queries, Sub queries in predicates

Main Topics Covered:

1. Introduction to Views
2. Constructing a view and its usages
3. Introduction to Stored Procedures
4. Create Stored Procedures
5. Call Stored Procedures
6. Drop Stored Procedures