Gen AI & Data Science Bootcamp: With Practical Job Placement Support & Virtual Internship

Course Content Overview

Project 1: Hospitality Domain Data Analysis

Project 2: Expense Tracking System

Peter Pandey’s Journey and Need to Learn Python

Python Installation - Windows

Python Installation - Linux

Python Installation - Mac

How to Download Code and Get Help If I Have a Question?

Variables

Numbers

Strings

Strings - Exercise

Quiz: Variables, Numbers and Strings

Peter shares his Coding Fear with Tony

Exercise: Variables, Numbers and Strings

Chapter Summary

Lists

Install Pycharm

If Condition

For Loop

Quiz: Lists, If Condition and For Loop

Peter Found Something Interesting to Practice

Exercise: Lists, If Condition and For Loop

Chapter Summary

Functions

Dictionary and Tuples

Modules and Pip

File Handling

Quiz: Functions, Dictionaries, Tuples and File Handling

Peter’s Request to Tony

Exercise: Functions, Dictionaries, Tuples and File Handling

Two Deadly Viruses Infecting Learners

Chapter Summary

Classes and Objects

Operator Overloading

Inheritance

Exception Handling

__main__ Function

Quiz: Classes, Exception Handling

Using Python in a Real Time Problem

Exercise: Classes and Exception Handling

Chapter Summary

Introduction and Benefits

Basic Operations

Matrix Operations

Slicing, Stacking

Quiz: NumPy

Peter Solves a Real Time Problem Using NumPy

Exercise: NumPy

Chapter Summary

Pandas Introduction and Installation

Dataframe Basics

Read, Write Excel and CSV Files

Handle NA values - Part 1

Handle NA values - Part 2

Group by

Concat and Merge

Data Visualization Using Matplotlib and Seaborn

Quiz: EDA using Python

Problem Statement, OLTP vs OLAP, ETL, Data Warehouse

Data Understanding: CSV Files

Data Understanding: Fact vs Dim table, Star vs Snowflake Schema

Data Exploration

Data Cleaning

Data Transformation

Insights Generation

Introduction

Set and Frozenset

Lists, Dict and Set Comprehensions

Quiz: Comprehensions and Sets

Peter gets Adhoc tasks on Advanced Topics

Exercise: Comprehensions and Sets

PEP8 Naming Convention

Code Debugging Using PyCharm

Chapter Summary

Working with JSON

Generators and Iterators

Decorators

Quiz: JSON, Generators and Decorators

Exercise: JSON, Generators and Decorators

Chapter Summary

What is API?

Calling APIs With requests Package

Building APIs With FastAPI

Quiz: APIs

Peter fetches data using APIs

Exercise: APIs

Chapter Summary

Logging

Automated Testing with Pytest

MySQL Setup: Windows

MySQL Setup: Linux, Mac

Working with MySQL in Python

Data Validation with Pydantic

Quiz: Logging, Pytest, Pydantic and Databases

Exercise: Pytest, Pydantic

Chapter Summary

Problem Statement & Tech Architecture

Database CRUD Operations

Automated Tests Setup for CRUD

Expense Management: Backend (FastAPI)

Expense Management: Logging

Streamlit Introduction

Expense Management: Frontend (Streamlit)

Analytics: Backend (FastAPI)

Analytics: Frontend (Streamlit)

README and Requirements.txt

Exercise

Final Quiz

Transition to Online Credibility

Introduction to online credibility / open-source contribution

Set Up Your LinkedIn Profile

LinkedIn Banners

Add your Python Project to GitHub

Share Your Python Skill to the World

Knowledge Check

Checkpoint

Install MySQL: Windows

Install MySQL: Linux, Mac

Import Movies Dataset in MySQL

Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

Summary Analytics (MIN, MAX, AVG, GROUP BY)

Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)

HAVING Clause

Calculated Columns (IF, CASE, YEAR, CURYEAR)

Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)

The Data God’s Blessing

Quiz

Why do We Need Multiple Tables?

SQL Joins (INNER, LEFT, RIGHT, FULL)

Exercise - SQL Joins (INNER, LEFT, RIGHT, FULL)

Cross Join

Analytics on Tables

Join More Than Two Tables

Exercise - Join More Than Two Tables

Quiz

SQL Final Quiz

Transition to Maths and Stats

Types of Data

Pie Chart and Bar Chart

Quiz

Histograms and Line Chart

Quiz

Scatter and Bubble Plot

Quiz

Univariate vs. Bivariate vs. Multivariate Analysis

Chapter Summary

Descriptive vs. Inferential Statistics

Measures of Central Tendency: Mean, Median, Mode

Percentile

Analysis: Shoe Sales (Using Mean, Median, Percentile)

Quiz

Exercise

Measures of Dispersion: Range, IQR

Box or Whisker Plot

Outlier Treatment Using IQR and Box Plot

Quiz

Exercise

Measures of Dispersion: Variance and Standard Deviation

Analysis: Stock Returns Volatility (Using Variance and Std Dev)

Correlation

Correlation vs Causation

Quiz

Exercise

Chapter Summary

Probability Basics

Quiz

Addition and Multiplication Rule

Quiz

Conditional Probability and Bayes Theorem

Quiz

Chapter Summary

What Is a Distribution?

Skewness

Normal Distribution

Detect Outliers Using Normal Distribution

Quiz

Exercise

Z Score

Standard Normal Distribution (SND)

I Need a Favour

Quiz

Exercise

Chapter Summary

Chapter Overview

Bashneer Grower’s Bank Venture

AtliQo Credit Card Launch: Problem Statement

Project Kick-off Meeting

Project Management Using Kanban

Tasks Breakdown and JIRA Board Setup

Meeting: Tony, Peter, Natasha

Data Validation Of Acquired Data

Data Understanding, MySQL Setup

Data Import in Jupyter Notebook

Data Cleaning: Handle NULL Values (Annual Income)

Data Cleaning: Treat Outliers (Annual Income)

Data Visualization: Annual Income

Exercise: Treat Outliers in Age Column

Exercise Solution: Treat Outliers in Age Column

Data Visualization: Age, Gender, Location

Peter’s Nightmare

Data Cleaning: Credit Score Table - Part 1

Data Cleaning: Credit Score Table - Part 2

Correlation among Credit Profile Variables

Exercise: Handle NULL Values in Transactions Table

Exercise Solution: Handle NULL Values in Transactions Table

Peter’s Confusion: IQR or Std Dev?

Data Cleaning: Treat Outliers using IQR (Transaction Amount)

Data Visualization: Transactions Table

Finalize the Target Group

Phase 1 Feedback Meeting With Stakeholders

Get Ready For Phase 2

Random Sampling & Sample Bias

The Law of Large Numbers

Central Limit Theorem, Sampling Distribution

Case Study: Solar Panels

Standard Error

Quiz

Z Score Table (Z-Table)

Quiz

Confidence Interval

Confidence Interval: Estimate Car Miles

Exercise

Chapter Summary

Null vs Alternate Hypothesis

Z Test, Rejection Region

Housing Inflation Test: Rejection Region

Quiz

Exercise

p-Value

Housing Inflation Test: p-Value

Quiz

Exercise

One-Tailed vs Two-Tailed Test

Type 1 and Type 2 Errors

Quiz

Statistical Power & Effect Size

A/B Testing

A/B Testing Using Z Test

A/B Testing: Drug Trial

Quiz

Exercise

Chapter Summary

Campaign Planning

Hypothesis Testing and Decision Making

Final Stakeholder Meeting

T-test and Student’s t-distribution

Case Study - Exam Score

Chi-squared Distribution

Chi-squared Test of Goodness of Fit

Chi-squared Test of Independence

Final Quiz

Transition to Online Credibility and Domain Knowledge

Update Headline, Experience, etc, Sections on LinkedIn

How to Engage Meaningfully on LinkedIn

How to approach people on LinkedIn

List of Influencers to Follow

Resources to build domain knowledge

Knowledge Check

Checkpoint

Transition to Machine Learning

Who is Peter Pandey?

Peter Pandey’s journey to learn Machine Learning

What is Machine Learning?

Classification vs Regression

Supervised vs Unsupervised Learning

Simple Linear Regression

Multiple Linear Regression

Quiz

Exercise

Cost Function

Derivatives and Partial Derivatives

Chain Rule

Quiz

Exercise

Gradient Descent Theory

Gradient Descent: Python Implementation

Why MSE (and not MAE)?

Model Evaluation: Train, Test Split

Model Evaluation: Metrics

Peter Pandey Flexes his ML skills on LinkedIn

Quiz

Exercise

Data Preprocessing: One Hot Encoding

Quiz

Polynomial Regression

Quiz

Exercise

Overfitting and Underfitting

Reasons and Remedies For Overfitting / Underfitting

L1 and L2 Regularization

Bias Variance Trade Off

Quiz

Exercise

Chapter Summary

Introduction to Classification

Logistic Regression: Binary Classification

Model Evaluation: Accuracy, Precision and Recall

Quiz

Exercise

Model Evaluation: F1 Score, Confusion Matrix

Logistic Regression: Multiclass Classification

Cost Function: Log Loss

Quiz

Exercise

Support Vector Machine (SVM)

Data Pre-processing: Scaling

Sklearn Pipeline

Quiz (disabled)

Quiz

Exercise

Naive Bayes: Theory

Naive Bayes: SMS Spam Classification

Quiz

Exercise

Decision Tree: Theory

Decision Tree: Salary Classification

I Need a Favour

Quiz

Exercise

Handle Class Imbalance: Theory

Handle Class Imbalance Using imblearn: Churn Prediction

Quiz

Exercise

Get inspired by Peter Pandey

Chapter Summary

What is Ensemble Learning?

Majority Voting, Average and Weighted Average

Bagging

Bagging: Random Forest

Random Forest: Raisin Classification

Quiz

Exercise

Boosting: AdaBoost

Gradient Boosting: Regression Walk Through

Gradient Boosting: Regression Math

Gradient Boosting: Revenue Prediction

Quiz

Exercise

Gradient Boosting: Classification

XGBoost: Walk Through

XGBoost: California Housing Prediction

XGBoost: Synthetic Data Classification

XGBoost: Benefits

Quiz

Exercise

Chapter Summary

Introduction

Model Evaluation: ROC Curve & AUC

Cost Benefit Analysis Using ROC in Sklearn

Quiz

Exercise

K Fold Cross Validation

Stratified K Fold Cross Validation

Hyperparameter Tuning: GridsearchCV

Hyperparameter Tuning: RandomizedSearchCV

Quiz

Exercise

Model Selection Guide

Luck favors the LinkedIn post

Selecting the Right Evaluation Metric

Quiz

Chapter Summary

10 Stages of AI Project Life Cycle

Requirements and Scope of Work (SOW)

Data Collection

Data Cleaning & Exploratory Data Analysis

Feature Engineering

Model Selection & Training

Model Fine Tuning

Model Deployment

Monitoring and Feedback Using ML Ops

Chapter Summary

3 Ways of Doing Feature Engineering

Feature Selection Using Correlation

Feature Selection Using Variance Inflation Factor (VIF)

VIF: Practical Implementation (Salary Prediction)

Quiz

Exercise

Chapter Summary

Introduction

K Means Clustering: Theory

K Means Clustering: Customer Segmentation

Hierarchical Clustering: Theory

Hierarchical Clustering: Customer Segmentation

Quiz

Exercise

DBSCAN: Theory

DBSCAN: Practical Implementation

Peter AI

Quiz

Exercise

Chapter Summary

The Rise of AtliQ AI

Project Charter Meeting

Scope of Work, Task Planning in JIRA

Data Collection

Data Cleaning & EDA - Part 1

Data Cleaning & EDA - Part 2

Feature Engineering

Model Training, Fine Tunning

98% Model Accuracy, Really?

Error Analysis

Model Segmentation

Request More Data

Model Retraining

Build App Using Streamlit

Deployment

Exercise

Peter's Promotion: New Project

Domain Understanding: NBFC & Credit Approvals

Scope of Work & Tech Architecture

Data Collection

Quick Intro to Data Leakage

Data Cleaning

Exploratory Data Analysis (EDA)

Feature Engineering – Part 1

Weight of Evidence (WOE), Information Value (IV)

Feature Engineering – Part 2

Model Training & Evaluation

Introduction to Optuna

Model Fine Tuning Using Optuna

Intro To Rank Ordering & KS Statistic

Model Evaluation Using KS Statistic & Gini Coefficient

Streamlit App

Business Presentation

Deployment

Exercise

What is ML Ops?

Importance of ML Ops in Your Career

ML Flow: Purpose and Overview

ML Flow: Experiment Tracking

ML Flow: Model Registry

ML Flow: Centralized Server Using Dagshub

Quiz

What is API?

FastAPI Basics

Build FastAPI Server For Credit Risk Project

Quiz

Git Version Control System

Introduction to ML Cloud Platforms

AWS Sagemaker: Account Setup

AWS Sagemaker: Sagemaker Studio

AWS Sagemaker: 4 Ways to Train Model

AWS Sagemaker: Built In Algorithms

AWS Sagemaker: Script Mode

Quiz

Data Drift Detection Using PSI & CSI

PSI & CSI: Practical Implementation

Quiz

Final Quiz

Transition to JAP, Portfolio Website and ATS Resume

What is ATS and Why it is Important?

Build an ATS Resume using Resume Builder and Checklist

Improve the ATS Score of Your Resume

Sample Resumes

Getting Started: Creating a Portfolio Website

Add Basic Info: Intro Video

Add Basic Info: Profile Picture

Add Basic Info: About Yourself

Add Resume and Skills

Add Projects & Certifications

Generate Portfolio and Share it With Potential Recruiters

Create Your Own Posts

Advanced Hacks

Knowledge Check

Checkpoint

Transition to Deep Learning

Neural Networks: The Foundation of Deep Learning

Deep Learning vs Statistical ML: When to Use What?

Neural Network Architectures

Real World Applications of Deep Learning

Tooling: PyTorch vs Tensorflow

Tooling: GPU, TPU

Quiz

Chapter Summary

What is Neuron?

Perceptron and Multilayer Perceptron (MLP)

Neural Network Intuition: Insurance Prediction

The Purpose of Activation Function

Activation Functions: Sigmoid, ReLU, Tanh, SoftMax

Quiz

Chapter Summary

PyTorch Installation

Matrix Fundamentals

PyTorch Tensor Basics 1

PyTorch Tensor Basics 2

Derivative and Partial Derivative

Chain Rule

Autograd in PyTorch

Numpy Arrays vs PyTorch Tensors

Quiz

Exercise

Chapter Summary

Training through Backpropagation

Gradient Descent: Theoretical Foundation

Gradient Descent: PyTorch Implementation

Batch GD vs Mini Batch GD vs SGD

Mini Batch GD and SGD: PyTorch Implementation

Quiz

Exercise

Chapter Summary

Employee Bonus Prediction

Datasets and DataLoaders

Handwritten Digits Classification

Classification Report and Confusion Matrix

Cost Function: Binary Cross Entropy (a.k.a. Log Loss)

Cost Function: Cross Entropy

Quiz

Exercise

Chapter Summary

Model Optimization Overview

Exponentially Weighted Moving Average

Gradient Descent with Momentum

RMSprop

Adam

Optimizers in Action with Fashion MNIST

Quiz

Exercise

Chapter Summary

What is Regularization?

Dropout Regularization

L1, L2 Regularization

Batch Normalization

Early Stopping

Quiz

Exercise

Chapter Summary

What is Hyperparameter Tuning?

GridSearchCV, RandomSearchCV

Optuna

Quiz

Exercise

Chapter Summary

What is CNN? Convolution, Kernels, Pooling and Beyond

Padding and Strides

CIFAR10 Image Classification using CNN

Data Augmentation

Transfer Learning

Pre-trained Models – ResNet, EfficientNet, MobileNet etc.

Caltech101 Classification Using Transfer Learning

Quiz

Exercise

Chapter Summary

Sequence Models

RNN in Depth

Types of RNN

Vanishing Gradient Problem

LSTM

GRU

Quiz

Chapter Summary

Introduction to Transformer Architecture

Word Embeddings

Contextual Embeddings

Overview of Encoder and Decoder

Tokenization, Positional Embeddings

Attention Mechanism

Multi Headed Attention

Decoder

How Transformers are Trained?

Hugging Face: BERT Basics

Hugging Face: Spam Classification Using BERT

Hugging Face: Next Word Prediction Using GPT2

Quiz

Exercise

Chapter Summary

AtliQ AI’s First Big Client: Vroom Cars

Problem Statement & SOW

Data Load and Transformation

Model Training with CNN

Model Training with CNN and Regularization

Model Training using Transfer Learning

Hyperparameter Tunning using Optuna

Model Evaluation and Export

Streamlit App

FastAPI Server

Quiz

Transition to NLP

Tokenization Techniques

Tokenization in Spacy

Language Processing Pipeline in Spacy

Stemming & Lemmatization

Part of Speech (POS) Tagging

Stop Words

Named Entity Recognition (NER)

Regular Expressions (Regex)

Quiz

Exercise

Chapter Summary

Introduction to Text Representation

Label and One Hot Encoding

Bag of Words (BOW)

Bag of n-grams

TF-IDF

Word Embeddings: Theoretical Foundation

Word Embeddings in Spacy

News Classification using Spacy Word Embeddings

Quiz

Exercise

Chapter Summary

Introduction to Hugging Face

Pipelines

BERT, DistilBERT, RoBERTa, ALBERT

Tokenizers

Model Fine Tuning

Quiz

Exercise

Chapter Summary

Final Quiz

Transition to Gen AI

What is Generative AI?

Traditional AI vs Gen AI

What are AI Agents and Agentic AI?

Gen AI vs AI Agents vs Agentic AI

Real-world Applications for Gen AI & Agentic AI

Steps to Build Gen AI and Agentic Applications

Quiz

Exercise

Chapter Summary

What are Large Language Models?

How LLMs Work?

Context Window, Temperature, Top-p and Top-k

Challenges: Hallucinations, Security and Cost

What is a Vector Database?

What is RAG (Retrieval Augmented Generation)?

Quiz

Exercise

Chapter Summary

Elements of a Good Prompt

Zero-Shot, One-Shot, and Few-Shot Prompting

LangChain Installation

Groq and Ollama Setup

Calling LLM from Langchain

Prompt Templates & Chains

Output Parser

Build Financial Data Extraction App

Quiz

Exercise

Chapter Summary

Chromadb: Introduction and Installation

Basic Operations in Chromadb

Add, Update, Delete, Query

Metadata Filtering

Euclidean and Cosine Distance

Quiz

Exercise

Chapter Summary

Problem Statement

RAG Based Technical Architecture

Document Loaders

Text Splitters

Store Data in Vector Store (Chroma DB)

Retrieval and Answer Generation

Streamlit UI

Learning Lessons

Exercise

Problem Statement

SOW & Technical Architecture

Implement FAQ Handling

Routing using semantic-router

Streamlit UI: FAQ Handling

SQLite Database Setup

Implement Product Handling: SQL Query Generation

Implement Product Handling: Data Comprehension

Streamlit UI: Product Questions Handling

Bonus: Web Scraping

Exercise

Agency in AI

Build Your First Agent using Llama and Agno

Agent with Custom Tool

What are Reasoning Models?

Building a Reasoning Agent with Agno

Multimodal Agent

Other Frameworks: Smolagents, Google ADK

Quiz

What is Model Context Protocol (MCP)?

Build Your First MCP Server: Leave Management

Prebuilt MCP Servers

What is A2A Protocol?

Quiz

Exercise

Build Your First Multi Agent Program

When to consider Multi-Agent Systems?

Design Patterns for Multi-Agent Systems

Route Agent

Quiz

Introduction to Agentic AI Evaluation

Functional Evaluation

Hands on Functional Eval in Agno

Safety and Guardrails

Operational Metrics

Hands on Perf Eval in Agno

Quiz

Problem Statement & Tech Architecture

HR Management System (HRMS) APIs

Seed Data for HRMS

MCP Tools for Employee Management

Google App Password Setup for Emails

MCP Tools for Emails

MCP Prompt to Onboard a New Employee

MCP Tools for Tickets Management

Exercise

Introduction to Fine-Tuning

Low-Rank Adaptation (LoRA)

Quantization Basics

QLoRA

Fine-Tuning Llama with Unsloth

Quiz

Exercise

Ethical Challenges in Gen AI

Hallucination and Misinformation

Bias

PII and Privacy Laws

Environmental Impact

Copyrights and Intellectual Property

Quiz

Chapter Summary

Final Quiz

LangGraph Tutorial Bonus

Transition to Interview Preparation, Job Application and Virtual Internships

Introduction to the Job Application Playbook

Interview Question Bank: Technical

Transition to Virtual Internship - (Trust the process)

Welcome Note

Your Onboarding Letter

Welcome Note from Your Manager

Let's Dive Right Into Week 1!

Getting Help From Your Mentors / Seniors

Your First Task

Incoming Task Email 1

Have You Completed This Task?

Quality Check 1

Quality Check 2

Quality Check 3

Quality Check 4

Quality Check 5

Quality Check 6

Quality Check 7

Quality Check 8

Quality Check 9

Quality Check 10

Congratulations, You Have Completed the First Task of Your Internship.

Your Second Task

Incoming Task Email 2

Have You Completed the Assigned Task?

Presentation Submission (Visualization Task)

Congratulations! You Have Completed 2 Tasks in a Row!

You Need Scrum Training

Incoming Task Email 3

Have You Completed the Assigned Task?

Scrum Knowledge Check

Congratulations, You Have Completed Week 1 Successfully.

Let's Dive Right into Week 2!

Can You Handle this Project?

Incoming Task Email 1

Have You Completed the Assigned Task?

Quality Check 1

Quality Check 2

Quality Check 3

Quality Check 4

Quality Check 5

Quality Check 6

Quality Check 7

Quality Check 8

Quality Check 9

Quality Check 10

Congratulations on Finishing This Task!

SQL Query Debugging

Incoming Task Email 2

Quality Check 1

Quality Check 2

Quality Check 3

Quality Check 4

Quality Check 5

Quality Check 6

Quality Check 7

Quality Check 8

Congratulations on Successfully Completing the Task!

Let's Dive Right into the Final 2 Weeks!

Can You Step Up for a Client Task?

Incoming Task Email: Data Cleaning

Please Don't Share Datasets

Have You Completed the Data Cleaning?

Quality Check 1

Quality Check 2

Quality Check 3

Quality Check 4

Incoming Task Email: Feature Engineering

Have You Completed the Feature Engineering Task?

Quality Check 1

Quality Check 2

Quality Check 3

Quality Check 4

Let's Start Predictive Modeling

Incoming Task Email: Predictive Modeling

Have You Completed the Modeling Task?

Quality Check

Incoming Task Email: MLflow Deployment

Submission of DagsHub link | ML flow

Incoming Task Email: Streamlit App Development

Have You Completed the Streamlit App Development?

Can You Present to Client?

Presentation Submission (CodeX Project)

End Note

Get Your Letter Of Completion

Let's Dive Right Into Week 6!

Can We Try an Alternative approach

Incoming Task Email 1

Have You Completed This Task?

Quality Check 1

Quality Check 2

Congratulations on Finishing This Task!

Incoming Task Email 2

Have You Built the Streamlit App for Client Demo

Manage Your GitHub Reporsitory

Have you pushed your code to GitHub?

Congratulations on Successfully Completing the Task!

Let's Dive Right Into Week 7!

Business Context

Incoming Task Email 1

Have you completed this task?

Congratulations you have completed the first task of Week 7

Incoming Task Email 2

Have you completed this task?

Congratulations, You Have Completed Week 7 Successfully.

Let's Dive Right Into Week 8!

Create a Streamlit UI

Incoming Task Email 1

Have you completed the Streamlit UI?

Manage Your GitHub repository

Have you pushed your code to GitHub?

End Note

Get Your Letter

Text Classification: Support Ticket Prioritization

Image Classification: Crop Yield Detection New

RAG-Based Gen AI: ChatGPT for Private Organizational Data

Chatbot: Food Delivery Chatbot

LLM Powered Real Estate Chatbot New

Recommendation System: Book Recommendations

Intro: How to use this supplementary learning

Statistical ML Project: Build a House Prediction System

Deep Learning Project: Build a Potato Disease Classification System

NLP Project: Build a chatbot using Dialog Flow

Gen AI Project: Build a news research tool in finance domain

Subqueries

ANY, ALL Operators

Co-Related Subquery

Exercise: Subqueries

Common Table Expression (CTE)

CTE Benefits & Other Applications

Exercise: CTE

Peter Pandey Flexes his SQL Skills

Quiz

Database Normalization and Data Integrity

Entity Relationship Diagram (ERD)

Mentor Talk: Art of Googling

Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)

Data Types: String (VARCHAR, CHAR, ENUM)

Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)

Data Types: JSON, Spatial (JSON, GEOMETRY)

Luck Favors the LinkedIn Post

Primary key

Foreign Key

Create a Database From an Entity Relationship Diagram - ERD

Import Data From a CSV File Into a Database

Insert Statement

Update and Delete

I Need a Favour

Expect the Unexpected: The Intermission Scene

Quiz

The Rise of Databases at AtliQ

Relational vs No-SQL Database

AtliQ Hardware’s Business Model

Profit & Loss Statement

ETL, Data Warehouse, OLAP vs OLTP, Data Catalog

Fact vs Dimension Table, Star vs Snowflake Schema, Data Import

Simplified: What is Kanban?

Quiz

Backlog Grooming Meeting: Gross Sales Report

User-Defined SQL Functions

Exercise: User-Defined SQL Functions

Gross Sales Report: Monthly Product Transactions

Gross Sales Report: Total Sales Amount

Exercise: Yearly Sales Report

Stored Procedures: Monthly Gross Sales Report

Stored Procedure: Market Badge

Benefits of Stored Procedures

Quiz

Problem Statement and Pre-Invoice Discount Report

Performance Improvement # 1

Performance Improvement # 2

Database Views: Introduction

Database Views: Post Invoice Discount, Net Sales

Exercise: Database Views

Top Markets and Customers

Exercise: Top Products

The Two Most Important Skills for the Data Analyst

Window Functions: OVER Clause

Window Functions: Using it in a Task

Exercise: Window Functions: OVER Clause

Window Functions: ROW_NUMBER, RANK, DENSE_RANK

Exercise: Window Functions: ROW_NUMBER, RANK, DENSE_RANK

5 Ways SQL is Used in the Industry

Quiz

Supply Chain Basics : Simplified

Problem Statement

Create a Helper Table

Database Triggers

Database Events

Temporary Tables & Forecast Accuracy Report

Exercise: CTE, Temporary Tables

Subquery vs CTE vs Views vs Temporary Table

User Accounts and Privileges

Database Indexes: Overview

Database Indexes: Composite Index

Database Indexes: Index Types

Peter Pandey's Order: I Have Completed the Course - Now What?

Quiz

Final Quiz

Gen AI and DS Bootcamp Monthly Webinar - June 2025 NEW

Gen AI & DS Bootcamp Monthly Webinar - May 2025

DS Bootcamp Monthly Webinar - April 2025

How to use Discord

How to Stand Out in the Job Market Through Open Source Contributions