1 - Introduction
   • What Is Database?
   • What is Database Management System (DBMS)?
   • What is Relational Model ?
   • Introduction to RDBMS .
   • Brief on E.F CODD . 

2 - Datatypes and Constraints 
   • What are Datatypes ?
   • Types and Examples .
   • How to use .
   • What are Constraints? 
   • Types and Examples.
   • How to use. 

3 - Statements in SQL 
   • Data Definition Language (DDL)
   • Data Manipulation Language (DML)
   • Transaction Control Language (TCL)
   • Data Control Language (DCL)
   • Data Query Language (DQL)

4- Software installation
   • Installing and set up of software
   • Working on Oracle 10g.

5- Data Query Language (DQL) 
   • Select 
   • From 
   • Where
   • Group By
   • Having 
   • Order By 

6 -Operators 
   • Types and Examples 

7- Functions in SQL 
   • Single Row Functions 
   • Multi Row Functions 
    Max ()
    Min ()
    Sum ()
    Avg ()
    Count ()

8-Sub Query 
   • Introduction to Sub Query 
   • Working of Sub Query 
   • Query Writing and Execution 
   • Types of Sub Query 
    1. Single Row Sub Query 
    2. Multi Row Sub Query        
   • Nested Sub Query.

10- Pseudo Columns 
   • Introduction on Pseudo Columns 
   • ROWID
   • ROWNUM
   • Working and Usage.

11- JOINS
   • What Is Join?
   • Types of Joins.
   • Cartesian Join
   • Inner Join 
   • Outer Join 
   • Self-Join 
   • Queries and Examples.

12- Co- Related Sub Query 
   • Working and Examples 

13- Data Definition Language (DDL)
   • Create 
   • Rename 
   • Alter 
   • Truncate 
   • Drop
 
14- Data Manipulation Language (DML)
   • Insert 
   • Update 
   • Delete
 
15- Transaction Control Language (TCL)
   • Commit
   • Save point
   • Rollback 

16- Data Control Language (DCL)
   • Grant 
   • Revoke 
17 - Normalization
   • Introduction to Normalization 
   • Types of Normal Forms 
   • Examples.

18- E R Diagrams 
   • Introduction to ERD
   • Examples.

Web Technology
1.Introduction to Web-technology :
. What is web?
. What is network?
. What is internet?
. What is web-development?
. What is browser?
. What is web-server?
. What is http?
. What is the use of http?
. What is html?
. What is website?
. What is web-page?
. Structure of Web
. Definition of all the points
. Install of Editors
. How to write program using editors

2.HTML-5 :
Introduction:
. Structure of html
. What is tags?
. Types of tags
. Attributes
. All tags attributes
. How to apply all the attributes in web-pages

Table :
. How to create table in Html
. Attributes of table
. Example

List :
. How to create list
. Attributes of list
. Example

Audio/Video:
. Attributes of audio/video tag
. How to create audio page
. How to create video page

I-frame :
. What is nested web-page?
. How to create nested web-pages
. Attributes of nested web-pages

SVG :
. How to define graphics in html
. Attributes of SVG

Form :
. What is form
. How to create forms using html
. How to create log-in page
. How to create registration page using form
. Attributes of form

3. CSS-3 :
Introduction:
. What is css?
. What is the use of css?
. Types of css
. How to call css inside html pages
 
Background:
. How to set background properties
. Attributes for background

Box-Model:
. What is box-model in css
. How to work with box-model

Selectors:
. What is selector?
. Types of selector
. How to apply selector

Combinators:
. What is combinators?
. Types of combinators
. How it is related to selectors

Pseudo-class & Pseudo-elements:
. What is pseudo-class?
. What is pseudo-elements
. Types of pseudo-class
. Types of pseudo-elements
. How to apply

Transition,Transform & Animation in css :
. Applications of Transition,Transform & Animation
. Use of Transition,Transform & Animation
. Basic Project based on Transition,Transform & Animation.

4.Javascript :
Introduction:
. What is javascript?
. What is the difference between java & javascript
. Application of javascript
. Advantages & Disadvantages of javascript
. Types of javascript
. Datatypes in javascript
. Looping Statement
. Conditional Statement

Function & Arrays:
. What is function
. What is array
. Types of function
. Methods of array
 
String & Object :
. What is string
. Methods of string
. What is object
. How to create object in js

Date & Math :
. What is date method
. What is math method
. Methods of date & math

Collection in js :
. What is collection
. Types of collection

Advanced array methods in js

. Javascript Closure
. DOM elements in javascript
. Json in javascript
. Ajax in javascript
. Canvas using javascript
 
Regular Expression in js:
. What is regular expression
. How to create dynamic form in js

5. Bootstrap :
Introduction:
. What is bootstrap
. How to apply bootstrap in web-pages
. Benefits of using bootstrap
. Grid system in bootstrap
. Classes in bootstrap
. How to create table using bootstrap-class
. How to create forms using bootstrap-class
. What is carousel in bootstrap
. How to apply all of this create one project.

Project Set-up:
. Responsive project using Html, Css ,Javascript & bootstrap
 

1.1 Introduction to Python.
      •    Installation & Environment settings.
      •    Introduction to Shell.
1.2 Variables, Keywords, Data types and Identifiers.
      •    Variables 
      •    Keywords
      •    Data types  
      •    Identifiers 
1.3 String, List, Set, Tuple and Dictionary and Slicing
      •    String Data types
      •    List Data types
      •    Set Data types
      •    Tuple Data types
      •    Dictionary Data types
      •    Slicing
1.4 Operators
      •    Arithmetic Operators
      •    Logical Operators
      •    Relational Operators
      •    Bitwise operators
      •    Assignment Operators
      •    Membership Operators
      •    Identity Operators
1.5 Control Statements
      •    Decisional Statements 
      •    Looping Statements 
      •    Break, Continue and Pass
1.6 Input and Print Statements
      •    Input statements
      •    Print statements
1.7 Functions or Methods
      •    Types of Functions
      •    Recursion 
      •    Arguments
      •    Packing and unpacking(varargs)
1.8 Oops
      •    Class, Objects
      •    Inheritance
      •    Method Overriding
      •    Access Specifies
1.9 File Handling and Json
      •    Flat File Handling
      •    Json
      •    Pickle
1.10 Exception Handling
      •    Try
      •    Except and final
      •    Custom Exceptions
      •    Raising Exceptions
      •    Assertions
1.11 Comprehension
      •    List Comprehension 
1.12 Decorators 
      •    Method 
      •    Class Level
1.13 Map, Filter and Lambda Expressions
1.14 Iterators and Generators

1. Frameworks
2. Introduction to frameworks
3. Introduction to design patterns or Architectures
4. Installations and Creating Application
5. Configurations
6. HTML Responses, url mapping
7. MVC and MVT architecture
8. Connecting templates and HTML files
9. Rendering the context or data from backend
10. Static files [static images and css linking]
11. Bootstrap
12. Template tags and template inheritance
13. Models
14. Receiving data from front-end through forms
15. GET and POST methods
16. Django built-in forms module
17. Custom forms
18. Validations on built-in forms
19. Sending the data to DB
20. Model forms
21. Admin console
22. User Registration module
23. Login creation
24. CRUD operations
25. Integration of Mail API
26. Git
27. Hosting an application
28. Sessions and cookies
29. Flask Framework introduction