Syllabus
Syllabus
- 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)
- 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
- MySQL Server Installation
- MySQL Workbench Installation
- MySQL Basics
- Database models
- ER Model Overview
- Data types
- Understanding Test Database
- Basics Queries
- DDL
- Tables - Create, Alter, Drop
- Constraints - Not Null, Primary Key, Unique Key, Foreign Key
- Indexes - Types, Create, Drop
- DML operations - Insert, Update & Delete
- Insert, Update, Delete & Truncate
- Common Operations
- Writing Queries
- Filters
- DISTINCT
- BETWEEN
- IN
- LIKE
- NOT
- NULL
- AND, OR, NOT etc
- Using Complex Data Filtering Techniques
- Limit, offset
- Sorting
- Ascending Order
- Descending Order
- Complex Sorting
- Functions
- String Functions - lower case, uppercase, substring, instring, trim, group_concat etc.
- Number Functions - round and trunc
- Date Functions - datepart etc
- Null Functions - NULLIF
- Case
- Groups
- Basics
- Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
- Grouping Filters - HAVING
- Rollups & Cubes
- Analytic (Window) Functions (Bonus)
- Over() with summary functions
- Partition By Queries
- ROW_NUMBER()
- RANK()
- DENSE_RANK()
- Joins
- Cartesian Product
- Equi and Non-Equi Joins
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Self Join
- Complex Queries - Joins & Groups Integration
- SET Operators
- Union
- Union All
- Intersect
- Minus
- Subquery
- Single Valued Sub Query
- Multi Valued Sub Query
- Views
- Inline Views
- TOP N Analysis
- Bulk Operations
- Required to create test data:
- Creating Tables using queries
- Bulk Data Inserts using Queries
- Updating Data using Queries
- Deleting Data using Queries
- Transactions ( T SQL)
- Commit
- Rollback
- Savepoint
- Procedures and Functions basics
- Project
- 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
- 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
- Note - It is advanced and latest Python APIs and MVC application development framework. Pre-requisite - DJango. Duration - 1 to 1.5 months
- Introduction
- Routing
- Request Handling
- Data Validation with Pydantic
- Form and Input Handling
- File Uploads and Downloads
- User Authentication with JWT
- Cookies and Headers
- Database Integration with SQLAlchemy
- CRUD Operations with Database
- REST API Design Best Practices
- Frontend Integration
- Project
- Pre-requisite: Web Designing
- Introduction
- Installing Node.js
- VS Code Configuration Creating React App
- Folder Structure
- JSX Syntax
- Creating Components
- Class & Functional Components
- Using Components
- Event Handling
- On Click
- On keyup
- On change
- On keypress
- On keydown, etc.
- Adding CSS
- Adding Bootstrap
- Properties
- Router
- Hooks
- useState
- useEffect
- useParam
- useLocation etc
- Working with Forms
- Rest API with React
- React with Backend (php / Node.js)
- CRUD Operations
- Redux
- AXIOS
- Taiwind CSS
- Project
- Pre-requisite: React. Duration 3 weeks to 1 month
- Introduction
- What is Next.js?
- Next.js vs React
- What is SSR in Next.js?
- Core Features
- Pre-Rendering (SSG vs SSR overview)
- Installation & Project Setup
- Install Node.js
- Install Next.js
- Starting Next.js Server
- Folder Structure
- Routing
- Data Fetching & Rendering
- Functions & APIs
- NextRequest
- NextResponse
- API Routes
- Metadata & SEO
- generateMetadata()
- generateImageMetadata
- Image Imports & Optimization
- Database Integration With MongDB & Perform CRUD Operations
- Styling Support
- Project
- 7 months (can be completed little earlier, please contact with our counsellors for more info)
- Upcoming Batches
- Get Fees
