An AI assistant can help explain a report, but counting failures starts with well-defined records. Learn to move from CSV and JSON into tables, write a small SQL query, and decide when a question needs a query or document search. All examples describe fictional runs; no design, simulator, or production database is required.
Lesson | Practical outcome |
|---|---|
Preserve types, units, missing values, and provenance. | |
Define what one row means before joining records. | |
Filter, group, and count without changing the denominator. | |
Use an in-memory sqlite3 dataset with known answers. | |
Choose exact computation, evidence retrieval, or both. |