Changing data and files
INSERT INTO, UPDATE and DELETE, then storing data in text and CSV files: open, read, write, append and close.
You will be able to
- Work out the effect of INSERT, UPDATE and DELETE
- Choose the right SQL command for a job
- Choose read, write or append mode
- Process records read from a CSV file
25 minutes, 18 exam-style questions.