Subject-Wise & Topic-Wise Study Library

Search and filter video links, detailed study text/notes, and standard reference books for HPSC, KVS, NVS, Programmer & Instructor exams.

Search Keyword / Topic

Subject

Topic

Target Exam

All Resources Video Lectures Study Notes / Text Reference Books PDFs / PYQs

Showing 12 matching study resource(s)

Practice Quizzes on this Subject →

Reference Book Programming (C, C++, Python)

Python Complete (KVS/NVS/HPSC Special)

Computer Science with Python (Class XI & XII NCERT + Sumita Arora)

Author: NCERT / Sumita Arora

Essential for KVS PGT CS, NVS PGT, DSSSB & HPSC PGT exams where NCERT Python, Pandas, File Handling & SQL connectivity dominate.

Exams: KVS PGT / TGT, NVS PGT CS, HPSC PGT CS, DSSSB & State CET

View Book / Resource

Reference Book Computer Networks

OSI Model & TCP/IP Protocol Suite

Data Communications and Networking (5th Edition)

Author: Behrouz A. Forouzan

Best reference book for Computer Networks: OSI layers, Data Link control, IPv4/IPv6 Subnetting, and TCP/UDP protocols.

Exams: RPSC / State Programmer, HPSC PGT CS, KVS PGT / TGT, Computer Instructor

View Book / Resource

Reference Book DBMS & SQL

Functional Dependencies & Normalization

Database System Concepts (7th Edition)

Author: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

Standard textbook from which direct theoretical & numerical questions on Normalization, SQL, and Concurrency Control are framed in HPSC & Programmer exams.

Exams: HPSC PGT CS, RPSC / State Programmer, KVS PGT / TGT, NVS PGT CS

View Book / Resource

Reference Book Operating System (OS)

Process Management & CPU Scheduling

Operating System Concepts (10th Edition - Dinosaur Book)

Author: Abraham Silberschatz, Peter B. Galvin, Greg Gagne

The gold-standard reference book for HPSC PGT CS, RPSC Programmer & GATE-level OS concepts, synchronization, and memory management.

Exams: HPSC PGT CS, RPSC / State Programmer, KVS PGT / TGT, NVS PGT CS

View Book / Resource

Study Notes Data Structures & Algorithms

Trees (Binary Tree, BST, AVL, B-Tree)

Binary Trees, BST, AVL & B-Tree Formula Cheat Sheet for Competitive Exams

All direct formulas for leaf nodes, height of binary trees, number of unlabeled binary trees (Catalan Number), and Heap time complexities.

### 1. Essential Binary Tree Formulas
1. **Maximum nodes at level L** (root at level 0): `2^L`
2. **Maximum nodes in a Binary Tree of height H** (root at height 0): `2^(H+1) - 1`
3. **Relati...

Exams: HPSC PGT CS, KVS PGT / TGT, NVS PGT CS, Computer Instructor

Study Notes DBMS & SQL

SQL Queries, Joins & Aggregate Functions

SQL Clauses Execution Order, Joins & Aggregate Functions Revision Sheet

Exact order of SQL execution, NULL handling in COUNT(*) vs COUNT(col), and Correlated Subquery shortcuts.

### 1. Logical Order of SQL Query Execution
Even though we write `SELECT` first, the database engine executes clauses in this exact order:
1. `FROM` & `JOIN` (Cartesian product and join pred...

Exams: HPSC PGT CS, KVS PGT / TGT, NVS PGT CS, RPSC / State Programmer

Study Notes Operating System (OS)

Deadlocks & Banker's Algorithm

Deadlock Necessary Conditions, Avoidance & Banker's Algorithm Complete Notes

High-yield revision notes on Coffman's 4 conditions, Resource Allocation Graph (RAG), and Safe Sequence formula.

### 1. Four Necessary Conditions for Deadlock (Coffman Conditions)
A deadlock situation can arise if and only if the following four conditions hold simultaneously in a system:
1. **Mutual Ex...

Exams: HPSC PGT CS, KVS PGT / TGT, RPSC / State Programmer, Computer Instructor

Video Lecture Programming (C, C++, Python)

Python Complete (KVS/NVS/HPSC Special)

Python One-Shot Marathon for KVS PGT, HPSC & NVS (Output Questions)

Covers Python string/list slicing with negative step, mutable default arguments, tuple unpacking, and file handling modes.

Exams: KVS PGT / TGT, NVS PGT CS, HPSC PGT CS, DSSSB & State CET

YouTube

Video Lecture Computer Networks

IPv4 Addressing, Subnetting & CIDR

IPv4 Subnetting, CIDR & VLSM Numericals Made Easy

Solve any subnet mask, host range, broadcast IP, and CIDR /26 /27 /28 question without binary conversion.

Exams: RPSC / State Programmer, HPSC PGT CS, Computer Instructor, DSSSB & State CET

YouTube

Video Lecture DBMS & SQL

Functional Dependencies & Normalization

Normalization (1NF, 2NF, 3NF, BCNF) — Find Normal Form in 30 Seconds!

Step-by-step method to find Candidate Keys using Attribute Closure and identify the highest Normal Form in exam questions.

Exams: HPSC PGT CS, RPSC / State Programmer, KVS PGT / TGT, NVS PGT CS

YouTube

Video Lecture Operating System (OS)

Process Management & CPU Scheduling

Complete CPU Scheduling (FCFS, SJF, SRTF, Round Robin) with PYQs

Master all CPU Scheduling numericals for HPSC PGT, KVS, NVS & Programmer exams with shortcut Gantt chart tricks.

Exams: HPSC PGT CS, KVS PGT / TGT, NVS PGT CS, Computer Instructor

YouTube

Reference Book Digital Logic & COA

Boolean Algebra, K-Map & Logic Gates

Digital Design & Computer System Architecture

Author: M. Morris Mano

Standard reference for Boolean Algebra, K-Map, Flip-Flops, Register Transfer, Addressing Modes, and Cache Organization.

Exams: HPSC PGT CS, KVS PGT / TGT, Computer Instructor, DSSSB & State CET

View Book / Resource