Learn
beginner
18 registry resources · 17 tutorials, 1 reference · roadmap: Data Quality, Python + SQL, Orchestration, Warehousing, Reliability, Lakehouse, Agentic Data Engineering
What this topic covers
DE//AGENT currently lists 18 resources under beginner: 17 tutorials, 1 reference. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.
What you can learn here
Documented learning objectives across these resources:
- Write all six parts of a contract for a real dataset — via Author your first data contract
- Specify freshness and completeness numbers in the SLA — via Author your first data contract
- Name the CI test that fails when the contract is violated — via Author your first data contract
- Configure a pre-commit check over staged schema files — via Enforce contracts in CI with the schema change check
- State what lets a breaking change pass — MIGRATION.md or a deprecated_at annotation — via Enforce contracts in CI with the schema change check
- Explain why the gate belongs in the producer's CI, not the consumer's runtime — via Enforce contracts in CI with the schema change check
- Inspect a database with list_tables and describe_table before writing SQL — via First hands-on — a correct SELECT with a justified join
- Write a SELECT with a join whose cardinality is stated and justified — via First hands-on — a correct SELECT with a justified join
41 more objectives live on the individual resource pages.
Where this fits in the learning roadmap
These resources map to stages: Data Quality (3), Python + SQL (6), Orchestration (3), Warehousing (3), Reliability (1), Lakehouse (1), Agentic Data Engineering (1). Follow the four-phase roadmap to place this topic inside a progression instead of learning it in isolation.
Compare the registry's options
Every entry, its shape and its trust state — sorted by the registry's composite score. This table is the honest version of a marketing comparison: no sponsored placements, no unverifiable claims.
| Resource | Type | Difficulty | Verification | Score |
|---|---|---|---|---|
| Author your first data contract | Tutorial | beginner | community | 34.15 |
| Enforce contracts in CI with the schema change check | Tutorial | beginner | community | 34.15 |
| First hands-on — a correct SELECT with a justified join | Tutorial | beginner | community | 34.15 |
| Fix SQL lint with the SQLFluff core rule pack | Tutorial | beginner | community | 34.15 |
| Name the four dimensions of data quality | Tutorial | beginner | community | 34.15 |
| Review a DAG for idempotency and retry safety | Tutorial | beginner | community | 34.15 |
| Review SQL for fan-out joins | Tutorial | beginner | community | 34.15 |
| Run the dbt warehouse tests starter end to end | Tutorial | beginner | community | 34.15 |
| Run the full SQL review pass on a PR | Tutorial | beginner | community | 34.15 |
| Scaffold an idempotent DAG from the template | Tutorial | beginner | community | 34.15 |
| The data reliability mental model — freshness, completeness, correctness | Tutorial | beginner | community | 34.15 |
| The lakehouse mental model — lake vs warehouse vs table formats vs zones | Tutorial | beginner | community | 34.15 |
6 more in the full list below.
How scores are computed: source quality score.
Where to start
Highest composite score first:
- Author your first data contract score 34.15 — beginner
- Enforce contracts in CI with the schema change check score 34.15 — beginner
- First hands-on — a correct SELECT with a justified join score 34.15 — beginner
Scores rank provenance, completeness and trust — read how verification works before adopting anything.
Good fits
Production use cases
- Author your first data contract — Draft an enforceable contract for one real dataset by walking the six parts — owner, schema, semantics, SLA, breaking-change policy, enforcement — starting from the data-contract t… details
- Enforce contracts in CI with the schema change check — Install the Schema Change Check as a pre-commit gate over staged schema files so a breaking change exits non-zero unless a migration plan or deprecation annotation rides along with… details
- First hands-on — a correct SELECT with a justified join — Stand up a local DuckDB through the DuckDB MCP server, inspect before you query with list_tables and describe_table, and write one SELECT with a join whose cardinality you can just… details
- Fix SQL lint with the SQLFluff core rule pack — Install the SQLFluff core rule pack, point it at your warehouse dialect, and lint a fixture that fails on purpose: indentation, keyword capitalisation, SELECT star, and unused CTEs… details
Further study
Adjacent topics: tutorial (17 shared), mental-model (7 shared), review (3 shared), ci (3 shared), data-quality (2 shared), testing (2 shared).
Study path: the roadmap places this topic in a progression · the scoring model explains the numbers · the trust rule catalog shows every security check these entries passed through.
Full resource list
| Resource | Type | Score |
|---|---|---|
| Author your first data contract | Tutorial | 34.15 |
| Enforce contracts in CI with the schema change check | Tutorial | 34.15 |
| First hands-on — a correct SELECT with a justified join | Tutorial | 34.15 |
| Fix SQL lint with the SQLFluff core rule pack | Tutorial | 34.15 |
| Name the four dimensions of data quality | Tutorial | 34.15 |
| Review a DAG for idempotency and retry safety | Tutorial | 34.15 |
| Review SQL for fan-out joins | Tutorial | 34.15 |
| Run the dbt warehouse tests starter end to end | Tutorial | 34.15 |
| Run the full SQL review pass on a PR | Tutorial | 34.15 |
| Scaffold an idempotent DAG from the template | Tutorial | 34.15 |
| The data reliability mental model — freshness, completeness, correctness | Tutorial | 34.15 |
| The lakehouse mental model — lake vs warehouse vs table formats vs zones | Tutorial | 34.15 |