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