Week Topic Subtopic MileStone / Projects Column 6 Column 1

Introduction to Linux OS
- Basic Commands of linux os
- Vi editor
- Tar Archieve
- User Management and permission
Week 1 Linux and GitHub
Github - Version control system
- Git vs GitHub
- Git commands
- Git Branches
- Branching and merging
- Git push vs pull commands
- Understanding programming language
- Data types
- Variables
Week 2 C Programming & logic building - Variables scope - Local, Global
- Constants
- Operators Decision making statements,
- if Statement , if..else, Switch
- Looping statement
- Different type of loops
Week 3 C Programming & logic building Test on C programming
- While Loop , Do-While Loop , for-loop,
- Basic I/O functions
- Introduction to Python
- Data types Install Python => [Link]
Week 4 Deep dive to Python Programming - Immutable vs Mutuable data types
- String formatting & slicing Jupyter-Notebook => [Link]
- Conditional Statements
Data type =>
- Introduction to looping statement
[Link]
- for loop vs While loop
- String Data type
Problems on If-else => [Link]
Week 5 Deep dive to Python Programming - String manipulation Python MCQ Test - 50 Questions
- Sequential Data type
Loops => [Link]
- List Vs Tuple
- Problem solving with List datatype
Pattern programming => [Link]
Dictionary & Sets
- In-built functions related to the sequential datatypes
- List comprehension , set and dictionary comprehension
- Problem solving with datatype
Leetcode => [Link]
Introduction to functions
Week 6 Deep dive to Python Programming Leetcode => [Link]
- Inbuilt vs user-defined functions
- Type of parameter passing in functions
Leetcode => [Link]
- Functions vs Lambda functions
- Exception Handling
- File Handling
- Generators & Iterators
[Link]
OOPS concepts
- Introduction to oops concepts [Link]
- Creating your first class & objects
Week 7 Deep dive to Python Programming Milestone : Hackerrank 5 star
- Inheritence, polymorphism, abstraction, encapsulation
- Use cases of __init__ and __main__ [Link]
- Advanced topics of Python
[Link]
NumPy basics & array manipulations
- Pandas Series, DataFrames, indexing, merging,
Week 8 Advanced Python for Data Science
- Grouping
- Matplotlib & Seaborn (basic plots, customization)
Week Topic Subtopic MileStone / Projects Column 6 Column 1
- Supply Chain Analysis
Week 9 Project Using Pandas , Data Visuallization Employee Attrition Prediction using ANN
- Product Reviews Sentiment Analysis
Introduction to Feature Engineering
- Normal distribution of data
Feature Engineering I - Standardization vs Normalization
Week 10 Image Classification using Pre-trained Models
- Encoding Techniques:
- Label Encoding
- Ordinal Encoding
OneHot Encoding, get_dummies

- ColumnTransformer
Week 11 Feature Engineering II
- Pipelines in sklearn
- FunctionTransformer
- Feature Selection (basic)
Linear Regression & Logistic Regression

Week 12 Supervised ML Models - Decision Tree & Random Forest

- SVM basics
- Naive Bayes
- Bagging, Boosting, Voting Classifier
- K-Means Clustering
Week 13 Ensemble Learning & Unsupervised ML
- PCA (Dimensionality Reduction)
- Apriori Algorithm (Association Rules)
- Gradient Descent (GD)
Week 14 Gradient Descent Techniques - Stochastic GD
- Mini-Batch GD
- ANN Architecture, Layers, Weights, and Biases
- Activation Functions: sigmoid, relu, tanh, softmax
Week 15 Introduction to Deep Learning & ANN
- Optimizers: SGD, Momentum, NAG, RMSProp, AdaGrad

What is Image Data?

CNN Architecture: Padding, Stride, Kernel, Feature Maps

Week 16 CNN - Convolutional Neural Networks Transfer Learning with Pre-trained models:

MobileNetV2

VGGNet
What is Sequential Data?

RNN Workflow
Week 17 RNN, LSTM, GRU
LSTM vs GRU

Padding, Masking in sequences

Text Cleaning & Preprocessing

Tokenization, Stopwords, Lemmatization

Week 18 NLP & Generative AI Word Embeddings: Word2Vec, TF-IDF, GloVe

Transformers Architecture & Workflows

LangChain: Data loading, Vector DBs, LangGraph

Week Topic Subtopic MileStone / Projects Column 6 Column 1

FastAPI
Blog Generation using Bedrock + Lambda
Vector DBs: FAISS, Chroma
Week 19 Production & Generative AI Projects + AWS Chatbot with Gemini + Streamlit + Docker + PostgreSQL
AWS Stack: EC2, Lambda, API Gateway, RDS, SageMaker, Bedrock
Three-tier Project Architecture using AWS MCP
CI/CD, Docker, Kubernetes
Week 20 Interview preparation and mock round Test and milestone acheivement week
- Introduction to Excel
- HLookup vs VLookup
Week 21 Walkthrough on Microsoft Excel - Basic Functions
- Advance Function
- Pivots and visualization
- Introduction to E-R diagram
- Understanding entity and relationship
- Working with symbols Install mysql database => [Link]
- Type of relationship and data models
Importing Sakila Database => [Link]
Week 22 SQL Mastery - Beginners to Advanced - Defining Database
- Type of databases Select Statement => [Link]
- DBMS vs RDBMS
- Installing MySQL database Reading wildcard character => [Link]
- Type of SQL statements
- Select statement
- Operators in SQL
- SQL querying statement
[Link]
- String , date, number functions
- Working with aggregation functions
Week 23 SQL Mastery - Beginners to Advanced SQL function => [Link]
- Group by statment
- Where vs having clause
String functions=> [Link]
- Sorting data in SQL
- Advanced sorting and aggregate functions
Subquery
- Type of subqueries
- Advanced subquery
Joins SQLZoo => [Link]
Week 24 SQL Mastery - Beginners to Advanced Joins SQL Zoo - Practice on Chapter 1,2,3,4,5,6
- Understanding need of joins SELF JOIN QUESTIONS => [Link]
- Inner join
- Outer joins
- Self join, cross join, natural joins
- Constraints in SQL
- Type of keys [Link]
- Setting up the first constraint to your tables
Week 25 SQL Mastery - Beginners to Advanced - Normalization, types of dependencies and anomalies Link => [Link]
1NF, 2NF, 3NF and BCNF
- Conversion from 1 NF to 2NF, 3NF and BCNF Normalization => [Link]
- DDL statment - Create, Drop Alter Queries
- DML operations - insert , update and delete
- TCL commands - commit, rollback & savepoint
Week 26 SQL Mastery - Beginners to Advanced Milestone - HackerRank SQL certificate
- DCL - Grant & revoke

- Analytical functions
- Windows functions
( Partition by & Group up)
HackerRank - Gold Badge
Week 27 SQL Mastery - Beginners to Advanced
( 5 Star on HackerRank)
HackerRank - Gold Badge
( 5 Star on HackerRank)
Week Topic Subtopic MileStone / Projects Column 6 Column 1
Introduction to Indexes
- Clustured vs Non-clustured index
- Composite vs Column index
- Revision of SQL
Week 28 SQL Mastery - Beginners to Advanced
Views in SQL
- Type of views
- Complex views and it's usuage
PL/SQL
- Creating the first procedures
- Conditional statments Project - Libraray management system
- Loops BookStore Analysis
Week 29 SQL Mastery - Beginners to Advanced - What are cursor
- Types of cursor Advanced topic of SQL
- Procedure vs functions Wrapping up your SQL
- DML Triggers and Audit trigger
- Error handling and cursors
Data Engineering Foundations
- What is Data Engineering, Role in ML Systems, Tools Overview
Week 30 Data Engineering workflow with Machine learning - Role of Data Engineers in ML
- Data lifecycle & pipeline components
- Star vs Snowflake Schema
Data Ingestion & Storage
- File Ingestion (CSV, JSON, APIs)
Week 31 Data Engineering workflow with Machine learning
- Cloud Storage: AWS S3 / GCS
- Scikit-learn Pipelines
- Batch vs Real-Time Inference
Week 32 Data Engineering workflow with Machine learning
- End-to-End Pipeline (Ingestion → ML → Deployment)
- What is MLlib?
- Benefits of MLlib on Databricks
Week 33 Data Engineering workflow with Machine learning - Understanding Transformers & Estimators
- Handling missing and categorical data
- Supervised Learning Algorithms
- What is Power BI?
- Power BI Components (Desktop, Service, Mobile)
- Workflow in Power BI
- Installation & Setup
Week 34 Data Analysis & Reporting with Power BI
- Cardinality in relationship
- Importing Excel, CSV, JSON, SQL Server, Web APIs
- Direct Query vs Import Mode
- Data source credentials
- Relationships between tables
- Cardinality, cross-filtering
- Creating a data model
Week 35 Data Analysis & Reporting with Power BI - Star vs Snowflake schema
- Applied Steps
- Column transformation (split, merge, fill, etc.)
- Filtering and removing rows
- Calculated Columns vs Measures
- Basic DAX functions: SUM, COUNT, DISTINCTCOUNT
- IF, SWITCH, RELATED, CALCULATE
- Syntax and rules
Projects on Power BI
- Bar, Line, Pie, Card, KPI
Week 36 Data Analysis & Reporting with Power BI
- Maps, Matrix, Tables - HR attrition, or Profit & Loss statement
- Custom visuals from marketplace - Time-series analysis with DAX

- Visual, Page, Report filters

- Slicers for Date, Category
- Syncing slicers across pages
Week Topic Subtopic MileStone / Projects Column 6 Column 1

Week 37 Revision and solving real-life use-cases

Week 38 External Mock interviews and preparation