SyntaxPilot
Courses/SQL and Databases/Lesson 89
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 89 of 90

Project 2: a concurrent ticket-booking system

OLTP design for seats and bookingsconstraints preventing double bookingtransactions with BEGIN IMMEDIATEoptimistic locking with version columnaudit triggerindexes for hot queriesload test with Python threads

Detailed notes for this lesson are being written. They appear here together with the video.