Syllabus

MySQL
  • Learn both MySQL & Adv. MySQL
  • MySQL & Database Basics
  • Installation
    • Server
    • Workbench (client)
  • DDL - Data Definition Language
    • Tables - Create, Alter, Drop, Auto Increment
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Index - Why required, Create, Drop
  • DML - Data Manipulation Language
    • Insert, Update, Delete & Truncate
  • Transactions (T SQL)
    • Commit
    • Rollback
  • DQL - Data Query Language (Select)
  • Filters
    • Operators - <, <=, >, >=, =, !=
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT
    • Multi conditions filtering
    • DISTINCT
    • Limit, offset
  • Sorting
    • Ascending Order
    • Descending Order
    • Multi Column Sorting
  • Functions
    • Data, number, characters, null values etc.
    • Case
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT
    • Grouping Filters - HAVING
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued
    • Multi Valued
  • Views & Inline Views
  • Procedures
    • Programming basics - if..else, for loop
    • Procedures - create, drop
  • Functions
    • create, drop
  • Triggers
    • create, drop
  • Project

Python

  • Introduction to Python
    • What is Python? Features & uses
    • Python installation & IDE setup (VS Code, PyCharm, Jupyter, Anaconda)
    • Running Python programs (script mode vs interactive mode)
    • First program: print("Hello, World!")
  • Python Basics
    • Variables & Data Types (int, float, str, bool)
    • Input/Output functions (print(), input())
    • Comments & indentation
    • Type conversion & type() function
  • Operators
    • Arithmetic operators (+, -, *, /, //, %, **)
    • Comparison operators (==, !=, <, >, <=, >=)
    • Logical operators (and, or, not)
    • Assignment operators (+=, -=, etc.)
    • Identity operators (is, is not)
    • Membership operators (in, not in)
  • Control Flow
    • if, elif, else statements
    • Nested conditions
    • for and while loops
    • break, continue, pass
  • Data Structures
    • Strings → indexing, slicing, methods
    • Lists → create, access, update, iterate, list methods
    • Tuples → immutable collections
    • Sets → unique values, set operations (union, intersection)
    • Dictionaries → key-value pairs, methods
  • Functions
    • Defining & calling functions
    • Function arguments (positional, keyword, default, variable-length *args, **kwargs)
    • Return values
    • Lambda (anonymous functions)
    • Scope (local vs global variables)
  • Modules & Packages
    • Importing built-in modules (math, random, datetime, os)
    • Creating your own modules
    • Installing external libraries with pip
  • File Handling
    • Opening & closing files
    • Reading & writing (read(), write(), with open)
    • Working with CSV and JSON files
  • Exception Handling
    • try, except blocks
    • finally, else in exceptions
    • Raising exceptions (raise)
    • Custom exceptions
  • Object-Oriented Programming (OOP)
    • Classes & objects
    • Constructors (__init__)
    • Instance & class variables
    • Methods (instance, class, static)
    • Inheritance (single, multiple, multilevel)
    • Method overriding
    • Encapsulation & Abstraction
    • Polymorphism
    • Special methods (__str__, __len__, etc.)
  • Advanced Python Concepts
    • Iterators & Generators (iter(), next(), yield)
    • Decorators (function decorators, @staticmethod, @classmethod)
    • Regular Expressions (re module)

Adv. Python & Python Analytics

  • Working with APIs
    • Sending HTTP requests with requests
    • JSON handling
  • Database Connectivity
    • Installation
    • Basic CRUD Operations (create, read, insert, update, delete)
    • MySQL with connectors
  • Python for Automation
    • Automating tasks (file renaming, web scraping with BeautifulSoup)
    • Sending emails with Python (smtplib)
    • Working with Excel (openpyxl, pandas)
  • Python for Data Science
    • NumPy → arrays, vectorized operations
    • Pandas → DataFrames, Series, CSV/Excel handling
  • Python for Data Visualization
    • Installing Matplotlib (pip install matplotlib)
    • Basic Plots: Line chart, Bar chart, Pie chart
    • Statistical Plots: Histogram, Scatter plot, Box plot

Web Designing
  • Overview
    • About Responsive Website Designing
    • VS Code Installation
  • HTML
    • Table Tags
    • Types of Lists
    • Forms
    • Head tag & Meta tag
    • Layout
    • Classes and ID
    • Div Tag
    • Paragraph Tag
    • Formatting Tags
    • Anchor Tag
    • Quotations Tags
    • Marquee Tag
    • Image Tag
  • HTML5 Elements
    • Section Tag
    • Article Tag
    • Source
    • Header
    • Video
    • Audio
    • Keygen
    • Canvas
  • HTML 5 Validations
  • Meta Tags
    • Meta Tags - Title, Description, tags etc.
    • Header Tags - H1, H2, H3, H4, H5 etc.
  • CSS & CSS3
    • Basics
    • Background Image & Colors
    • Selectors
    • Declaration & Types
    • Fonts & Text Properties
    • Text Shadow, Gradients etc.
    • Overflow & Display Properties etc.
    • Effects - Border Raidus, Box Shadow etc
    • Box Model - Border, Margin etc
    • Units in css
    • Positions - Static, Absolute, Relative, Fixed, Sticky etc
    • Transforms - 2d & 3d Effects
    • Transitions - Color Effects
    • Animations
    • Menu & Navigation Bar
    • Chrome's Inspect Element for Desktop & Mobile for Runtime CSS Manipulations
  • CSS Media Query
    • Overview
    • Creating CSS Media Query Files
    • Device Width wise CSS Programming
  • JavaScript
    • Basics
    • Variables, Operators, Data Types etc
    • Programming
      • If-Else
      • Switch case
      • while
      • Do while
      • For Loops etc.
    • Logic Building Sessions
    • Creating Functions
    • Inbuilt Functions
      • Date
      • String
      • Numeric
    • Arrays
      • 1-D & 2-D Arrays
      • Methods
    • Objects
    • Event Handling
      • On Click
      • On Keyup
      • On Change
      • On Keypress
      • On Keydown, etc.
    • Regular Expressions
    • HTML DOM (Working with Frontend)
      • getElementById
      • getElementByClassName
      • document.write etc.
    • Js Form Validation
    • Alert box, Prompt, Confirm etc
  • jQuery
    • Basics
    • Effects
    • DOM Parsing
    • Form Validations
    • Events
    • Creating Functions
    • Inbuilt Functions
      • redirect
      • html
      • text
      • find
      • siblings
      • parents, etc
    • Dynamic CSS Programming
    • Hide and show element etc
  • Bootstrap
    • Basics
    • Introduction to Responsive Website Designing
    • Grid system
    • Card
    • Table & Table Classes
    • Texts & Text Classes
    • Image & Image Classes
    • Button & Button Classes
    • Creating Dropdown
    • Creating Loader
    • Creating Progressbar
    • Breadcrums
    • Pagination
    • List
    • Panel
    • Media Object
    • Font Awesome & Glyphy Icons
    • Forms
    • Menu & Navigation Bar
    • Carousel
    • Tooltip
    • Pop Hover
    • Scroll Spy
    • Affix
    • Bootstrap Modals - (pop ups)
    • Creating Responsive Websites in Bootstrap
    • Project
  • Project

Django
  • Basics
    • Introduction to Django & MVT (Model-View-Template) Architecture
    • Installing Django & Setting up Virtual Environment
    • Django Project vs Django App
    • Django Project Structure in depth
    • Running first Django Project (manage.py runserver)
  • MVT Application
    • Models (ORM, Field types, Relationships – OneToOne, ManyToOne, ManyToMany)
    • Views (Function-based views, Class-based views, Mixins)
    • Templates (Template tags, Filters, Template Inheritance, Static files, Media files)
    • Forms (Django forms, ModelForms, Validation)
  • Sessions & Cookies
    • Session management in Django
    • Using cookies securely
  • Database & ORM
    • Django ORM basics
    • CRUD Operations with ORM
    • QuerySet methods (filter, exclude, annotate, aggregate)
    • Transactions & Raw SQL queries in Django
    • Database migrations with makemigrations & migrate
  • Authentication & Authorization
    • Django User Model (AbstractUser & AbstractBaseUser)
    • User Registration & Login System
    • Password Hashing, Reset & Change Password
    • Permissions & Groups
    • Social Authentication (GitHub using django-allauth)
  • Advanced Features
    • Middleware (custom middleware)
    • Context Processors
    • File Uploads & Image Handling (Pillow)
    • Email sending with Django (SMTP, Gmail integration)
  • AJAX & JSON Integration
    • AJAX with Django views
    • JSON response handling
  • JWT + REST Framework (DRF)
    • Introduction to REST API
    • Serializers & ModelSerializers
    • Class-based API Views
    • ViewSets & Routers
    • JWT Authentication
    • Consuming API in Django + Postman testing
  • Bootstrap Integration
  • Project

Duration
  • Weekdays (MTTF, Wed Off) :
    Option 1 - 5.5 to 6 months - 1.5 to 2hrs/day
    Option 2 - 3.5 to 4 months - 2.5hrs/day (including 10 mins break)

  • Weekends(Sat & Sun):
    Option 1 - 6 months - 2 to 2.5hrs/day
    Option 2 - 4 to 4.5 months - 2.5 to 3hrs/day (including 10 mins break)

Fees
Show More