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.
Showing 3 matching study resource(s)
Practice Quizzes on this Subject →
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
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.
Exams: HPSC PGT CS, KVS PGT / TGT, NVS PGT CS, RPSC / State Programmer
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