SQL Fundamentals (SELECT, JOIN, GROUP BY) — Roadmap Step & Resources
Querying, filtering, joining and aggregating relational data
- Level: intermediate
- Estimated time: 2 days
- Roadmap: Java + Spring Boot
Before this step
Mini projects
- Write queries against a sample e-commerce schema covering joins, grouping and filtering
Interview questions
- INNER JOIN vs LEFT JOIN — what's the difference in the result set?
Study resources
- SQL Tutorial (Article) — W3Schools' widely-used, example-heavy interactive SQL reference.
- SQL Tutorial - Full Database Course for Beginners (Video) — freeCodeCamp's full, widely-watched SQL course covering joins, filtering and aggregation.
Part of
- Databases & SQL — section
- Java + Spring Boot roadmap — the full learning path