HTML and CSS (40 Hours)

Each session 2 hours

Session 1

Introduction to HTML, Advantages of HTML, Content of web pages, Simple structure of

HTML program, working with basics tags, body attributes: alignment.

Session 2
Block level tags [Paragraphs, Heading, and Horizontal Ruler].Text level tags [Bold, Underline,
Italics, preformatted Text, Small, strong, address, div, etc.].Using Comment and Special
Characters [< >….)

Session 3
Ordered List. Unordered List. Nested List. Introducing

Session 4
Marquee and Attributes.Scroll Text using Marquee.Introducing Types of Links.Working with
Internal and External Links.

Session 5
Inserting Images.Attributes of Image.Image Linking/Mapping.Attributes of Image Mapping.

Session 6
Concept of Tables.Creating Tables and applying attributes.Creating Nested
Tables.Working with images and tables.

Session 7
Concept & features of framesWorking with different types of frames in HTMLUsing various
tags associated with frames Attributes of frameset

Session 8
Concept of forms.Different components of a form.Creating forms with different
components.Different methods and actions used with forms.Using table with forms

Session 9
Introduction to CSSGenerations of CSS – CSS1, CSS2, CSS3Working with Inline CSS
Working with Selectors [id & class]
1
Session 10

CSS Introduction, Type of CSS, External css, internal css and inline css, Syntax
Selector Property

Session 11
Background color, position, image, repeat, size Border and Border-radius and style width and
color

Session 12
Margins and padding, Box Model, Height and width, top, right, bottom and left

Session 13
Fonts and all property, text related property and Links CSS, hover, active, visited

Session 14
List css, table css, display and Position, float left and right.

Session 15
Z-index, Opacity, Navigation Bar, Form css.

Session 16
Shadow, Gradient and text Effect and 2D & 3D Transform

Session 17
Transitions, Animation css and Box-Sizing
2
Session 18
Div tag and Apply css and div within div, and create 3 Template in HTML and css.

Session 19
Media Query

Session 20
Project

3
JavaScript (Total 30 hours)

Each Session 2 hours

Session 1

Introduction of JavaScript, Language Syntax, Variable, Declaration of variable,

Session 2

Data Type, Different between let and const, and var vs let and scope of variable
Session 3

Operator Arithmetic, Relational, Logical, Assignment, Increment & Decrement

and with Example.
Session 4

Decision Making, Simple if, if else, nested if else, Ladder if else if and switch
statement with proper example.
Session 5

Looping type of Loop, for, while, do while loop, break, continue statement,
nested for loop.
Session 6

What is Array? And their Method, Type of Array, 1Dim and 2Dim Array with
Proper Example.
Session 7

What is String? And Pre define Method of String like uppercase, lowercase,
length, substring, replace and more method
Session 8

What is Math Library? And Pre define Method of Math like round, ceil, floor,
max, min, random and more method.
Session 9

What is Function? Type of function and define parameter and return type
function. Pre define Date () and All date Method.
Session 10

What is Event? Click Event, Mouse Event, Focus Event, Key Press Event and
more Event.
4
Session 11

What is Sets? And Essential set Method. What is Map? And map Method? And
this keyword.
Session 12

HTML DOM (Document Object Model)? And document.getElementById (id),

document.getElementByName (name) etc.
Session 13

BOM (Browser Object Model)? And History, Alert, Cookies, Navigator etc.
Session 14

Class and Object, Constructor method and Inheritance with proper Example.
Session 15

What is Arrow function? Arrow Functions Return Value by Default:

Arrow Function with Parameters:

5
Bootstrap 5.0 (30 Hours)

Each session 2 hours

Session 1

Introduction of Bootstrap, Why Use Bootstrap, download bootstrap, container,

container-fluid class, Grid System and explain device sm, lg, md, xl etc.
Session 2

Introduction of Bootstrap, Why Use Bootstrap, container, container-fluid class,

Grid System, column, Z-Index and explain device sm, lg, md, xl etc.
Session 3

Typography,<code> <kbd> <dl> <mark> <abbr>. Color, text-primary, text-

danger, text-success, text-dark etc.
Session 4

Table, table striped, hover, table background color etc. Image, Circle, rounded
thumbnail and responsive image
Session 5
Background color, bg-primary, bg-danger, bg-success, bg-dark etc.
Session 6

Accordion, collapse, accordion-item, accordion-header, data-bs-toggle.

Session 7
Alerts: alert-primary, secondary, danger, success and alert-link. Badge.
Session 8

Button, outline Button, Size, Disable state, button block, Button Sizing, spin and
grow button. Button Group:
Session 9
Dropdown, up, start, end, toggle button, Button group Vertical.
Session 10

Navbar, Nav, tabs, Pills, navbar-expand-lg, nav-item, nav-link, active, fixed top,
fixed bottom, sticky navbar
Session 11

6
Model, full screen Model, Model Size, Tooltips, Positioning Tooltips, Popover,
Positioning Popover, and Toast.
Session 12

Scrollspy, Offcanvas, Offcanvas Sidebar, start, title, offcanvas body, offcanvas

positioning, offcanvas menu
Session 13

Form, text, select menu, check, radio, input groups, floating Label, textarea,
range, Validation form in bootstrap.
Session 14

Border, Border width, color, radius, float, clear fix, spacing margin and padding,
Session 15

Font-awesome, Shadow, Vertical alignment, Visibility, close icon and more

ICON.

7
C Program (40 hours)
Each session 2 hours
Session 1
Introduction to Programming ALGORITHM and Flow Chart.
Session 2
Machine Language, Assembly Language and High Level Language the C Language - An introduction
Session 3
Variables & Constants - Numeric constants, String Constants and Character constants Data types in C
Session 4
Operators and Expressions, Unary and Binary Operators General structure of a C Program
Session 5
Compiling and Running a C Program #include statement Reading data from the console and displaying
it
Session 6
Typecasting IF - ELSE statements, Nested if else, Ladder if else and Switch statement.
Session 7
Loop Structures - For (), While () and do - While (), break, continue, Nested loop.
Session 8
What is Arrays? Arrays - Single and Multi-Dimensional, declaration and initialization
Session 9
Linear Searching, Binary Search and sorting and different type sorting algorithm
Session 10
String and character, String method ,strupr(), strlwr(), strlen(), strcmp(), strrev(), strcat(),strcpy().
Session 11
What is function? User defined functions, type of user define function, Built in Functions
Session 12
What is Pointer? Declaration of pointer, use of pointer, address and pointer value.
Session 13
Pointers - Declaring variables of pointer type, Pointers to arrays, pinters to Functions, pointers to
structures
Session 14

8
Dynamic memory allocation-malloc(), Calloc(), realloc() and Free()
Session 15
Recursion function, call by reference and call by value.
Session 16
What is Structures? Different between structure and unions, Declaration of structure, Structure variable.
Arrays of Structures.
Session 17
File handling in C - opening a file, reading a file, writing to a file, Appending to an existing file
Session 18
File opening modes “r”, “w”, “a”, “r+”, “w+”, “a+”, “rb”, “wb”, “rb+”, “wb+” using getc(), putc(),
getw(), putw(), fprint(), fscanf(), fwrite() and fread()
Session 19, 20
Project

9
C++ (OOPS) 40 hours
Each session 2 hours
Session 1
Lecture 01: Introduction C++, Object Oriented Programming BASIC CONCEPTS OF OBJECTS
ORIENTED PROGRAMMING
Session 2
BENEFITS OF OOP Basics of C++ Tokens Basic Data types in C++
Session 3
Symbolic Constant Operators Arithmetic, relational, Logical, Assignment, Increment and decrement.
Session 4
Control Structures if else, ladder if else, switch and looping for, while, do while.
Session 5
Class and object, syntax class and object, access specify like private, public etc.
Session 6
Functions in C++, Member Function, Function Overloading, Nesting of Member function
Session 7:
Array with Class, Static Data Member, Friendly functions, Returning Objects Lecture
Session 8:
Constructors, Type of Constructor, Parameterize, Default, copy
Session 9
Multiple constructor, Dynamic Constructor and Destructors
Session 10
Operator Overloading, Unary operator Overloading and Binary Operator Overloading
Session 11
Inheritance, Single Inheritance, Multilevel Inheritance
Session12
Multiple Inheritance, Hybrid Inheritance and Hierarchical Inheritance
Session 13
Virtual Base Class and Virtual function
Session 14
Inheritance with Constructor, what is pointer, pointer object, access function with pointer object
10
Session 15
Polymorphism, compile time and runtime polymorphism and pure virtual function

Session 16
Template in c++, class template
Session 17
Managing Console I/O, iostream , istream, ostream and file handling
Session 18
Exception Handling try and catch in c++, New & Delete Operators

Session 19, 20
Project

11
CORE JAVA PROGRAMMING (Each Session 2hrs.)
Course Duration: 50Hrs.
Session 1
Introduction to Java Programming Language · History of Java · Features of Java · Application Design in
Java · Simple Java Program · Working Environment
Session 2
Data Types and Operators · Data types · Naming Conventions · Variables · Type Casting · Operators ·
Simple Programs
Session 3
Control Statements and Loops · Need for Choices · Types · If statement · If-else statement · Nested If-
Else · Switch Case · Need of Loops · Types of Loop · While Loop · Do –while Loop · For Loop
Session 4
Arrays · what are Arrays? · Types of Arrays · Advantages of using Array
Session 5
Introduction to OOPS · Understanding need of Classes & Objects · Identifying features of Objects ·
Understanding OOPS Concept · Advantages of using OOPS
Session 6
Classes, Objects, Construct & Methods · Defining Class and Object · Methods · Constructors · Use of
this Keyword
Session 7
String Class, String Buffer and String Builder · Understanding String as Class · String Buffer · String
Builder · Difference between String Buffer & String Builder
Session 8
Encapsulation and Access Specifier · Understanding Encapsulation · How it is Achieved · Access
Specifiers · Different types of Access Specifier
Session 9
Inheritance · Understanding Inheritance · How It Is Achieved · Types of Inheritance · Use of Super
Keyword · Aggregation
Session 10
Polymorphism · Understanding Polymorphism · How It Is Achieved · Types of Polymorphism
Session 11
Abstract Class and Interface · Understanding Abstraction · How It Is Achieved · Use of Interface ·
Difference between Abstract Class & Interface
Session 12

12
Exception Handling · Understanding Exception · Types of Exception · Exception Handling Techniques
Session 13
Collection Part-l · Understanding Collection Framework · Collection Classes · Collection Interfaces ·
Advantages of Using Collections
Session 14
Collection Part-ll · Understanding Set Collection · Collection Classes · Collection Interfaces
Session 15
Collection Part-llI · Understanding Map Collection · Collection Classes · Collection Interfaces
Session 16
File Input and Output · Understanding Basic Input/output · Understanding IO Stream · Different Types
of IO Stream · Understanding File IO · Serialization
Session 17
Multithreading · Understanding Thread · Understanding Multithreading · Thread Life Cycle · Thread
Scheduler · Thread Priority.
Session 18
Database Connectivity Part-l · Understanding JDBC · Components of JDBC · Advantages of JDBC
Session 19
Database Connectivity Part-lI · Understanding Connection · Understanding Statement Interface ·
Examples
Session 20
Database Connectivity Part-lII · Understanding Prepared Statement · Understanding Callable Statement
· Transaction Management
Session 21
Introduction to Swing · Understanding AWT · Understanding Swing · Difference between Awt and
Swing
Session 22
Controls in Swing Part-l · Understanding Various Aspects of UI · Different Controls · Example
Session 23
Controls in Swing Part-lI · Understanding Different Controls · Example
Session 24
Layout Manager · Understanding Various Layout · Example
Session 25
Event Handling with Swing · Understanding Events · How to Handle Events

13
Advance JAVA Programming (Each Session 2hrs.)
Course Duration: 40Hrs
Session 1:
Java Servlets, Servlet as an improved CGI, Servlet Fundamentals / API, What is a Web-Container
Session 2:
Servlet Life Cycle / Architecture, HTTP GET and POST Request Methods, Processing Html Forms
Session 3:
Configuration of Web Application? Understanding the Deployment Descriptor (DD) / web.xml
Session 4:
HttpServlet, ServletRequest, servletResponse interface, RequestDispacher, sendRedirect, forward () and
include () Method.
Session 5:
Specifying the Welcome file list, Servlet URL Pattern Mapping, Init Parameters,
Session 6:
State Management, Using HTTP Session, Using Cookies, Using Application
Session 7:
CRUD (Create, Read, Update, Delete) Operation in Servlet and Registration and login form.
Session 8:
Servlet vs JSP, Java Server Pages (JSP),JSP Architecture , JSP Standard / Implicit Objects ,Request
Response
Session 9:
Life cycle of jsp, Jsp Scripting Element, scriptlet tag, expression tag, declaration tag
Session 10:
JSP Basics & Syntax, Implicit Object JSP Request, JSP Response, Config, page, Exception in jsp,
Application in jsp.
Session 11:
Directive Element, page, include, taglib, Action Element: forward, include, java bean class, set and get
property
Session 12:
State Management, Using JSP Session, Using JSP Cookies, Using Application
Session 13:
CRUD (Create, Read, Update, Delete) Operation in JSP and Registration and login form with MySQL
Database
14
Session 14:
What is Struts? Struts2 Home, Basic MVC Architecture, Example with Struts Configuration in struts
Session 15:
Action in struts, interceptors in struts, Result Type and Validation in struts, Annotations, control tag,
form tag, Data tag.
Session 16:
What is Hibernate? Importance of Hibernate. Hibernate vs JDBC, hibernate.cfg.xml file and basic
Example of HB.
Session 17:
Hibernate, Hibernate Query Language, Relationship: one to one, one to many, many to one and many to
many.
Session 18:
Insert, Update, Delete, and select example with hibernate. Hibernate mapping file. POJ0 (Plain Old Java
Object)
Session 19:
What is EJB (Enterprise Java Bean)? Use of EJB and importance of EJB in java. Type of EJB.
Session 20:
Session bean in EJB, Stateful Session Bean, Stateless Session bean in EJB, Message Driven bean, Entity
bean.

15
Oracle (Each Session 2hrs.)
Course Duration: 40Hrs

Structured Query Language (SQL)

Session 1:

Introduction to SQL Introduction Database, Understanding DBMS vs RDBMS, Data types in Oracle,

ER Diagram DDL, DML, DCL and TCL.

Session 2:

Create Table, Rule of naming table and column name Database, Inserting data, Update Data and

deleting Data.

Session 3:

Modify structure of table, alter table, add, drop column and modify size, drop table, truncate table.

Rename of table

Session 4:

Selecting data from table, sorting data, distinct data, top select row data and operator in oracle.

Session 5:

Where clause, Relational operator, Logical operator, between, in, not in, is and is not null, pattern

matching like operator.

Session 6:

Data Aggregation sum (), avg (), max (), min (), count (), and working with group by clause and
having clause.

Session: 7

Integrity constraints, Primary key, foreign key, Not Null, unique, check constraint and default

constraints

Session: 8

String function, Upper (), Lower (), length (), ascii(), ltrim(), rtrim(),trim(), substr(), translate(), lpad(),

rpad() and more function.

Session: 9

Math function, round (), floor (), ceil (), sqrt (), power (), greatest (), least (), abs (), sin (), cos () and

more function.

16
Session: 10

Date function, add_months (), current_date (), months_between (), last_day (), next_day (), sysdate (),

to_char (), to_date and more function.

Session: 11

Understanding joins and its uses, types of joins, equi join, non equi join, outer join, self-join, cross join

and full join.

Session: 12

Set Operators and Pseudo Column, UNION, UNION ALL, INTERSECT, MINUS and ROWID,

ROWNUM.

Session: 13

Sub Queries, Single row sub queries, multi row sub queries, nested queries, multi column sub queries

and correlated sub queries.

Session: 14

Database Transaction and Security, TCL transaction control language, Commit, Rollback, Savepoint,

and grant and revoke object privileges.

PL/SQL (Procedural Language Extension to SQL)

Session 15:
Introduction to PL/SQL, Advantages of PL/SQL, Data types in PL/SQL, Program structure of PL/SQL,

Using conditional statements and loops.

Session 16:
What is cursor? Create cursor, type of cursor, what are cursor parameters, update clause and implicit

cursor and explicit cursor.

Session 17:
What is an Exception? Describing Exception type, Handling System defined exceptions, User define

exceptions.

Session 18:
Creating procedures in PL/SQL, IN, OUT, INOUT Parameter and creating function and procedure vs

function

17
Session 19:
What is s package? Package specification, what is package body, how to instantiate package, how to

stored procedure and function and calling.

Session 20:
What is Triggers, benefits of trigger, using DML trigger, how to audit database using trigger and

database level trigger.

18
C# .net (Each Session 2hrs.)
Course Duration: 50Hrs

Session1
Introduction .net Framework, common language runtime (CLR) and the .NET Framework class library,
The Microsoft .NET Framework is a platform for building, what is a Namespace?

Session2
Introduction C#.net, Tokens in C#, Data Types, declare a Variable, Value Type and Reference Type.

Session3
Operator in C#.net, Type costing, Implicit Casting and Explicit casting, what is boxing? What is
Unboxing? Constants and Enum.

Session4
Decision Making, simple if, if else statement, nested if else, ladder if else if and switch statement.

Session5
Looping, for, while, do while, foreach loop, nested loop, break, continue statement,

Session6
What is Array? Type of Array, 1 Dim, 2 Dim and multi-dimensional array. String and pre define method of string,
string vs string builder.

Session7
Function in c#, User define function, Type of user define function, Pass argument by value, ref and out.

Session8
OOPS Concepts in c#, Feature of oops, class and object, access class’s function, Encapsulation and Data
Abstraction, Access specify private, public, protected, default etc.

Session9
Method Overloading, static method, static variable, Array of Object, Constructor, type of constructor method in
c#.

Session10
Inheritance, type of inheritance, single, multilevel, Polymorphism Method overriding, base keyword, override,
virtual and new keyword.

Session11
Interface and abstract keyword, multiple inheritance is working with interfaces, what is an abstract class,
abstract method.

Session12
Collection and generics Types of collections and what is IEnumerable, ICollection, IList, IDictionary
ArrayList, HashTable, SortedList, Queue, Stack.

Session13
Exception handling types of Exceptions, handle Exception using try and catch blocks, throw an Exception
using throw ex and throw, finally Block, define custom Exception class.

Session14
19
IO Stream Types of Streams, standard IO streams, Files can be handled using File Mode, File Access,
Binary Reader and Binary Writer, What is Serialization and Deserialization.

Session15
Multithreading, process and Thread, What is difference between Multithreading and Multitasking, Thread
priority, Thread Synchronization, o suspend, Resume, Interrupt, Abort and get the status of Thread.

Session16
Delegate and Event, How to create a chat application using Delegates, How to raise an event using
Delegates, What are Anonymous Methods.

Session17
GUI Application with window Form, Control, properties, view, solution explorer, Events that each
control, Label, textbox, Button with example.

Session18
GUI Application with window Form, Radio, checkbox, combo box, list box, and more command
control.

Session19
GUI Application with window Form masted textbox, Datetimepicker, Progress bar, Picture box, image,
timer control

Session20
GUI Application with window Form, Container, panel, group box, tab Control, table Layout panel, split
panel, flow layout

Session21
GUI Application with window Form, menu and toolbar control, ContextMenuStrip, MenuStrip,
StatusStrip, ToolStrip and ToolStripContainer.

Session22
ADO.net, establish a connection to Database with sql server, insert, Update, Delete the data in the
Database from the Application.

Session23
ADO.net, Fetch Data from the Database using Select command, Multiple Active Result Sets,
Parameterized Prepared Statement, stored procedures.

Session24
ADO.net, DataAdapter, Dataset constrains in the DataTable and How to Add the constrain to the
DataTable, grid view.

Session25
ADO.net, CRUD (Create, Read, Update, Delete) Operation, Login and Registration form

Vb. Net (Each Session 2hrs.)

Course Duration: 50Hrs

20
Session1
Introduction, VB.Net Hello World Example, Compile & Execute VB.Net Program, Identifiers
VB.Net Keywords.
Session2

The .NET Framework

Common Language Runtime (CLR), Common Type System (CTS), Common Language
Specification (CLS), Intermediate Language (IL) and Just-In-Time (JIT) Compilation, .NET
Framework Namespaces
Session3

DATA TYPES and Variable

Data types Available in VB.Net, Type Conversion Functions in VB.Net VARIABLES,
Declaration in VB.Net, Initialization in VB.Net,
Session4
Values from, Lvalues and Rvalues, CONSTANTS AND ENUMERATIONS, Declaring
Enumeration, Conversion Data type.
Session5
OPERATORS
Arithmetic Operators, Comparison Operators, Logical/Bitwise Operators, Assignment
Operators Operators Precedence in VB.Net.
Session6

DECISION MAKING
If...Then Statement If...Then...Else Statement the If...Else If...Else Statement Nested If
Statements Case Statement Nested Select Case Statement
Session7
LOOP
Do Loop, For...Next Loop, Each...Next Loop, While... End While Loop, With... End with
Statement Nested Loops, Loop Control Statements, Exit Statement, Continue Statement, GoTo
Statement
Session8
STRINGS
Creating a String Object, Properties of the String Class, Methods of the String Class

Session9

ARRAYS
Creating Arrays in VB.Net, Dynamic Arrays, Multi-Dimensional Arrays, Jagged Array,The
Array Class

21
Session10
COLLECTIONS
Various Collection Classes and Their Usage, ArrayList, Hashtable, SortedList, Stack, Queue
Session11

FUNCTIONS
Defining a Function, Function Returning a Value, Recursive Function, Param Arrays, Passing
Arrays as Function Arguments,
Session12

Sub Procedures
SUB PROCEDURES, Defining Sub Procedures, Passing Parameters by Value, Passing
Parameters by Reference
Session13
CLASSES & OBJECTS
Class Definition, Member Functions and Encapsulation, Constructors and Destructors, Shared
Members of a VB.Net Class
Session14
Inheritance
Inheritance, Type Inheritance, Base & Derived Classes, Base Class Initialization, interface,
Session15
Abstract
Abstract vs interface, polymorphism, method overloading vs method overriding in vb.net
Session16

EXCEPTION HANDLING
Runtime Error and Syntax Error, Exception Classes in .Net Framework, Handling Exceptions,
Creating User-Defined Exceptions, Throwing Objects
Session17
GUI Application
GUI Application with window Form, Control, properties, view, solution explorer, Events that each
control, Label, textbox, Button with example.

Session18
GUI Application
GUI Application with window Form, Radio, checkbox, combo box, list box, and more command
control.

Session19
GUI Application
GUI Application with window Form masted textbox, Datetimepicker, Progress bar, Picture box, image,
timer control

22
Session20
GUI Application
GUI Application with window Form, Container, panel, group box, tab Control, table Layout panel, split
panel, flow layout

Session21
GUI Application
GUI Application with window Form, menu and toolbar control, ContextMenuStrip, MenuStrip,
StatusStrip, ToolStrip and ToolStripContainer.

Session22
ADO.Net
ADO.net, establish a connection to Database with sql server, insert, Update, Delete the data in the
Database from the Application.

Session23
ADO.Net
ADO.net, Fetch Data from the Database using Select command, Multiple Active Result Sets,
Parameterized Prepared Statement, stored procedures.

Session24
ADO.Net
ADO.net, Data Adapter, Dataset constrains in the DataTable and How to Add the constrain to the
DataTable, Grid view.

Session25
ADO.Net
ADO.net, CRUD (Create, Read, Update, Delete) Operation, Login and Registration for

23
ASP.Net with C# (Each Session 2hrs except Last Session)
Course Duration: 50Hrs.

Session 1
Web Programming Introduction
Understanding role of Web Server and Web Browser. Brief about HTTP Protocol, HTTP
Request structure, Form Tag and comparison between Get and Post methods, HTTP Response
Structure
Session 2
ASP.NET Introduction
ASP.NET Introduction, First ASP.NET Application, Auto Postback Property, Event Handler
Parameters, Dynamically initializing Controls, IsPostBack property of Page class
Session 3
ASP.NET Architecture
What is AppDomain?, Life Cycle of ASP.NET Page , How Control Manages its State , What is
EnableViewState, How Control raises events, Event handling in Web Forms, Writing Custom
Session 4
Standard Controls1
BulletedList, adRotator, ListControls, Comparison between HtmlControls and WebControls.
Control Properties and Methods FileUpload Control
Session 5
Standard Controls2
Dropdown Controls, RadioButton, checkbox and list, image, image map, hyper link, between
HtmlControls and WebControls. Control Properties and Methods FileUpload Control
Session 6
Standard Controls2
Wizard control, Panel control, View control, Literal, Hidden Field, Calender, table and xml file,
Properties and Methods.
Session 7
Classes in WebApplication CSS & Themes
Work with CSS, Use Themes to Customize a Site, Name Skins within a Theme, Do server-side
Styles
Session 8
Themes
Using Themes, Add contents of a Theme and Skin, Apply themes and Profiles.

Session 9
Redirecting User to another Page
Redirecting Options, Response.Redirect, Server.Transfer, Cross Page Postback, Determine how
the pages was invoked. Passing values between pages
Session 10
Master Pages
Introduction to MasterPage, ContentPlaceHolder and Content tags, Accessing controls of
MasterPage in ContentPage , URL's in MasterPages, UniqueID and ClientID
Session 11
Working with User Control I
Overview of User Controls, Creating a User Control, Adding Properties to User Control,
Adding
Session 12
Working with User Control II
Events to User Control, Using User Control in Web Form, Rendering Clients Scripts Using
Page.ClientScript methods.
Session 13
Validation Controls
Base Validator, Required Field Validator, Compare Validator, Range Validator, Regular
Expression Validator, Custom Validator
Session 14
ASP.NET State Management I
Static Members, View State, Hidden Field in Form, Query String, HttpContext, Cookies-
HttpCookie
Session 15
ASP.NET State Management II
Sessions-HttpSessionState, Application-HttpApplicationState, Summary of All Features.
Session 16
Web Configuration File and Global.asax
Introduction to Configuration files, Page setting in web.config, Custom Errors, URL Re-
Writing, Tracing, Using ConfigSource Attribute, Using Location Section, HttpApplication
class-Global.asax
Session 17
Database connection
How to connect to sql Database, What is sqlcommand, sqldataAdapter, dataset, datatable,
parameter, store procedure.

Session 18
Data Bound Controls
Databinding traditional way, SqlDataSource, GridView, DetailsView, FormView, DataList,
Repeater, ListView, DataPager
Session 19
Database connection
CRUD Operation (CREATE READ UPDATE DELETE) in asp.net and Registration from and
Login page
Session 20
Understanding & Publishing Web Application Part1
Introduction to ASP.NET Web Application, Advantages of IIS Applications, Creating web
application in IIS,
Session 21
Understanding & Publishing Web Application Part2
Converting File System application to IIS Application, Using Virtual Directory, Publishing
ASP.NET Website, Culture specific formatting
Session 22

Introduction ASP.NET MVC

Model-View-Controller Pattern, What Is ASP.NET MVC? ASP.NET MVC versus Web Forms
ASP.NET MVC Projects In Visual Studio, Controllers, Views and Model
Last Session.

Project and Guidance on ASP.NET (6 Hour)

Sql Server (Each Session 2hrs.)
Course Duration: 40Hrs

Session 1:

Introduction to SQL Server, Introduction Database, and Understanding DBMS vs RDBMS, Data types

in Sql Server.

Session 2:

ER (Entity Relationship) Diagram, Sql Divided into 4 parts, DDL, DML, DCL and TCL.

Session 3:

Create Table, Rule of naming table and column name Database, Inserting data, Update Data and

deleting Data.

Session 4:

Modify structure of table, alter table, add, drop column and modify size, drop table, truncate table.

Rename of table

Session 5:

Selecting data from table, sorting data, distinct data, top select row data and operator in sql server.

Session 6:

Where clause, Relational operator, Logical operator, between, in, not in, is and is not null, pattern

matching like operator.

Session 7:

Data Aggregation sum (), avg (), max (), min (), count (), and working with group by clause and
having clause.

Session: 8

Integrity constraints, Primary key, foreign key, Not Null, unique, check constraint and default

constraints

Session: 9

String function, Upper (), Lower (), len (), ascii(), ltrim(), rtrim(),trim(), substring(), replace(), left(),

right() and more function.

Session: 10
Math function, round (), floor (), ceiling (), sqrt (), power (), Exp (), Cos (), abs (), sin (), cos () and more

function.

Session: 11

Date function, dateadd (), datediff (), datename (), getdate (), year (), month (), day (), and more

function.

Session: 12

Understanding joins and its uses, types of joins, equi join, non equi join, left outer join, right outer join

self-join, and full join.

Session: 13

Set Operators and Pseudo Column, UNION, UNION ALL, INTERSECT, Exist and not exist.

Session: 14

Sub Queries, Single row sub queries, multi row sub queries, nested queries, multi column sub queries

and correlated sub queries.

Session: 15

Database Transaction and Security, TCL transaction control language, Commit, Rollback, Savepoint,

and grant and revoke object privileges.

Session 16:
Introduction to PL/SQL, Advantages of PL/SQL, Data types in PL/SQL, Program structure of PL/SQL,

Using conditional statements and loops.

Session 17:
What is cursor? Create cursor, type of cursor, what are cursor parameters, update clause and implicit

cursor and explicit cursor.

Session 18:
What is an Exception? Describing Exception type, Handling System defined exceptions, User define

exceptions.

Session 19:
Creating procedures in PL/SQL, Parameter and creating function and procedure vs function

Session 20:
What is Triggers, benefits of trigger, using DML trigger, how to audit database using trigger and

database level trigger.

Core Python (Each Session 2hrs.)
Course Duration: 40Hrs

Session1
History, features Setting up path, working with Python, Basic Syntax, Variable and Data Types Operator.

Session2
Condition statement, Relational operator and logical operator, Simple If, If- else, If elif, Nested if-else

Session3
What is Looping, For, While, Nested loops, control Statements, Break, continue, pass.

Session4
Math and Random, Number and Math, Basic Operations, Random, Function and Methods

Session5
String Manipulation, Accessing Strings, Basic Operations, String slices, Function and Methods

Session6
Introduction List, Accessing list, Operations List, Working with lists, Function and Methods

Session7
Introduction tuple, List vs Tuple Accessing tuples, Operations Working Functions and Methods

Session8
Introduction Dictionary, List vs Tuple vs Dictionary, Accessing values in dictionaries, working with dictionaries,
Properties Functions

Session9
Introduction set, Access the set item, add set item, remove set item, loop the set, join the set and set pre define set
method.

Session10
What is function, Defining a function, type of function (user define) Calling a function, local and global variable,
Anonymous functions (lambda function).

Session11
What is Module, benefit of module, Importing module, Math module, Random module, Packages, Composition

Session12
Printing on screen, Reading data from keyboard, Opening and closing file Reading and writing files Functions

Session13
Compile time and runtime Exception, Exception Handling, Exception Handling, except clause, try? Finally clause,
User Defined Exceptions

Session14
Class and object, Constructor, Parameterize and default constructor init method, Overloading, Data hide

Session15
What is Inheritance, single Inheritance, Multilevel inheritance, Encapsulation, polymorphism, Overriding

Session16
Regular expression, Match function, Search function, Matching VS Searching, Modifiers Patterns

Session17
What is Database connectivity, Introduction Connections Executing queries Transactions
Handling error

Session18
Insert, update, delete, select, where clause and joining statement, limit data cursor, row count

Session19
What is GUI, Library tkinter, place, pack and grid system, mainloop, explain with event, draw line, rectangle, and
circle.

Session20
Component, Label, Entry, Button, Radio, Checkbox, Combo Box, List, Menu Editor and command, paddy, bg, fg,
font size.
Numpy (Total Session 10 Hours)
Each Session 2 hours.
Session 1
What is numpy? Benefit of numpy, download numpy, PIP Install Numpy, What is Array and terminology of Array in
numpy.
Session 2
NumPy Array Creation of NumPy Arrays from List, tuple etc. Indexing of Array in 1D, 2D and 3D, slicing in numpy
Session 3
Operations on Arrays, Arithmetic, Transpose and sorting in numpy, Concatenating Arrays in Numpy.
Session 4
Reshaping Arrays in numpy, Reshaping in 1D, 2D and 3D, data type, dtype in numpy type, Splitting Arrays with split
method.
Session 5
Statistical Operations on Arrays, STD (), sum (), min (), max (), mean (), describe () in numpy
Pandas (20 Hours)
Each Session 2 hours.
Session1
What is Pandas? Use of Pandas, how to install pandas, pip install pandas in command prompt, import pandas.

Session2
What is Series and DataFrame, Dataframe terminology, shape, head, tail, column, and type? Operation on Dataframe, set
index.

Session3
How to load csv and excel file in pandas Different way creating Dataframe using List, dictionary, and tuple in pandas.

Session4
Read and Write csv and Excel files in pandas, skiprows, header, nrows, rename of column, writing, dataframe.to_csv (),
to_excel ().

Session5
Handling Mission Data, Fillna, interpolate, dropna, type, method ffill, bfill, and axis column, limit, method time, dropna
how all, inserting missing date.

Session6
Handling Mission data –replace method, replacing single value, replace list with single value, replace per column, replace
list with another list.

Session7
Pandas Group by, group by max (), group by min (), group by mean (), group by describe (), group by size (), count ().

Session8
Pandas Concatenate, concat (), concat with ignore index, concatenation and key, loc, concatenation using index,
concatenation dataframe and series.

Session9
Merge in pandas, like join in database, merge with inner, outer, left, right and join method in pandas.

Session10
Pivot in pandas, Pivot Table, Margins, Grouper, Reshape pandas dataframe using melt,
PHP (Each Session 2 hours)
Total Session 40hours.
Session1
Introduction to PHP,Web Architecture, Overview of PHP Platform, Origins of PHP in the open source community, Why
we use PHP?, Availability across multiple platforms,
Session2
Installing as a module for Apache Web Server PHP language building blocks, Comparing PHP with other Web scripting
languages or technology, Installation of PHP,
Session3
PHP delimiters, Variable initialization with PHP, PHP Data types, PHP Constants, PHP Operators
Session4
Conditional Statements Simple if statement, If else statement, Nested If else statement, Switch Case statement.
Session5
Looping Jump Statements (Break, Continue, Exit For loop, while loop, do while loop, Nested Loop
Session6
Introducing ARRAY, How to use an important programming construct: arrays, Numerically Indexed arrays,
Session7
Non-Numerically Indexed arrays (Associative Array), Multidimensional arrays, Array sorting
Session8
Manipulation user input, Presenting the user with input options via different HTML from elements Retrieving form data
with $_POST, $_GET and $_REQUEST, Preserving Data in Form inputs Reusing

Session9
Functions, Introducing Functions, Defining functions, using parameters, Understanding scope, Returning values, call by
Value & Call By reference,
Header location, Using Require () and include () Array
Session10
String strtolower(), strtoupper(), strstr() stristr(), strops(), strlen(), trim(), str_split() and more function.
Session11
Math sqrt(), tan(), abs(), ceil(), round(), floor(), hypot(), sin(), cos(), pow(), pi() and more function.
Session12
Date functions date_diff(), date_add(), date(), getdate(), strftime(), strtotime(), time() and more function.
Session13
Exception Handling: runtime error, System Exception and user define Exception, block try, catch, throw, finally
Session14
String Manipulation and Regular Expression, Formatting, Joining, splitting, comparing strings
Session15
State Management, Session, Cookie, Query String, Understanding Basic Session Functionality Starting a Session,
Registering Session variables, Using Session Variables, Destroying the variables and Session
Session16
What is a Cookie? Setting Cookies with PHP, Using Cookies with Sessions, Deleting Cookies Implementing Query
String, Hidden Fields.
Session17
MySQL Database Introduction to DBMS and MySQL, Web Database Design & Architecture. Creating a MySQL
Database, Creating Database Tables, Column Data Types.
Session18
Implementing Insert/Delete/Update and select Query, Aggregate Functions, Having and Group By Clause, Joining Table,
Implementing Keys & Constraint.
Session19
CRUD (Create, Read, Update, Delete)
Session 20
Project on Ecommerce Website
MySQL (Each Session 2hrs)
Course Duration: 30Hrs
Session 1:
Introduction to MySQL, Introduction Database, and Understanding DBMS vs RDBMS, Data types in MySQL.
Session 2:
ER (Entity Relationship) Diagram, Sql Divided into 4 parts, DDL, DML, DCL and TCL.
Session 3:
Create Table, Rule of naming table and column name Database, Inserting data, Update Data and deleting Data.
Session 4:
Modify structure of table, alter table, add, drop column and modify size, drop table, truncate table. Rename of table
Session 5:
Selecting data from table, sorting data, distinct data, top select row data and operator in MySQL
Session 6:
Where clause, Relational operator, Logical operator, between, in, not in, is and is not null, pattern matching like operator.
Session 7:
Data Aggregation sum (), avg (), max (), min (), count (), and working with group by clause and having clause.

Session 8:
Integrity constraints, Primary key, foreign key, Not Null, unique, check constraint and default constraints
Session 9:
String function, Upper (), Lower (), len (), ascii(), ltrim(), rtrim(),trim(), substring(), replace(), left(), right() and more
function.
Session 10:
Math function, round (), floor (), ceiling (), sqrt (), power (), Exp (), Cos (), abs (), sin (), cos () and more function.
Session 11:
Date function, adddate (), date (), dayname (), datediff (), now (), year (), month (), day (), and more function.
Session 12:
Understanding joins and its uses, types of joins, equi join, non equi join, left outer join, right outer join self-join, and full
join.
Session 13:
Set Operators and Pseudo Column, UNION, UNION ALL, INTERSECT, Exist and not exist.
Session 14:
Sub Queries, Single row sub queries, multi row sub queries, nested queries, multi column sub queries and correlated sub
queries.
Session 15:
Database Transaction and Security, TCL transaction control language, Commit, Rollback, Savepoint, and grant and
revoke object privileges.
Android (Total 40 hours)
Each session 2 hours

Session 1: JAVA Concepts

OOPs Concepts, Inheritance in detail, Exception handling, Packages & interfaces, JVM & .jar file extension, Multi-threading
(Thread class & Runnable Interface)

Session 2: Introduction to Android

What is Android? Setting up development environment, Dalvik Virtual Machine & .apk file extension.

Session 3: Fundamentals:
Basic Building blocks - Activities, Services, Broadcast Receivers & Content providers, Components

Session4: Application Structure (in detail)

AndroidManifest.xml, Uses-permission & uses-sdk, Resources & R.java o Assets, Layouts & Drawable Resources, Activities and
Activity lifecycle, first sample Application

Session 5: Emulator-Android Virtual Device

Launching emulator, editing emulator settings, Emulator shortcuts, Logcat usage
Introduction to DDMS, Second App: - (switching between activities) - Develop an app for demonstrating the communication
between Intents

Session 6: Basic UI design

Form widgets, Text Fields, Layouts, [dip, dp, sip, sp] versus px, Examples

Session 7: Preferences
Shared Preferences, Preferences from xml, Examples

Session 8: Menu
Option menu, Context menu, Sub menu, menu from xml, menu via code, Examples

Session 9: Intents (in detail)

Explicit Intents, Implicit intents, Examples

Session 10: UI design

Time and Date, Images and media, Composite, Alert Dialogs & Toast, Popup, Examples

Session 11: Tabs and Tab Activity

Introduction of Tab, tabs creation and add Tab, Tab Activity, Examples

Session 13: Styles & Themes

styles.xml, drawable resources for shapes, gradients (selectors), style attribute in layout file
Applying themes via code and manifest file, Examples

Session 14: Content Providers

SQLite Programming, SQLiteOpenHelper, SQLiteDatabse, Cursor, Reading and updating Contacts, Reading bookmarks
Example: Develop an App to demonstrate database usage.

Session 15: CRUD Operation

CRUD operations must be implemented. Final details should be viewed in GridView as well as in ListView.
Session 16: Linkify
Web URLs, Email address, text, map address, phone numbers, Match Filter & Transform Filter
Examples

Session 17: Adapters and Widgtes

Adapters, Array Adapters Base Adapters, ListView and List Activity, Custom listview, GridView using adapters, Gallery using
adapters, Examples

Session 18: Notifications

Broadcast Receivers, Services and notifications, Toast, Alarms, Examples

Session 19: Custom components

Custom Tabs, Custom animated popup panels, other components, Examples

Session 20: Advanced

XML Parsing, JSON Parsing, Maps, GPS, Location based Services, Accessing Phone services (Call, SMS, MMS)

Project Based on Android