Gate Subject Links

---

Topic	Playlist Link
Data Structures	DS Playlist Link
Algorithms	Algo Playlist Link
DBMS	DBMS Playlist Link
Operating Systems	OS Playlist Link
Computer Networks	CN Playlist Link
TOC	TOC Playlist Link
Complier Design	CD Playlist Link
Set Theory and Algebra	ST Playlist Link
Graph Theory	GT Playlist Link
Combinatorics	Comb Playlist Link
COA	[-]
DLD	[-]
Aptitude	[-]

Deails on Subject

Gate DBMS

• ER Model
• Conversion of ER Model to Relational Model
• Normalization and Functional Dependencies
• ACID, Transaction, Seriability and Concurrency Control
  • Serial, Non-serial and concurrent Schedules
  • Conflict Seriability
  • Testing of Seriability: Conflict Seriability[Tooplogical Sort]
  • Conflict Equivalent Schedule
  • View Seriability
  • Testing of Seriability: View Seriability
  • Problems in Concurrent Execution
  • Locking Protocols(2PL, Versions of 2PL)
  • Timestamp Protocol
  • Strict Timestamp Protocol
  • Thomas Write Rule
  • Checkpoint Algorithm
  • Multiple Granuality Protocol
• File Structure and Indexing
  • File Organization: Spanned vs Unspanned File Organization
  • Sparse vs Dense Indexing
  • Primary Indexing, Secondary Indexing, Clustering Indexing.
  • Multilevel-Indexing(B, B+ trees)
  • Storage of B, B+trees and Comparisons.
• Relational Algebra (TRC, DRC)
• SQL Queries
  • [] DDL
  • [] DML
  • [] DCL
• [] SQL vs NOSQL + Project revison

Questions on Other : OS + DBMS + Networking + System Design

• Database Interview Questions

• Operating System Interview Questions

  • https://whimsical.com/operating-system-cheatsheet-by-love-babbar-S9tuWBCSQfzoBRF5EDNinQ
  • CPU, Process, CPU scheduling, threads, multithreads
  • Process Synchronization
  • Deadlock
  • Banker's Algorithm for Deadlock Avoidance.
  • System Calls
  • Memory Management
  • Paging
  • TLB
  • Cache

• Networking Interview Questions

• OOPS Design + Interview Questions

  • Diamond Problem

• System Design + INnterview Questions

• Question on React

  • Basic
  • Hooks
  • Interview bit/Coding Ninjas questions

• Resume Finess

  • Fonts you should use - [ ] Arial, Calibri, Garamond.
  • use a minimum size of 10px for readability.
  • Caution: Never add symbols to your headers to avoid ATS readability issues.
  • use "|" or tabs.
  • Add Git anf Github to skills.
  • Add tech stack to each project.