If you want to get an unfair advantage before your 2nd semester database engineering module begins, mastering relational database design and SQL queries is the highest-leverage skill you can learn. A lot of students make the mistake of watching 10-hour theoretical database video playlists without executing a single real query.
Here is the exact roadmap and curated resources our batch mentors recommended that actually work:
1. SQLBolt (sqlbolt.com): An interactive browser-based tutorial where you learn SELECT, WHERE, JOINs, and aggregates with instant query validation. Finish this in a single weekend.
2. Select Star SQL (selectstarsql.com): An interactive book using real-world Texas execution data to teach window functions, subqueries, and data analysis concepts through authentic investigative problems.
3. Database Design Best Practices: Read Supabase's schema design guides and "Use The Index, Luke" (use-the-index-luke.com) to understand how database indexes (B-trees, GIN, GiST) actually work under the hood. Understanding query execution plans (EXPLAIN ANALYZE) is what separates junior coders from senior engineers.
4. Practice on LeetCode Database section: Solve all 50 top SQL study plan problems covering window functions, CTEs (WITH clauses), and complex multi-table joins. Spend 30 minutes daily, and you will ace your semester lab exams effortlessly.
Edited