SQL And Database Flashcards
What is a field?
A single type of data from a database table.
Downward column
What is a record?
A set of related field on a single entity within a database table
A sidewards row
What is a table?
A complete set of relayed records on the same topic/subject are stored in tables.
The whole big table
What is a primary key
A field that uniquely identifies a record in a table.
What is a foreign key
A primary key of one Table in another table linking the two together.
What is a database?
Databases are structured, persistent collections of data.
What is a relation database
They contain more than one table which are linked/joined together.
How do you insert data into an SQL table?
INSERT INTO (field1, field2…) VALUES (Value1, Value 2,)
Strings need to be put inside quotation marks when listing values
How to update an SQL table?
UPDATE Table name
SET Field name = Value, ,
WHERE =
How do you delete data in SQL
DELETE FROM table name
WHERE field name = condition
How to search on SQL?
SELECT field name
FROM table
WHERE field name = condition
How do you order by ascending or descending
ORDER BY field name ASC/DESC
Where commands