Best resources to learn SQL and relational database normalization before 2nd sem?
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.