Free course · 8 units

Data & Databases

From tables to pipelines and scale, about five minutes a lesson: read the cards, then answer on what you read.

  • 8 units
  • 28 lessons
  • 36 cards
  • 164 questions

Syllabus

What you'll learn

4 tiers, from foundations to advanced. Finish every unit and pass the final exam for the certificate.

  1. Foundations

    Tables and queries

    Rows, keys and your first queries

    • Data from zeroTables, rows, keys, your first queries, data types and backups.
    • Checkpoint: Tables and queriesMixed review of tables, keys, SQL basics, types and backups.
  2. Core

    Model and query

    Joins, indexes and transactions

    • Model and queryJoins, normalization, aggregates, indexes, constraints and transactions.
    • Checkpoint: Model and queryJoins, aggregates, indexes, constraints and transactions.
  3. Applied

    Pipelines and analytics

    ETL, warehouses and data quality

    • Pipelines and analyticsOLTP vs OLAP, warehouses, ETL/ELT, star schemas, columnar storage, streaming and data quality.
    • Checkpoint: Pipelines and analyticsWorkloads, warehouses, pipelines, models and data quality.
  4. Advanced

    Scale and recover

    Replicas, shards and backups

    • Scale and recoverReplication, sharding, isolation levels, MVCC, CAP, backups with RPO and RTO.
    • Checkpoint: Scale and recoverReplication, sharding, isolation, CAP and recovery targets.

Try it now · 1 minute

Read one card. Answer two questions.

A real card from the Data from zero unit. No signup.

Lesson card · Data from zero

What a database system does

Plain files
  • You check the rules
  • Edits can clash
  • Crash = lost work
DBMS
  • Rules enforced
  • Safe concurrent edits
  • Recovers after a crash

You could keep data in files, but then you must stop bad data, handle two people editing at once, and survive crashes yourself.

A database management system (DBMS) does that work: it checks rules, runs many requests safely at once, and recovers after a crash.

Relational databases store tables you query with SQL. Document stores keep JSON-like records. Key-value stores look up one value by its key, very fast.

Key idea A DBMS guards your data's rules, edits and recovery.

New words DBMS: database management system: software that stores data and enforces its rules

New words document store: a database that keeps whole JSON-like records

New words key-value store: a database that fetches one value by its key

New words lookup: finding one item directly by its key

Glossary

55 new words, in plain English

Every new word is explained the first time it comes up. A few from this course:

admin rights
full control over a system: the most powerful and risky kind of access
cardinality
how many of one thing can be linked to how many of another
DBMS
database management system: software that stores data and enforces its rules
key-value store
a database that fetches one value by its key
outage
a period when a service is down or not working
scheduled job
a task that runs automatically at set times, such as a nightly job at 2 am

See all 55 terms

FAQ

About this course

Is the Data & Databases course free?

Every course, every lesson and the daily briefing are free forever. Paid plans add extras (no ads, unlimited AI); Elite adds a private course and never locks the core learning. An account is required, and after one sync the lessons work offline.

Do I need to know anything first?

No. It starts from zero and explains every new word the first time. A short placement check can skip what you already know.

How long does it take?

28 lessons of about 5 minutes, across 8 units. Go at your own pace. One lesson a day keeps your streak.

Do I get a certificate?

Yes, on every plan. Finish every unit, then pass the final exam (20 questions, 80% to pass) for a certificate you can check at /verify. It shows you finished the course, and it is not an accredited qualification.

Your first Data & Databases lesson is five minutes away.

Not in the stores yet. Leave your email and we will tell you when it launches.

CEO Hero: launching soon

CEO Hero is not in the app stores yet. Leave your email for one note when it launches on Android.

Used only to tell you once when it launches.