How the optimizer picks an index

Reading an execution plan end to end

Isolation levels and what each one actually prevents

Multi-tenant row filtering without leaking data