Data, from zero to hero¶
Data engineering, analytics and databases from absolute zero: plain-English concepts, hands-on builds, architecture patterns, and study guides for every major data certification - free, no signup, nothing gated.
Never written a SQL query, or chasing your next data cert - both start here. Press / to search all 0.8M words.
Start from zero Browse 28 certifications Look up a concept
- 28 certifications
- 7 providers
- 0.8M words
- 3,000+ vendor doc links
- 29 concept pages
- 8 architecture patterns
The path
Data from Scratch¶
Data from Scratch is the plain-English route from "what is a table?" to a data job. Eight phases - SQL, modeling for analytics, pipelines, streaming, quality and governance, data in the cloud, then a fork into data engineer, analytics engineer or DBA, and finally interview prep. Each phase says what you can do once it is done, and links the concept pages, labs and certs that go with it.
The four pillars
Four ways in¶
-
Learn
Plain English, no exam scaffolding. 29 bite-size concept pages - ETL vs ELT, batch vs streaming, lakehouses, modeling - and the Data from Scratch path.
-
Build
A guided end-to-end pipeline build and 8 architecture patterns: data pipeline and ETL, lakehouse, medallion, CDC, data mesh, streaming, reverse ETL and the semantic layer.
-
Certify
28 cert guides across 7 providers, each with a fact sheet, practice plan, scenarios, practice questions and exam-day strategy.
-
Reference
5 cross-cloud service comparisons, 4 career roadmaps, 6 troubleshooting guides, 2 migration guides and 5 interview prep guides.
Quick links
Jump to what you need¶
- Data from Scratch - zero to data engineer, analytics engineer or DBA
- Concepts - 29 five-minute explainers, one idea each
- Cross-site learning paths - seven routes that span cloud, data, security and AI
- Topic indexes - 5 subjects tied across all four pillars
- Build a data pipeline - ingest, transform, load, on a schedule
- Build a dbt project - a tested star schema, step by step
- Lakehouse architecture - the pattern most data platforms now follow
- Database services compared - AWS, Azure and GCP side by side
- Labs by certification - which build backs which exam
- Practice questions - scenario banks with explained answers
- Data engineer interview prep - pipeline design, modeling and SQL questions
- SQL interview guide - joins, top-N, dedup and gaps-and-islands, worked
- DBA interview guide - backups, HA, query plans and locking, worked
- Slow SQL query diagnosis - read the plan, find the cause
- Freshness ledger - what was last verified, and when
- Which Zero to Hero site? - cloud, data, security or AI: pick by goal
The library
Certifications by provider¶
What's new¶
See the CHANGELOG for the rolling history. Recent batches:
- 2026-11-07 - Wave 4 of the content plan: four run-it-for-real hands-on projects (Debezium CDC into Iceberg, local Iceberg lakehouse, backup and restore drill, Dagster pipeline), three troubleshooting guides (replication lag, deadlocks and lock waits, Kafka consumer lag) and topic indexes for streaming, analytics and BI and data governance.
- 2026-10-22 - Two data postmortems (GitLab 2017, Atlassian 2022) and two role interview guides with worked answers: analytics engineer and DBA.
- 2026-10-22 - Four new architecture patterns (CDC into a lakehouse, medallion, reverse ETL, semantic layer), a SQL interview guide and a data modeling and pipeline design interview guide with worked answers, three troubleshooting guides (slow SQL, failing and late pipelines, Spark performance), and a legacy warehouse to cloud migration guide.
The family
More Zero to Hero¶
-
Cloud Zero to Hero
AWS, Azure, GCP, Kubernetes, DevOps and FinOps - from your first terminal command to architect-level certs.
-
Security Zero to Hero
Cloud and application security, identity, compliance, and the security certifications that prove it.
-
AI Zero to Hero
LLMs, machine learning, agents and AI at work - learn it, build with it, govern it, get hired for it.
All four are free, by Nobler Works. Not sure which to start with? Pick a site by your goal.
Who made this¶
Built by Patrick Wiloak - ex-AWS Solutions Architect, 10 years in tech, multi-cloud certified. YouTube · LinkedIn · Website · Source on GitHub
We build custom software and products at Nobler Works. Open-source training like this is how we give back - we are nothing without the community that supports us. If you need software built, get in touch.
Want the reps as well as the material?
This site gives you the material. gitGood gives you the reps, and tells you whether you actually know it. Built for every kind of technologist across 21 role-targeted learning paths - engineering, SRE and DevOps, cloud architecture, security, ML and AI, data science, analytics and engineering, QA, product and TPM, and new grads breaking in.
1,950+ practice questions across 34 categories · certification practice exams for AWS CLF-C02, SAA-C03 and DVA-C02, Azure AZ-900, AZ-104, AZ-305 and AI-900, Google Cloud Digital Leader and Associate Cloud Engineer, Kubernetes CKA and CKAD, CompTIA Security+ and HashiCorp Terraform Associate - original scenario questions, never brain dumps, with per-domain scoring and a timed simulator · coding challenges · SQL playground · system design walkthroughs · AI mock interviews · AI resume reviews · salary coaching · live job-market pulse.
A 7-day free trial, then $8/month or $64/year. The free tier needs no card.
Fine print¶
Free for educational use with attribution. Every technical claim links to the vendor's own documentation - 3,000+ links across the site.
This is an independent educational resource. It is not affiliated with, endorsed by, or sponsored by AWS, Microsoft, Google, Oracle, IBM, or any other vendor referenced. All trademarks belong to their respective owners.
Found something wrong or out of date? Contributions welcome.
