Volume 1: Foundations: How Everyday Technology Works7/10
  1. 01Digital Foundations 1-10
  2. 02Computer Hardware 11-20
  3. 03Operating Systems 21-30
  4. 04Internet and Networks 31-40
  5. 05The Web 41-50
  6. 06Programming 51-60
  7. 07Data and Databases 61-70
  8. 08Cloud and Modern Infrastructure 71-80
  9. 09Cybersecurity 81-90
  10. 10AI and Emerging Technology 91-100

Chapter 07 of 10

Data and Databases 61-70

10 lessons60 min readingParts 61-70
  1. 01What Is Data?When does information become data a computer can use?6 min read
  2. 02Structured and Unstructured DataWhy are tables easier for software to query than documents or videos?6 min read
  3. 03What Is a Database?Why not keep all application information in ordinary files?6 min read
  4. 04Tables, Rows, and ColumnsHow does a relational database organize information?6 min read
  5. 05SQL QueriesHow do applications ask a relational database for useful information?6 min read
  6. 06Indexes: Faster Data LookupHow can a database find one record without reading every row?6 min read
  7. 07Transactions and ConsistencyHow does a database keep multi-step changes from ending halfway?6 min read
  8. 08Backups and RestoreWhy is copying data not enough unless recovery is tested?6 min read
  9. 09Data Formats: CSV, JSON, and XMLWhy do systems represent the same information in different formats?6 min read
  10. 10Metadata: Data About DataWhat extra information helps people and systems interpret a file or record?6 min read