How santoshkhatri9860/advanced-sql-practice-mysql works
Advanced SQL Practice is a prompts-first workbook for SQL learners: choose a topic, attempt its exercises, then consult separate solutions. Its documented coverage spans subqueries, window functions, CTEs, and date/time patterns. An optional local MySQL setup supports practice with sample data. The README documents the overall workflow and capabilities; no source excerpts were provided, so file-level calls or mappings between individual prompts and solutions cannot be verified.
Main entry points: 01_setup_advanced_sql_practice.sql Database setup · docker-compose.yml Optional Docker setup · 01_subqueries.sql Subqueries, EXISTS · 02_exists_correlated.sql Correlated EXISTS
Components 17
Practice prompts
- Subqueries, EXISTS
exercises/01_subqueries/01_subqueries.sql - Correlated EXISTS
exercises/02_exists_correlated/02_exists_correlated.sql - Window functions
exercises/03_window_basics/03_window_basics.sql - Window frames
exercises/04_window_frames/04_window_frames.sql - LAG and LEAD
exercises/05_lag_lead/05_lag_lead.sql - ROW_NUMBER
exercises/06_row_number/06_row_number.sql - Rank functions
exercises/07_rank_dense_rank/07_rank_dense_rank.sql - CTEs
exercises/08_cte_non_recursive/08_cte_non_recursive.sql - Multi-CTE
exercises/09_cte_multi/09_cte_multi.sql - Recursive numbers
exercises/10_recursive_cte_numbers/10_recursive_cte_numbers.sql - Recursive hierarchy
exercises/11_recursive_cte_hierarchy/11_recursive_cte_hierarchy.sql - Date and time
exercises/12_datetime/12_datetime.sql
Reference solutions
- Solution collection
solutions
Local database
- Database setup
db/init/01_setup_advanced_sql_practice.sql - Optional Docker setup
docker-compose.yml
Other components
- Learner
- MySQL
Connections 15
- Learner → Subqueries, EXISTS: practices
README.md - Learner → Correlated EXISTS: practices
README.md - Learner → Window functions: practices
README.md - Learner → Window frames: practices
README.md - Learner → LAG and LEAD: practices
README.md - Learner → ROW_NUMBER: practices
README.md - Learner → Rank functions: practices
README.md - Learner → CTEs: practices
README.md - Learner → Multi-CTE: practices
README.md - Learner → Recursive numbers: practices
README.md - Learner → Recursive hierarchy: practices
README.md - Learner → Date and time: practices
README.md - Learner → Solution collection: checks work
README.md - Database setup → MySQL: sets up
README.md - Optional Docker setup → MySQL: optionally starts
README.md