Class 1 : Web Essentials
What is the web? | What are web servers? | How does a web application work? | What is the Internet and intranet? | Front-end and back-end development. | How data is accessed and shared via browsers | Server computers, client computers, and their communication. | Browsers and their functionalities. | Request-Response Model and how it works. | Databases and database servers | Static vs. dynamic websites and web applications. | UI/UX in web development. | Full-stack web development and its components.

Class 2 : Run your first code in Python
Introduction to Python Django. | Preparing Environment. | Writing and Running Your First Program | Playing With Simple addition, subtraction, multiplication, division. | Understanding How Python Code Works. | Python Variables | Python Comments | Data Types | Type Conversion | Checking Data Types | Mutable & Immutable Data Types

Class 1 : Functions and File Handling
Writing Functions | Function Parameters | Keyword Arguments | Return Statements | Decorator | Lambda Functions | Creating Reusable Functions | Scope: Local and Global Variables | Reading from Files | Iterator and generator

Class 2 : Handling Files and Exceptions
Writing to Files | Working with File Paths | File Methods | Handling Exceptions with Try-Except | Using Finally and Else with Try-Except | Raising Exceptions | Custom Exceptions

DSA & Problem-solving Class 2: Function and File handling | Map and Lambda Expression | Handling Exception

Class 1 : Exploring Python Modules and Packages
Creating and Using Modules | Using Built-in Modules | Installing and Using Packages with Pip | Python Standard Library Overview

Class 2 : Handling Dates JSON and APIs
Working with Dates and Times | Working with JSON Module | Working with HTTP Requests | Consuming APIs with Requests

Class 1 : SQL Basics
What is SQL, its applications, and types of databases (Relational vs. Non-relational) | Setting up MySQL or SQl server | Tables, Rows, Columns, and Keys (Primary, Foreign, Composite). | SELECT statements, filtering with WHERE | functions like COUNT(), SUM(), AVG(), MIN(), and MAX() | IN, NOT IN, AS

Class 2 : Sorting , Filtering & Joins
ORDER BY, ASC/DESC, and LIMIT | LIKE, %, and _ | data types (INT, VARCHAR, DATE, etc.) | Aggregating data with GROUP BY and using HAVING | INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

DSA & Problem-Solving Class 4: Tables, Rows, Columns, and Keys (Primary, Foreign, Composite). | SELECT statements, filtering with WHERE | functions like COUNT(), SUM(), AVG(), MIN(), and MAX() | IN, NOT IN, AS

মডিউল ৭ থেকে মডিউল ৮ পর্যন্ত যা যা আলোচনা হয়েছে, সেটার উপর ভিত্তি করে থাকবে একটা বড়সড় এসাইনমেন্ট ও লাইভ টেস্ট। ঝালিয়ে নিতে পারবেন নিজেকে।

Class 1 : Strings and Conditional Statement
Strings | Formatted Strings | String Methods | Numbers and Math Operations | Operator Precedence | Math Functions | | If Statements | Logical Operators | Comparison Operators | While Loops

Class 2 : Loops and Built in Data Structures
For Loops | Nested Loops | Break and Continue Statements | Lists | List Methods | List Comprehension | Tuples | Tuple Methods | Sets | Set Methods | Dictionaries | Dictionary Methods

DSA & Problem-solving Class 1: String | Math Function | If Statement | Logical Operator | While Loop | For loop | Nested Loop

Class 1 : Python OOP Essentials
Introduction to OOP | Creating Classes and Objects | Instance Variables and Methods | Class Variables and Methods | Constructors | Static Method | Association Aggregation and Composition | Getter Setter and Read only property Using Property Decorator

Class 2 : Four Pillars of OOP
Inheritance , Types of Inheritance | Polymorphism | Method Overloading | Overriding | Encapsulation | Access Modifiers | Abstract Classes vs Interfaces | Design Patterns Singleton, Factory, Builder

DSA & Problem-solving Class 3: Inheritance , Types of Inheritance | Polymorphism | Method Overloading | Overriding | Encapsulation | Access Modifiers | Abstract Classes vs Interfaces | Design Patterns Singleton, Factory, Builder

মডিউল ১ থেকে মডিউল ৫ পর্যন্ত যা যা আলোচনা হয়েছে, সেটার উপর ভিত্তি করে থাকবে একটা বড়সড় এসাইনমেন্ট ও লাইভ টেস্ট। ঝালিয়ে নিতে পারবেন নিজেকে।

Class 1 : Subquery
UNIQUE, DEFAULT, CHECK, and FOREIGN KEY | Correlated subqueries and common table expressions (CTEs) | What are indexes, their types, and how they improve performance.

Class 2 : ER Diagram
Basics of ER Diagram | Designing a single vendor e commerce using ER Diagram

DSA and Problem-solving Class 5: UNIQUE, DEFAULT, CHECK, and FOREIGN KEY | Correlated subqueries and common table expressions (CTEs) | What are indexes, their types, and how they improve performance.

Class 1 : Basic HTML Syntax
What is HTML and Its Role in Web Development? | HTML Document Structure | Heading Tags, Paragraph, Inline tags | HTML Lists | Links and Anchor Tags | Images in HTML | HTML Tables | Comments | Block-Level vs. Inline Elements

Class 2 : Advance HTML
Forms: Basics | <select> with <option> for dropdowns | <input> types like checkbox, radio, and file | form validation with attributes like required, minlength, and maxlength | Semantic HTML Elements | attributes like id, class, style, and title | Creating a Basic HTML Webpage