santoshkhatri9860/advanced-sql-practice-mysql 开源项目中文解读：技术栈、适用场景与上手建议

项目介绍

santoshkhatri9860/advanced-sql-practice-mysql 是一个托管在 GitHub 上的开源项目，主要使用 HTML 编写，采用 MIT License 许可证，目前获得 101 个 Star、28 次 Fork。

仓库全名: santoshkhatri9860/advanced-sql-practice-mysql

README 摘要

Advanced SQL Practice Live site (GitHub Pages): https://santoshkhatri9860.github.io/advanced-sql-practice-mysql/ Exercise Index: https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/README.md Quickstart (setup + smoke test): https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/docs/QUICKSTART.md A practice-first SQL workbook with 1,400+ topic-wise questions —…

完整内容见 GitHub 原始 README 或本页。

常见问题

advanced-sql-practice-mysql 用什么语言开发？

主要使用 HTML 编写，采用 MIT License 许可证，目前有 101 个 Star。

advanced-sql-practice-mysql 可以免费商用吗？

如何获取 advanced-sql-practice-mysql 的源码？

可以直接克隆仓库：git clone https://github.com/santoshkhatri9860/advanced-sql-practice-mysql.git，默认分支为 main；安装与运行步骤见仓库 README。

advanced-sql-practice-mysql 最近还在维护吗？

仓库最近一次更新为 1月12日，当前没有未关闭的 Issue；Star 数为 101，可作为社区活跃度的参考。

关于

Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.

advanced-sql cte data-analyst data-analytics mysql recursive-cte recursive-ctes sql sql-interview sql-interview-questions sql-practice subqueries window-functions

MIT License
101 Stars
28 Forks
0 Watching

描述取自 GitHub 官方 API，中文内容由 GitRead 中文社区编辑团队整理。

简要分析

热度分

157

价值分

活跃状态

活跃

GitHub

语言占比

HTML

贡献者

santoshkhatri9860

Advanced SQL Practice

Live site (GitHub Pages): https://santoshkhatri9860.github.io/advanced-sql-practice-mysql/
Exercise Index: https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/README.md
Quickstart (setup + smoke test): https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/docs/QUICKSTART.md

A practice-first SQL workbook with 1,400+ topic-wise questions — from fundamentals to advanced patterns — built for job prep, interviews, and real-world SQL fluency.

Most sites explain advanced SQL concepts, but don’t provide enough structured, high-volume practice. This repo is designed to fix that: prompts first, then separate solutions so you can practice properly and verify fast.

Best for: learners • job seekers • interview prep • anyone leveling up SQL

What you’ll practice

Subqueries + EXISTS
Correlated subqueries
Window functions (aggregate, ranking, frames)
LAG() / LEAD()
CTEs (non-recursive + multi-CTE)
Recursive CTEs (numbers + employee hierarchy)
Date/Time functions

Repo structure

exercises/ → prompts-only (try first)
solutions/ → complete solutions (reference after)
db/ → local DB setup + seed scripts
docker-compose.yml → optional local MySQL setup
docs/ → how to use + roadmap + style guide
archive/ → original work preserved without changes

Quick start

Read: docs/HOW_TO_USE.md
Start practicing: exercises/README.md
Check your work: solutions/

Want a local database with sample data? See db/ (Docker is optional).

Recommended learning path

Subqueries
EXISTS + correlated subqueries
Window functions (ROW_NUMBER, RANK/DENSE_RANK)
Window frames
LAG/LEAD
CTEs
Recursive CTEs
Date/Time patterns

Who this is for

Beginners who know basic SQL and want to level up with real practice
Data analysts preparing for SQL interviews
Anyone who wants a structured workbook instead of random questions

Notes

MySQL 8+ recommended (for CTEs + window functions).
SQL often has multiple correct answers — solutions are reference implementations.

Support

If this repo helps you practice SQL, consider starring it ⭐ — it helps more learners discover it.

暂无评论

advanced-sql-practice-mysql