Module 7 
School guide
School guideAPIs and database design
Fresher design rounds at Swiggy, Zomato and Uber turned into endpoints, tables and SQL. This module is the bridge from classes to a real backend.
- Lessons
- 5 · 1 h 20 min
- Problems
- 5
- Getting started
- Optional
- SDE-1
- Core
- SDE-2
- Core
- Plan
- Complete
Lessons
- 1REST APIs a reviewer won't fight15 min
- 2Pagination: offset, page number, cursor15 min
- 3Schema design from your classes20 min
- 4Indexes and query cost15 min
- 5Transactions and isolation, in placement terms15 min
Part of Oni. See plans →
Problems
- Not started Follow and unfollow API and DB Difficulty 2 of 5 45 min Swiggy
- Not started Paginated transaction history API and DB Difficulty 2 of 5 45 min District by Zomato
- Not started Delivery partner schema API and DB Difficulty 2 of 5 45 min Zomato
- Not started Splitwise schema and concurrency API and DB Difficulty 3 of 5 45 min
- Not started Messaging app schema API and DB Difficulty 2 of 5 45 min Uber