Home

Lecture notes covering UUID impacts on B+Trees, Bloom filters, SQL Server index design, billion-row table strategies, and transaction costs.

Why do analytics queries crawl while transactions blaze? We break down row vs column storage, indexes, and the hidden world of database pages.

This note summarizes a lecture on consistency in database systems, covering types of consistency, eventual consistency in distributed systems, and isolation levels that help maintain reliable data states.

This note summarizes the key concepts of ACID properties (Atomicity, Consistency, Isolation, Durability) in database transactions and the definition of a transaction itself.

My detailed lecture notes on UDP, covering its fundamentals, how it compares with TCP, practical use cases, its advantages and limitations, and an overview of implementing a UDP server in Node.js and C.

A deep dive into the Internet Protocol (IP), covering IP packets, subnets, fragmentation, ICMP, and practical tools like ping and traceroute for backend systems.

A comprehensive review of the OSI model, networking layers, and communication fundamentals including session, presentation, transport layers, proxying, and execution in backend systems.

An in-depth look at backend communication protocols, including their properties, data formats, transfer modes, addressing, reliability, and error handling. This session explores classic and modern protocols such as TCP, UDP, HTTP, gRPC, and Homa.