SQL Basics: SELECT, WHERE, GROUP BY, ORDER BY

Joins: INNER, LEFT, RIGHT, FULL

Subqueries and CTEs

Window Functions and Aggregates

Using SQL for Business Reporting
Mini Project: Create a sales reporting dashboard using SQL queries on a retail database

Descriptive Statistics & Data Distributions

Probability Theory and Bayes' Theorem

Hypothesis Testing: T-test, Z-test, Chi-square

Correlation & Covariance

Introduction to Linear Regression
Mini Project: Perform statistical analysis and A/B testing for an e-commerce website

Data Visualization Principles

Creating Dashboards with Power BI or Tableau

Using Filters, Parameters, Slicers

Storytelling with Data

Publishing and Sharing Reports
Mini Project: Build an interactive sales dashboard for a fictional company

Linear & Logistic Regression

Decision Trees, Random Forest, KNN

Evaluation Metrics: Accuracy, Precision, Recall, F1 Score

Cross Validation and Model Tuning

Feature Selection and Scaling
Mini Project: Predict customer churn using telecom dataset

Clustering: K-Means, Hierarchical Clustering

Dimensionality Reduction with PCA

Anomaly Detection Techniques

Association Rule Mining

Market Basket Analysis
Mini Project: Perform customer segmentation for a retail business

Neural Network Architecture & Activation Functions

Backpropagation and Gradient Descent

Regularization Techniques: Dropout, L1/L2

Introduction to TensorFlow/Keras

Model Evaluation and Tuning
Mini Project: Build an image classification model using MNIST dataset

Text Preprocessing: Tokenization, Lemmatization, Stopwords

Bag of Words, TF-IDF, Word Embeddings

Sentiment Analysis and Topic Modeling

Named Entity Recognition (NER)

Text Classification with ML
Mini Project: Sentiment analysis on movie or product reviews dataset

Introduction to Generative AI and LLMs

Prompt Engineering Techniques

Using ChatGPT, Gemini, Claude for Automation

Applications in Content Creation, Resume Filtering, Report Generation

Introduction to LangChain and HuggingFace
Mini Project: Build a resume screening tool using OpenAI API and prompt templates

Basics of Model Deployment

Introduction to Streamlit and Flask

Git & GitHub for Version Control

Deploying Models on Heroku or AWS (basic)

CI/CD Concepts Overview
Mini Project: Deploy a machine learning model with Streamlit & Heroku

Capstone Project 1:
HR Analytics + GenAI

• Analyze employee data for attrition prediction

• Build an AI-based resume parser and job-fitment predictor using LLM

Capstone Project 2:
E-Commerce AI Assistant

• Create a recommendation engine

• Build a GenAI-powered chatbot that explains products & answers user queries