Practical introduction to relational databases
Basic Operations
There are two parts which I think are the basic operations:
- The commands to work with data in tables:
SELECT
,INSERT
,UPDATE
, andDELETE
- Commands to deal with tables:
CREATE
,ALTER
, andDROP
Later on we'll learn (you'll read) about table joins, indexes and constraints, and stored procedures.
Head on over to the table overview section to continue.