You should be able to:
- Explain what a database is, and why you would use one
- Write SQL queries using some common keywords (
SELECT
,FROM
,WHERE
,ORDER BY
,JOIN
, etc) - Articulate what a primary key is
- Articulate what a foreign key is, and why you would use one
- Explain the differences between a one-to-one, one-to-many, and many-to-many relationship