Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases and SQL - Coggle Diagram
Databases and SQL
storing data
variable constant
lists arrays
text files
Read
Write
database
A database is a collection of organised data
key words
Table
collection of data about one subject
Field
1 item of data (column)
Key field
a field where the data is different for every record
Record
All data for one person / thing
SQL commands
SELECT
asterisks select all fields
Field name
FROM
Table name
WHERE
conditions