New HPSC PGT Computer Science, KVS, NVS & RPSC Programmer Topic-wise Video Lectures, Notes & Test Series Added! YouTube →

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
Showing 8 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 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
Video Lecture Programming (C, C++, Python)
Python One-Shot Marathon for KVS PGT, HPSC & NVS (Output Questions)
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 DBMS & SQL
Normalization (1NF, 2NF, 3NF, BCNF) — Find Normal Form in 30 Seconds!
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)
Complete CPU Scheduling (FCFS, SJF, SRTF, Round Robin) with PYQs
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

Video Lecture

Watch directly here or open on YouTube to comment & subscribe. Open on YouTube

Study Notes