Learning path
SQL
Guided path · 1 stage · 18 resources
The guided path
Set-based thinking, window functions, CTEs and query plans. The highest-ROI skill in the field. This path sequences the category's 18 resources by roadmap stage and composite score — work top-down inside each step.
Python + SQL
- DuckDB / MotherDuck MCP Server 44.4 — DuckDB / MotherDuck MCP Server
- SQL Review 39.9 — A review pass that catches correctness bugs before the query reaches production.
- SQLFluff Core Rule Pack 39.7 — Production-ready SQL linting rules for dbt, Spark, and warehouse dialects
- SQL Query Plan Explainer 38.5 — Translate an EXPLAIN plan into plain language and the one change worth making.
- SQL Reviewer 34.5 — SQL Reviewer
- First hands-on — a correct SELECT with a justified join 34.15 — First hands-on — a correct SELECT with a justified join
12 more on the category page.
Prerequisites across the path
Documented prerequisites, deduplicated: skill-sql-review.
What you will be able to do
- Prove a join cannot fan out before writing it
- Spot NULL-unsafe `NOT IN` and `=` predicates
- State the grain of a result set in one sentence
- Configure SQLFluff for your warehouse dialect
- Customize rules for team standards
- Integrate SQLFluff into CI/CD pipelines
- Fix legacy SQL debt incrementally
- Read a plan bottom-up and name the expensive node
Before you start
Security-flagged: DuckDB / MotherDuck MCP Server, SQL Review, SQLFluff Core Rule Pack, SQL Query Plan Explainer, SQL Reviewer — review the security posture first. Verification on these records: 18 community. Nothing here is independently audited — the trust scan and your own review are the controls.
Where this sits
Phase 1 of the roadmap. Stage context: Python + SQL · side-by-side comparison · all learning topics