A database stores data in an organised way so it can be searched and sorted. This topic covers single-table databases and the terms used to describe them: records, fields, and the primary key that uniquely identifies each record. You will choose appropriate data types for fields and apply validation. Structured Query Language is then used to extract data, covering SELECT, FROM, WHERE, ORDER BY, SUM and COUNT, and how these combine to answer a question.
🔒 Sign in to view this topic's basics.