Skip to content

Tracks

AI-assisted engineering Working with AI Agents System design Core systems Data and AI systems Coding Coding problems Code review On-call SQL

Practice

Paths Concept guides

FreeAd-supported

The plan adds AI feedback and removes ads.

Concept guides/Backend internals/Database internals

CodingBackend internals

Database internals

Medium3 min read

Questions it teaches

Composite index prefix matchEasy14 min Row store vs column storeEasy15 min Index page fetchesEasy16 min In-memory table filteringEasy15 min Ordered index range scanMedium25 min Hash index point lookupMedium20 min Group by with aggregateMedium25 min Deduplicate change streamMedium25 min

Related

Backend internals Concurrency Observability Consistency and money Secure coding

Builds on: Concurrency

Concurrency primitives3 min Concurrency bugs in review3 min

Leads to: Observability

Cron failures (silent drops)3 min A/b variant regression4 min

Related: Consistency and money

E-commerce inventory (overselling)3 min QR ticketing3 min

Related: Secure coding

Applied crypto & auth3 min WAL replay (crash recovery)3 min

© 2026 Prep Room·From California·AI can make mistakes.

About Legal Contact Cookies Your privacy choices

Home Review Tracks Paths