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.

Clear Filters

Search Keyword / Topic

Subject

Topic

Target Exam

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

Showing 7 matching study resource(s)

Practice Quizzes on this Subject →

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 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 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