Detailed notes for this lesson are being written. They appear here together with the video.
Video coming soonThis lesson’s video is being made
Start with the notes below; the video appears here as soon as it is on YouTube.
SQL and Databases · Lesson 87 of 90
SQL interview 10: design, performance and transaction scenarios
schema design interview (parking lot, ride booking, bank)index choice questionswhy is this query slowexplain-plan walkthroughrace condition scenario (double booking, overselling)choosing isolation leveltimed mock interviewedge-case checklist (NULLs, ties, empty groups)