tables
link tables, column, row
create related tables to implement design including all data dictionary requirements
SQL
select
use SELECT to write SQL code for a query
from
use FROM to write SQL code for a query
where
condition, logical operators AND, OR
use WHERE to write SQL code for a query, including (>, <, =, AND, OR)
order by
use ORDER BY to write SQL code for a query
join
equi-join
use an equi-join (WHERE) to write SQL code for joining tables
insert row
use INSERT to write SQL code for adding a row of data
update
use UPDATE to write SQL code for changing data values
delete row
use DELETE to write SQL code for removing a row data
