Detailed Syllabus

1. Anatomy of Python Application
2. Structured Programming
   1. Values, Types and Variables
   2. Operators, Expressions
   3. Loops
   4. Selections
3. Procedural Programming
   1. Functions
   2. Parameters, return types
4. Objects - Based
   1. Anatomy
      1. State
      2. Structure
      3. Messages
      4. Behaviour
   2. Class
   3. Constructors
   4. Extensibility.
5. Object - Oriented
6. Exception Handling
7. Functional Programming
   1. Closures
   2. Lambda
   3. Higher Order Functions
8. Threading
   1. Modern
   2. Classical
9. Thread Synchronisation
   1. locks
   2. Conditions
10. I/O
    1. File Handling
    2. Socket Programming
11. JSON API
12. Serial Server
13. Concurrent Server
14. GUI Tk
    1. Introduction
    2. Components
    3. Geometry Manager
    4. Applications
15. Interacting with Database.
    1. SqlLite
    2. Connections
    3. Operations
    4. Login
    5. CLI-Client
16. Working with PIP
17. Introduction to virtualenv
18. Web
    1. Working with The Pallets Project Ecosystem
    2. WSGI ( Web Server Gateway Interface )
    3. Werkzeug ( WSGI Web Application Library )
    4. Flask ( Web Application Framework )
    5. Jinja 2 ( Template Engine )
    6. RESTful Architecture
19. Microservices
    1. Architectural Pattern
    2. Segregation of Services
    3. TCP based Microservices
    4. RESTful Microservices

• Content ( *English )
• Structure ( HTML )
• Style ( CSS )
• Behaviour ( Javascript )

• Page Anatomy
• Tag Entities
• Attributes
• Body
• Page Elements
• Forms
• Audio/Video
• SVG

• Box Model and Flow
• Groupings
• Layout
• Media
• Animation
• DOM
• Node and their Types
• Styles
• Traversals
• Event Flow
• Ranges

1. Prototypal Model

2. Functions

3. Structured Programming

4. Procedural Programming

5. Browser / DOM

6. Event Handling

1. Introduction to Database
   1. Anatomy of Database Systems
   2. Application of Database Systems
   3. Stake Holders
      1. Users
      2. Administrators
      3. Programmers
   4. Client/Server Architectures
   5. Distributed Databases
   6. History
2. Modelling
   1. Semantic
   2. Logical
   3. Physical
3. File System
   1. Organization of File System
   2. Database System v/s File System
4. Types of Database Systems
   1. Hierarchical
   2. Network
   3. Relational
   4. Object-Relational
   5. Object-Oriented
   6. No-SQL
5. ER Modelling
   1. Entity
   2. Relationships
   3. Types of Entities and their Relations
   4. Design Considerations
   5. Applications
6. Relational Modelling
   1. Introduction to Relational Algebra
   2. Anatomy of Relational Model
   3. Design Issues
   4. Normalization
   5. Applications
7. Principles of Data-Storage and Querying
   1. Storage & File Structures
   2. Indexing
   3. Query Processing
   4. Query Optimization
8. Structured Query Language
   1. Introduction to SQL
   2. Data Definition
   3. Data Types
   4. Creating , Manipulating and Dropping Databases
   5. Creating , Manipulating and Dropping Tables
   6. Creating , Manipulating and Dropping Views
   7. Working with Indexes
   8. Working with Constraints
9. Data Manipulation
   1. Recurring SQL constructs
      1. Select
      2. Insert
      3. Update
      4. Delete
   2. Expressions
   3. Grouping and Aggregate Functions
   4. Different types of Joins
   5. Sub-Queries and Co-related Queries
   6. Set Operations