arrow_back
DBMS Videos (Phase 1)
Lecture: 01 | Database Management & Warehousing | GATE Data Science & AI
Lecture: 02 | Database Management & Warehousing | GATE Data Science & AI
Lecture: 03- Intro to ER Model| Database Management & Warehousing | GATE Data Science & AI
Lecture: 04- Previous Year Questions | Database Management & Warehousing | GATE Data Science & AI
Lecture: 05- ER Model | Database Management & Warehousing | GATE Data Science & AI
Lecture: 06- ER Model | Database Management & Warehousing | GATE Data Science & AI
Relational Algebra
Tutorial: Relational Algebra Examples
Relational Algebra-Part 2
Relational Algebra-Part 3
Relational Algebra: Set Operators
RA examples
RA example using cross join
Division Operator
Tuple relational calculus
TRC Example 1
GATE CSE 2025 TRC question
Functional Dependency
Closure of an attribute
Candidate and Super Key
Candidate key example
Normalization
Decomposition
Multi Valued Dependency & 4NF
Decomposition CSE PYQ
Data Warehouse Videos (Phase 1)
What is Data Warehouse?
What is Data Engineering?
DWH vs DL vs DLH
Architecture of DWH
Multidimensioanl Modelling
Intro to Data Mining
Data PreProcessing
Data Cleaning and Integration
Data Transaformation & Reduction
Data Discretization
SQL Videos (Phase 1)
Intro to SQL
Datatypes and Constraints
Tutorial: Datatypes and Constraints Example
SQL commands part 1
SQL command part 2
SQL: Select command
SQL : Set operators
SQL : IN and NOT IN
SQL: GROUP BY and Aggregate Functions
SQL: Joins
Live Class: SQL for GATE in DATA Science
Paper 2 (IT Stream) Subject Wise Tests (Phase 1)
Database Concepts 1
Database Concepts 2
Database Concepts 3
SQL 1
SQL 2
Cyber Security 1
Cyber Security 2
Data Analytics Languages (Python / R) 1
Data Analytics Languages (Python / R) 2
Networking 1
Networking 2
DataWarehousing
Algorithms 1
Algorithms 2
Programming Concepts 1
Programming Concepts 2
Programming Concepts 3
Programming Concepts 4
Shell Programming
Paper 2 (IT Stream) Mock Tests (Phase 1)
Mock Test 1
Mock Test 2
Mock Test 3
Mock Test 4
Mock Test 5
Full Mock Test (Paper 1 & Paper 2) (Phase 1)
FMT 1
FMT 2
FMT 3
Problem Solving Videos (Phase 1)
DBMS p1
Cybersecurity P1
Data Analytics p1
oops p1
SQL P1
Cybersecurity Part 2
Algorithms Part 1
scope of variable
SQL AIMT 2 Solution
Computer Network/Networking (Phase 1)
Lecture-0 Prerequisite- Number Systems
Lecture-1 Introduction to Computer Networks
Lecture-2 Types of Networks
Lecture-3 Networking Devices
Lecture-5 TCP-IP Model
Lecture-6 OSI Model
Flow Control and Multiple Access Controls
IP Addressing and IPv4 vs IPv6
IP Support Protocols
Network Address Translation (NAT)
TCP and UDP
Ports, Sockets and Application Layer Protocols
Firewalls & IDS/IPS
Python Videos
Intro to Python course
Python part 1: Basics
Python part 2: List and Tuples
Python part 3: Sets
Python Part 4: Dictionary
IF, IF-Else Statements
FOR Loop
WHILE loop
Functions in Python
Lambda Functions
Recursion
Data Structures Videos (Phase 2)
Intro to Data Structure
Array
Queue
Double Ended Queue
Circular Queue Concept + Questions
Stack
PYQ: GATE DA Q32 (Queue)
PYQ: GATE CSE (Queue & Stack)
Linked List
Types of linked list
Trees
Binary Search Tree (BST)
PYQ: GATE CSE - BST
PYQ: GATE CSE-BST
BST Traversal techniques
BST In and post order Traversal
Binary Tree Traversal Techniques | GATE Data Science & AI| Python & DSA | GATE DA 2025
PYQ: GATE DA Q52 (binary Tree)
Important points of BT
AVL Tree
PYQ: GATE CSE : AVL Tree
PYQ: GATE DA Q16
Data Structure annotated slides
Data Structure using Python
Hashing (Phase 2)
Intro to Hashing
Closed Hashing (Chaining)
Open hashing (Linear Probing)
Open hashing (Quadratic Probing)
Open hashing (Double Hashing)
GATE DA 2025 Q18 (Hash Table)
Exercise based on Hashing
Hashing exercise solution
hashing exercise pdf
Hashing Lectures slides
Indexing (Phase 2)
What is Indexing?
Primary and Secondary indexing
Dense and Sparse indexing
B and B plus tree
B tree insertion (odd order)
B plus tree insertion (odd order)
B tree insertion (even order)
B plus tree insertion (even order)
Indexing annotated slides
Algorithms Videos (Phase 2)
Intro to Graphy theory
Types of Graph
Topological Sorting
PYQ CSE : Topological Sorting
PYQ DA 51
Basic Graph Traversal
Depth First Search (DFS)
DFS Edge Classification
DFS using Python
GATE DA 2025 Q65 (Graph Theory & DFS)
DFS Example
Breadth First Search (BFS)
PYQ CSE : BFS Example
BFS vs DFS
PYQ Q44 DFS and BFS
Tutorial 1- BFS DFS
Spanning Tree
Minimum Spanning Tree
Kruskal algorithm
Prim's algorithm
Shortest path : Dijkstra algorithm
Dijkstra Example
Graph Theory Notes
Data Structures & Algorithms Notes
Python Jupter Notebook
Annotated Slides
Sorting, Searching, Divide & Conquer Algorithms (Phase 2)
Linear Search
Binary Search
PYQ: GATE DA Q40
GATE DA 2025 Q27 (Binary Search)
Selection sort
Python Implementation of Selection Sort
Insertion Sort
Python Implementation of Insertion Sort
GATE DA 2025 Q29 (Insertion sort)
Bubble Sort
Python Implementation of Bubble Sort
Bubble Sort Algorithm Using Python | Programming, Data Structures and Algorithms Course | GATE DA
PYQ: GATE DA Q45
Divide and Conquer Technique
Merge Sort
merge sort vis
Quick Sort
Quick Sort using Python
Quick Sort example
PYQ: GATE DA Q30
Linear and Binary Search annotated Slides
PDSA-Search Algo
Sorting Algorithm
String Manipulation Videos (Phase 2)
Slicing in Python
String Manipulation (Length)
Intro to Regular Expression (Regex)
Regex in Python
Search and Match regex function
findall function (regex)
sub and split (regex) functions
String Functions in Python
Data Structures (Matrix & JSON)
Matrix Part 1
Matrix Part 2
json file
json example
OOPs Concepts
1. Intro to oops
2. class and object in python
Class & Objects - OOPs
3. Inheritance
4.Encapsulation
5. Abstraction
6. Polymorphism
Pattern Searching Algo (Phase 2)
1. Naive approach
2. KMP Algorithms
3. Rabin–Karp algorithm
Practice Questions (Pattern Search Algo)
SEBI IT Phase 2 Problem Solving Videos
Backtracking Concept
Stack Data Structure
Indexing (B+ tree)
Binary Search Tree
Phase 2 Practice Questions
Array, Queue, Stack & Linked List
Indexing
Binary Tree & BST
Hashing
String Manipulation
Sorting & Searching Algorithms
Greedy & Divide and Conquer Algorithms
Phase 2 Topic Wise Tests
Data Structure Test 1
DS Test 1 Video Solution P1
Data Structure Test 2
String Manipulation Test 1
Algorithms Test 1
String Manipulation Test 2
Algorithms Test 2
Data Structure Test 3
Data Structure Test 4
Algorithms Test 3
Algorithms Test 4
Data Structure Test 5
Algorithms Test 5
Object Oriented Programming Test 1
Object Oriented Programming Test 2
Object Oriented Programming Test 3
Phase 2 Paper 2 Mock Tests
Phase 2 FMT 1
Phase 2 FMT 2
Phase 2 FMT 3
Phase 2 FMT 4
Phase 2 : English (Descriptive Tests)
English DT 1 (attempt before 16th feb, 11pm)
English DT 2 (attempt before 18th feb, 11pm)
Download PDF Notes
Cyber Security Notes
Database Concepts Notes
DBMS GATE DA Notes
Networking Sebi_piyushwairale
Datawarehousing SEBI_piyushwairale
OOPs Concepts SEBI_piyushwairale
Graph Theory_piyushwairale
DSA_piyushwairale-4-44
Data Analytics_SEBI_Piyushwairale
Shell Programming_sebi_pw
Programming Concepts SEBI Piyush Wairale
String Manipulation notes (Phase 2)